1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help Please! Having trouble!

Discussion in 'Web Hosting' started by ssellers, May 13, 2010.

  1. ssellers

    ssellers Regular Member

    Joined:
    May 10, 2010
    Messages:
    294
    Likes Received:
    67
    Location:
    On This Forum
    Okay, I JUST got a domain and hosting, and I am attempting to install phpbb3 on the domain.

    I have done this before, but it is giving me some weird error this time.

    I go to the site, get to the end of the installation of the forum, and get this error message

    Code:
           [B]A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.[/B]
    
         install_install.php [ 1193 ]
    SQL : CREATE TABLE phpbb_attachments (     attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,     post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,     topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,     in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,     poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,     is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,     physical_filename varchar(255) DEFAULT '' NOT NULL,     real_filename varchar(255) DEFAULT '' NOT NULL,     download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,     attach_comment text NOT NULL,     extension varchar(100) DEFAULT '' NOT NULL,     mimetype varchar(100) DEFAULT '' NOT NULL,     filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,     filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,     thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,     PRIMARY KEY (attach_id),     KEY filetime (filetime),     KEY post_msg_id (post_msg_id),     KEY topic_id (topic_id),     KEY poster_id (poster_id),     KEY is_orphan (is_orphan) ) CHARACTER SET `utf8` COLLATE `utf8_bin`
    [B]CREATE command denied to user 'tmnsheltons'@'97.74.215.127' for table 'phpbb_attachments'[/B]
     
      
    
    I created the database, and THINK it should be allowed to make the tables.

    Anyone know?


    Thanks!
     
  2. homenet

    homenet Power Member

    Joined:
    Jan 5, 2009
    Messages:
    790
    Likes Received:
    338
    Location:
    Dimension X
    Looks like the user 'tmnsheltons' doesnt have permission to create a table.. I would check your permissions settings for that user.
     
    • Thanks Thanks x 1
  3. Grizzy

    Grizzy Senior Member

    Joined:
    Nov 11, 2008
    Messages:
    919
    Likes Received:
    999
    The error is pretty straight forward, that mysql user does not have the permission to create tables. Talk to your hosting company and get them to sort this out, it's a simple fix if you have root access to the sql server.

    You might want to consider editing your post (blanking out the username and IP address). You giving away a lot of information on a public forum.. Be careful.
     
    • Thanks Thanks x 1
  4. ssellers

    ssellers Regular Member

    Joined:
    May 10, 2010
    Messages:
    294
    Likes Received:
    67
    Location:
    On This Forum
    Okay, fixed that (Stupid Mistake :p)

    But NOW I have another problem.
    I JUST set up the phpbb3 all the way through, deleted the /install directory, and went to the link for my site.


    All it says is "The service is not available" in black, on a white screen.


    Any suggestions?
    I know I am a n00b! :p