Skip to:
Content
Pages
Categories
Search
Top
Bottom

[Resolved] Database errors on Forums page

  • Avatar of IndieConnect
    IndieConnect
    Member

    @indieconnect

    I was able to install BuddyPress and it looks great except for the Forums page. Here I get a lot of Database Errors. I had it previously installed and have a long history with @mercime so I am not sure if I did something to corrupt my innerds or if I just need to configure something to make it play nice. The Forums are included in BuddyPress, right? Or do I need to add bbPress?

    Website: indieconnect.com
    WP 3.3.2
    Theme: PageLines, with their Base Theme child theme
    BuddyPress: 1.5.5
    WishList Member: 2.71.1166

    Here are the error messages. You might get a beverage -

    ‘WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_forums' doesn't exist]
    DESCRIBE wp_bb_forums;

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_meta' doesn't exist]
    SELECT meta_value FROM wp_bb_meta WHERE object_type = ‘bb_option’ AND meta_key = ‘wp_table_prefix’

    WordPress database error: [Unknown collation: 'DB_COLLATE']
    CREATE TABLE wp_bb_forums ( forum_id int(10) NOT NULL auto_increment, forum_name varchar(150) NOT NULL default ”, forum_slug varchar(255) NOT NULL default ”, forum_desc text NOT NULL, forum_parent int(10) NOT NULL default 0, 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), KEY forum_slug (forum_slug) ) DEFAULT CHARACTER SET ‘utf8′ COLLATE ‘DB_COLLATE’;

    WordPress database error: [Unknown collation: 'DB_COLLATE']
    CREATE TABLE wp_bb_meta ( meta_id bigint(20) NOT NULL auto_increment, object_type varchar(16) NOT NULL default ‘bb_option’, object_id bigint(20) NOT NULL default 0, meta_key varchar(255) default NULL, meta_value longtext default NULL, PRIMARY KEY (meta_id), KEY object_type__meta_key (object_type, meta_key), KEY object_type__object_id__meta_key (object_type, object_id, meta_key) ) DEFAULT CHARACTER SET ‘utf8′ COLLATE ‘DB_COLLATE’;

    WordPress database error: [Unknown collation: 'DB_COLLATE']
    CREATE TABLE wp_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_time (topic_id, post_time), KEY poster_time (poster_id, post_time), KEY post_time (post_time), FULLTEXT KEY post_text (post_text) ) ENGINE = MYISAM DEFAULT CHARACTER SET ‘utf8′ COLLATE ‘DB_COLLATE’;

    WordPress database error: [Unknown collation: 'DB_COLLATE']
    CREATE TABLE wp_bb_terms ( term_id bigint(20) NOT NULL auto_increment, name varchar(55) NOT NULL default ”, slug varchar(200) NOT NULL default ”, term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), UNIQUE KEY slug (slug), KEY name (name) ) DEFAULT CHARACTER SET ‘utf8′ COLLATE ‘DB_COLLATE’;

    WordPress database error: [Unknown collation: 'DB_COLLATE']
    CREATE TABLE wp_bb_term_relationships ( object_id bigint(20) NOT NULL default 0, term_taxonomy_id bigint(20) NOT NULL default 0, user_id bigint(20) NOT NULL default 0, term_order int(11) NOT NULL default 0, PRIMARY KEY (object_id, term_taxonomy_id), KEY term_taxonomy_id (term_taxonomy_id) ) DEFAULT CHARACTER SET ‘utf8′ COLLATE ‘DB_COLLATE’;

    WordPress database error: [Unknown collation: 'DB_COLLATE']
    CREATE TABLE wp_bb_term_taxonomy ( term_taxonomy_id bigint(20) NOT NULL auto_increment, term_id bigint(20) NOT NULL default 0, taxonomy varchar(32) NOT NULL default ”, description longtext NOT NULL, parent bigint(20) NOT NULL default 0, count bigint(20) NOT NULL default 0, PRIMARY KEY (term_taxonomy_id), UNIQUE KEY term_id_taxonomy (term_id, taxonomy), KEY taxonomy (taxonomy) ) DEFAULT CHARACTER SET ‘utf8′ COLLATE ‘DB_COLLATE’;

    WordPress database error: [Unknown collation: 'DB_COLLATE']
    CREATE TABLE wp_bb_topics ( topic_id bigint(20) NOT NULL auto_increment, topic_title varchar(100) NOT NULL default ”, topic_slug varchar(255) 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 topic_slug (topic_slug), KEY forum_time (forum_id, topic_time), KEY user_start_time (topic_poster, topic_start_time), KEY stickies (topic_status, topic_sticky, topic_time) ) DEFAULT CHARACTER SET ‘utf8′ COLLATE ‘DB_COLLATE’;

    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id)

    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_users ADD PRIMARY KEY (ID)

    WordPress database error: [Duplicate entry 'Truebeliever' for key 'user_login']
    ALTER TABLE wp_users ADD UNIQUE KEY user_login (user_login)

    WordPress database error: [Duplicate key name 'user_nicename']
    ALTER TABLE wp_users ADD UNIQUE KEY user_nicename (user_nicename)

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_meta' doesn't exist]
    SELECT * FROM wp_bb_meta WHERE object_type = ‘bb_option’ AND object_id = 0 AND meta_key = ‘bb_db_version’

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_meta' doesn't exist]
    INSERT INTO wp_bb_meta ( object_type, object_id, meta_key, meta_value ) VALUES( ‘bb_option’, 0, ‘bb_db_version’, ’2471′ ) ON DUPLICATE KEY UPDATE meta_value = VALUES( meta_value )

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_forums' doesn't exist]
    SELECT MAX(forum_order) FROM wp_bb_forums

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_forums' doesn't exist]
    SELECT forum_slug FROM wp_bb_forums WHERE forum_slug = ‘default-forum’

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_forums' doesn't exist]
    INSERT INTO wp_bb_forums (forum_name,forum_slug,forum_desc,forum_parent,forum_order) VALUES (‘Default Forum’,’default-forum’,”,’0′,’1′)

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_meta' doesn't exist]
    SELECT * FROM wp_bb_meta WHERE object_type = ‘bb_option’ AND object_id = 0 AND meta_key = ‘uri’

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_meta' doesn't exist]
    INSERT INTO wp_bb_meta ( object_type, object_id, meta_key, meta_value ) VALUES( ‘bb_option’, 0, ‘uri’, ‘http://www.indieconnect.com/wp-content/plugins/buddypress/bp-forums/bbpress/’ ) ON DUPLICATE KEY UPDATE meta_value = VALUES( meta_value )

    WordPress database error: [Table '190bbcc4-1935-42b8-8b29-60ddf6bda134.wp_bb_topics' doesn't exist]
    SELECT t.*, g.id as object_id, g.name as object_name, g.slug as object_slug FROM wp_bb_topics AS t JOIN wp_bp_groups AS g LEFT JOIN wp_bp_groups_groupmeta AS gm ON g.id = gm.group_id WHERE (gm.meta_key = ‘forum_id’ AND gm.meta_value = t.forum_id) AND t.topic_poster = ’161′ AND t.topic_status = ’0′ ORDER BY t.topic_time DESC LIMIT 20′

    Thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • Avatar of @mercime
    @mercime
    Keymaster

    @mercime

    @indieconnect basically it means that there are no Group Forums tables created in your database. Check root of your install for a bb-config.php file. If there is one, double-check if the DB information there is the same as the DB info in your wp-config.php file. If DB is the same go again to BuddyPress > Forums and Install Group Forums.

    We support 2 kinds of bbPress forums – Group Forums (BP internal bbPress) and Sitewide Forums (bbPress plugin) – http://codex.buddypress.org/getting-started/installing-group-and-sitewide-forums/

    Avatar of IndieConnect
    IndieConnect
    Member

    @indieconnect

    I dissected what you said. I looked at and gingerly poked at the files. I got someone who knows more and we moved some stuff and tried different things. We narrowed it down to the fact that the install was not going to completion – wp-config and/or bb-config were not communicating with the rest of the site to finish the process. So I contacted my hosting gods and they have made the error messages disappear. I am not sure it is truly fixed – we cannot figure out how to create a forum or group and see no admin resources to set stuff up. How do I know if the installation is complete?

    Avatar of IndieConnect
    IndieConnect
    Member

    @indieconnect

    Hey! We found the pages with the Member Directory, Groups and Forums. I think we may have it! I will let you know if we have further challenges… Yea!

    Avatar of @mercime
    @mercime
    Keymaster

    @mercime

    @indieconnect Great! Crossing my fingers and toes :-)

    Avatar of Joshua Craig
    Joshua Craig
    Participant

    @helpfulnerd

    @mercime just want to say thanks for posting this fix.

    I totally forgot about the bp-config file after moving a site recently. Was hitting my head against the wall.

    Not any more thanks to a Google Search and your advice.

    Thanks

    Avatar of @mercime
    @mercime
    Keymaster

    @mercime

    @helpfulnerd Glad you solved the mystery of the missing bb-config.php file. Cheers.

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

You must be logged in to reply to this topic.