New to the community? Start here

WP 3.04 BP 1.2.7 Multi-Db – Forum is not working

Hi,

I’ve install multi-db on WP multisite 3.04 and buddypres 1.2.7. Everything is working ok except forum (bbpress).

I cannot create forum from my existing group, and all old forum topic is not accessible after multi-db instalation.

Can you help me please?

Best regards,

srecko

Mon, 17 Jan 2011 23:59:13
  • msrecko
    • Flash Drive

    Hi,

    thank you for quick response.

    In my log, I found and filter (wp_bb* related rows):

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bb_forums ADD PRIMARY KEY (forum_id) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bb_meta ADD PRIMARY KEY (meta_id) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘object_type__meta_key’ for query ALTER TABLE wp_bb_meta ADD KEY object_type__meta_key (object_type, meta_key) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘object_type__object_id__meta_key’ for query ALTER TABLE wp_bb_meta ADD KEY object_type__object_id__meta_key (object_type, object_id, meta_key) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bb_posts ADD PRIMARY KEY (post_id) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘topic_time’ for query ALTER TABLE wp_bb_posts ADD KEY topic_time (topic_id, post_time) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘poster_time’ for query ALTER TABLE wp_bb_posts ADD KEY poster_time (poster_id, post_time) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘post_text’ for query ALTER TABLE wp_bb_posts ADD FULLTEXT KEY post_text (post_text) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bb_term_relationships ADD PRIMARY KEY (object_id, term_taxonomy_id) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bb_term_taxonomy ADD PRIMARY KEY (term_taxonomy_id) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘term_id_taxonomy’ for query ALTER TABLE wp_bb_term_taxonomy ADD UNIQUE KEY term_id_taxonomy (term_id, taxonomy) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bb_terms ADD PRIMARY KEY (term_id) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bb_topics ADD PRIMARY KEY (topic_id) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘forum_time’ for query ALTER TABLE wp_bb_topics ADD KEY forum_time (forum_id, topic_time) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘user_start_time’ for query ALTER TABLE wp_bb_topics ADD KEY user_start_time (topic_poster, topic_start_time) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

    Jan 18 17:52:13 server1.centos httpd: WordPress database error Duplicate key name ‘stickies’ for query ALTER TABLE wp_bb_topics ADD KEY stickies (topic_status, topic_sticky, topic_time) made by require, wp, WP->main, do_action_ref_array, call_user_func_array, bp_forums_directory_forums_setup, do_action, call_user_func_array, bp_forums_load_bbpress, dbDelta, m_wpdb->query

  • LCDist
    • The Incredible Code Injector

    I was running into the same trouble, I used the same fix for now… but since I dont know coding nearly as well as I should… How do I add a db for bbpress specifically barry? I thought they had to be synced with the main wp dbase for usernames etc