+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    OP Enthusiast DhanB's Avatar
    Join Date
    Aug 2009
    Location
    Toronto, Canada
    Posts
    169

    Reputation: 42

    Default Forum setup help :( PHPBB3


    Register on the forums to remove this ad!
    I get this error when i am trying to setup my forum i've looked everywhre for a solution but since i'm a COMPLETE noob at PHP and mySql ( i didn't even know wtf it was until a few hours ago) i have no idea what to do about it... HALP


    hers the error i get


    Code:
    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.
    
    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`
    CREATE command denied to user 'Dhan'@'XX.XX.XXX' for table 'phpbb_attachments'
    : killlbot@hotmail.com : dhanushkab : twitter.com/dhanb

    New music Website/Forum www.torontolive.tk visit and support

  2. #2
    OP Legend
    Join Date
    Jul 2009
    Location
    New Jersey
    Posts
    2,172

    Reputation: 477

    Default

    This just means that you don't have the permission to alter the database. Go into your cPanel, and go to your database, and create a new user. Then give him all of the permissions for the database you created for this phpBB setup.
    kid cudi, lupe fiasco, wiz khalifa. <3
    R.I.P Armani

  3. #3
    OP Legend mohaas05's Avatar
    Join Date
    Jun 2009
    Location
    Blacksburg
    Posts
    8,470

    Reputation: 2713

    Default

    Are you using a hosted server or your own?

    If it was your own, you'd just log into the mysql console as admin and do:

    grant all on 'table.*' to 'user@localhost' identified by 'password';
    Last edited by mohaas05; 08-02-2010 at 12:41 PM.

    2009 OwnagePranks Most Annoying Poster
    2009 OwnagePranks Most Talkative Poster
    2009 OwnagePranks Most Active Poster
    2009 OwnagePranks Biggest Forum Spammer

  4. #4
    George's Avatar
    Join Date
    Jun 2008
    Location
    Greece
    Posts
    4,046

    Reputation: 1893

    Default

    I agree with all of the above answers.
    + internets for you guys


  5. #5
    OP Enthusiast DhanB's Avatar
    Join Date
    Aug 2009
    Location
    Toronto, Canada
    Posts
    169

    Reputation: 42

    Default

    thanks guys i got it running

    Join ;D

    torontoliveboards.tk
    : killlbot@hotmail.com : dhanushkab : twitter.com/dhanb

    New music Website/Forum www.torontolive.tk visit and support

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts