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

  • msrecko

    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

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.