Skip to:
Content
Pages
Categories
Search
Top
Bottom

Step Two Database Error


  • boomanfloral
    Member

    @boomanfloral

    Hi,

    I just installed bbPress and on STEP TWO I got a screen with the error below. I’m not a programmer or anything, I just know basic HTML and that’s it, so I don’t know where to look for a way to fix this. Can anyone give me some pointers on how to fix this? Or is there a service where I can pay to have this fixed and running smoothly? Thanks!

    bbPress database error

    Second Step

    Now we’re going to create the database tables and fill them with some default data.

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default '', forum_desc text NOT NULL, forum_order int(10) NOT NULL default '0', topics bigint(20) NOT NULL default '0', posts bigint(20) NOT NULL default '0', PRIMARY KEY (forum_id) )

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_posts ( post_id bigint(20) NOT NULL auto_increment, forum_id int(10) NOT NULL default '1', topic_id bigint(20) NOT NULL default '1', poster_id int(10) NOT NULL default '0', post_text text NOT NULL, post_time datetime NOT NULL default '0000-00-00 00:00:00', poster_ip varchar(15) NOT NULL default '', post_status tinyint(1) NOT NULL default '0', post_position bigint(20) NOT NULL default '0', PRIMARY KEY (post_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time), FULLTEXT KEY post_text (post_text) ) TYPE = MYISAM

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_topics ( topic_id bigint(20) NOT NULL auto_increment, topic_title varchar(100) NOT NULL default '', topic_poster bigint(20) NOT NULL default '0', topic_poster_name varchar(40) NOT NULL default 'Anonymous', topic_last_poster bigint(20) NOT NULL default '0', topic_last_poster_name varchar(40) NOT NULL default '', topic_start_time datetime NOT NULL default '0000-00-00 00:00:00', topic_time datetime NOT NULL default '0000-00-00 00:00:00', forum_id int(10) NOT NULL default '1', topic_status tinyint(1) NOT NULL default '0', topic_open tinyint(1) NOT NULL default '1', topic_last_post_id bigint(20) NOT NULL default '1', topic_sticky tinyint(1) NOT NULL default '0', topic_posts bigint(20) NOT NULL default '0', tag_count bigint(20) NOT NULL default '0', PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_time (topic_time), KEY topic_start_time (topic_start_time) )

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_topicmeta ( meta_id bigint(20) NOT NULL auto_increment, topic_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY user_id (topic_id), KEY meta_key (meta_key) )

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default '', user_pass varchar(64) NOT NULL default '', user_nicename varchar(50) NOT NULL default '', user_email varchar(100) NOT NULL default '', user_url varchar(100) NOT NULL default '', user_registered datetime NOT NULL default '0000-00-00 00:00:00', user_status int(11) NOT NULL default '0', display_name varchar(250) NOT NULL default '', PRIMARY KEY (ID), UNIQUE KEY user_login (user_login) )

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_usermeta ( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) )

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_tags ( tag_id bigint(20) unsigned NOT NULL auto_increment, tag varchar(200) NOT NULL default '', raw_tag varchar(50) NOT NULL default '', tag_count bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (tag_id) )

    bbPress database error: [Access denied for user 'boomanfloral'@'localhost' to database 'mysql']
    CREATE TABLE bb_tagged ( tag_id bigint(20) unsigned NOT NULL default '0', user_id bigint(20) unsigned NOT NULL default '0', topic_id bigint(20) unsigned NOT NULL default '0', tagged_on datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (tag_id,user_id,topic_id), KEY tag_id_index (tag_id), KEY user_id_index (user_id), KEY topic_id_index (topic_id) )

    1. Created table bb_forums
    2. Created table bb_posts
    3. Created table bb_topics
    4. Created table bb_topicmeta
    5. Created table bb_users
    6. Created table bb_usermeta
    7. Created table bb_tags
    8. Created table bb_tagged

    bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist]
    SELECT * FROM bb_topicmeta WHERE topic_id = '0' AND meta_key = 'bb_db_version'

    bbPress database error: [Table 'mysql.bb_topicmeta' doesn't exist]
    INSERT INTO bb_topicmeta ( topic_id, meta_key, meta_value ) VALUES ( '0', 'bb_db_version', '688' )

    bbPress database error: [Table 'mysql.bb_users' doesn't exist]
    INSERT INTO bb_users (user_login, user_pass, user_email, user_url, user_registered) VALUES ('daniel', 'fae46cfefe5fb87eedf6f8801e497d06', 'daniel@boomanfloral.com', 'http://boomanfloral.com', '2007-03-14 22:01:31')

    bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
    SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'from'

    bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
    INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'from', 'Vista, CA' )

    bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
    SELECT * FROM bb_usermeta WHERE user_id = '1' AND meta_key = 'interest'

    bbPress database error: [Table 'mysql.bb_usermeta' doesn't exist]
    INSERT INTO bb_usermeta ( user_id, meta_key, meta_value ) VALUES ( '1', 'interest', 'Unusual Plants & Internet' )

    bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '', , '', '2007]
    INSERT INTO bb_topics (topic_title, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id) VALUES ('Your first topic', , '', , '', '2007-03-14 22:01:31', '2007-03-14 22:01:31', 1)

    bbPress database error: [Table 'mysql.bb_topics' doesn't exist]
    SELECT * FROM bb_topics WHERE topic_id = 0 AND topic_status = 0

    bbPress database error: [Table 'mysql.bb_forums' doesn't exist]
    UPDATE bb_forums SET topics = topics + 1 WHERE forum_id = 1

    bbPress database error: [Table 'mysql.bb_topics' doesn't exist]
    SELECT * FROM bb_topics WHERE topic_id = 1 AND topic_status = 0

    Finished!

Viewing 3 replies - 1 through 3 (of 3 total)
  • It would seem that it didn’t work from the errors because your database user doesn’t have the proper permissions to create tables. You will need to update the permissions of the database user and then run the script again! Once the permissions are set right, it will install easy for you!

    Trent


    boomanfloral
    Member

    @boomanfloral

    Thanks for the advice!

    I’m using Yahoo Webhosting Services. I looked around, and I don’t see where to change those ‘permissions’ :( Does anyone know?

    Thanks again!

    daniel

    You have to enter the right password and username in config.php to your databases.

    I don’t know what Yahoo Webhosting entails, but unless it says MySQL tables somewhere you can’t use it. You need hosting that allows you to create MySQL databases, and they should be able to tell you your details to log into that. :)

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.