Skip to:
Content
Pages
Categories
Search
Top
Bottom

[fixed] BuddyPress + bbPress activity stream bug

  • Hi there BP community. I’m kinda new to BP, so please excuse me if posting nonesense or asking for something which has been reported already.

    We’ve been experiencing this strange behaviour on our WP MU + BP + BBP network. url for the site is http://italianproplayers.com

    When users replay to a forum topic, the event which gets added to the activity stream shows some weird JS code instead of what you would normally expect:

    please note: the bug presents itself when users replay to topics in the site’s own forums (bbpress 2.0.2 plusgin) rather than BP’s own forums.

    (function(d, s, id) {
    var js, fjs = d.getElementsByTagName(s)[0];
    if (d.getElementById(id)) return;
    js = d.createElement(s); js.id = id;
    js.src = […]

    I’m trying to troubleshoot and fix this issue, but I though I might as well post this on the support forums.

    I won’t go as long as posting every detail about the install, but this is what I think applies for the most part to this issue:
    MU WP install
    BuddyPress (no multiblog)
    BP forums for groups enabled
    BBP plugin 2.0.2 (standalone forums for sub-domains activated)

    Relevant BBP plugins installed:
    bbpress2 bbcode (http://bbpressbbcode.chantech.org/)
    bbpress2 shortcode whitelist (http://bbpressbbcode.chantech.org/)

    If I had to pick, I would say the bug is because of bbpress2 plugins incompatibility with buddypress, but I still wasn’t able to identify what egsactly is causing this.

    Please help, thank you in advance!

Viewing 8 replies - 1 through 8 (of 8 total)
  • Anything in your web browser’s javascript console (if you know how to access it) when users reply to a forum topic? Anything added to your web server’s PHP error log? (Ask your host for help if you are not sure how to access that).

    will check. thanks for the fast replay btw

    I can confirm no javascript error is encountered when I reply to a forum’s topic. Just checked with chrome’s debug console. The erroneous behaviour seems to be occurring consistently.

    Will now check for PHP error logs

    Just to put this even more clearly.

    This happens with bbpress 2.0.2 plugin forum’s. This forums have not been installed through the BP forum settings admin panel, but rather through bbpress’ own dashboard panel.

    Hope this helps a bit more

    digging into the error log scared me :|

    I replicated the bug, and these are the last few lines from the error log:

    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query
    UPDATE wp_2_posts
    SET post_modified = '2012-05-12 22:48:46',
    post_modified_gmt = '2012-05-12 20:48:46'
    WHERE post_status='publish'
    AND ( ID = 418 OR ID = 347 OR ID = 348 OR ID = 365 OR ID = 366) made by require, require_once, require_once, require_once, do_action, call_user_func_array, live_streams_update_streams, live_streams_update_post_modified
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query
    UPDATE wp_2_postmeta
    SET meta_value = '399'
    WHERE meta_key = 'live_viewers'
    AND ( post_id = 365) made by require, require_once, require_once, require_once, do_action, call_user_func_array, live_streams_update_streams, live_streams_update_live_streams_viewers
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query  SELECT   wp_2_posts.* FROM wp_2_posts  WHERE 1=1  AND wp_2_posts.post_name = 'regolamento-forumobbligatorio' AND wp_2_posts.post_type = 'topic'  ORDER BY wp_2_posts.post_date DESC  made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT post_id FROM wp_2_postmeta, wp_2_posts WHERE ID = post_id AND post_type = 'topic' AND meta_key = '_wp_old_slug' AND meta_value = 'regolamento-forumobbligatorio' made by require, require_once, do_action, call_user_func_array, wp_old_slug_redirect
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT ID FROM wp_2_posts WHERE post_name LIKE 'regolamento-forumobbligatorio%' AND post_type = 'topic' AND post_status = 'publish' made by require, require_once, do_action, call_user_func_array, redirect_canonical, redirect_guess_404_permalink
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'can_compress_scripts' AND site_id = 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, wp_print_head_scripts, print_head_scripts, script_concat_settings, get_site_option
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'can_compress_scripts' AND site_id = 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, wp_print_head_scripts, print_head_scripts, script_concat_settings, get_site_option
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_2_options WHERE option_name = 'super_simple_google_analytics_item' LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, super_simple_google_analytics_print_code, get_option
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_2_terms AS t INNER JOIN wp_2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.term_id = 3 LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, wp_get_nav_menu_object, get_term
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_2_terms AS t INNER JOIN wp_2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.slug = '3' LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, wp_get_nav_menu_object, get_term_by
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_2_terms AS t INNER JOIN wp_2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.name = '3' LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, wp_get_nav_menu_object, get_term_by
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT * FROM wp_2_posts  WHERE (post_type = 'page' AND post_status = 'publish')  AND ( ID  44 )    ORDER BY menu_order,wp_2_posts.post_title ASC made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, call_user_func, wp_page_menu, wp_list_pages, get_pages
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query  SELECT SQL_CALC_FOUND_ROWS  wp_2_posts.* FROM wp_2_posts  INNER JOIN wp_2_postmeta ON (wp_2_posts.ID = wp_2_postmeta.post_id)
    INNER JOIN wp_2_postmeta AS mt1 ON (wp_2_posts.ID = mt1.post_id) WHERE 1=1  AND wp_2_posts.post_type = 'live_streams_stream' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'closed') AND (wp_2_postmeta.meta_key = 'live_viewers'
    AND  (mt1.meta_key = 'status' AND CAST(mt1.meta_value AS CHAR) = 'live') ) GROUP BY wp_2_posts.ID ORDER BY wp_2_postmeta.meta_value+0 DESC LIMIT 0, 50 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Live_Streams_Widget->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT FOUND_ROWS() made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Live_Streams_Widget->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email , um.meta_value as last_activity FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND um.meta_key = 'last_activity' AND DATE_ADD( um.meta_value, INTERVAL 5 MINUTE ) >= UTC_TIMESTAMP() ORDER BY um.meta_value DESC LIMIT 0, 15 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BP_Core_Whos_Online_Widget->widget, bp_has_members, BP_Core_Members_Template->__construct, bp_core_get_users, BP_Core_User->get_users
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT COUNT(DISTINCT u.ID) FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND um.meta_key = 'last_activity' AND DATE_ADD( um.meta_value, INTERVAL 5 MINUTE ) >= UTC_TIMESTAMP() ORDER BY um.meta_value DESC made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BP_Core_Whos_Online_Widget->widget, bp_has_members, BP_Core_Members_Template->__construct, bp_core_get_users, BP_Core_User->get_users
    [12-May-2012 20:48:46] WordPress database error MySQL server has gone away for query SELECT * FROM wp_2_comments JOIN wp_2_posts ON wp_2_posts.ID = wp_2_comments.comment_post_ID WHERE comment_approved = '1' AND wp_2_posts.post_status = 'publish' ORDER BY comment_date_gmt DESC LIMIT 5 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Comments->widget, get_comments, WP_Comment_Query->query
    [12-May-2012 20:48:47] WordPress database error MySQL server has gone away for query  SELECT SQL_CALC_FOUND_ROWS  wp_2_posts.* FROM wp_2_posts  INNER JOIN wp_2_postmeta ON (wp_2_posts.ID = wp_2_postmeta.post_id) WHERE 1=1  AND wp_2_posts.post_type = 'topic' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'closed') AND (wp_2_postmeta.meta_key = '_bbp_last_active_time' ) GROUP BY wp_2_posts.ID ORDER BY wp_2_postmeta.meta_value DESC LIMIT 0, 10 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BBP_Topics_Widget->widget, bbp_has_topics, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 20:48:47] WordPress database error MySQL server has gone away for query SELECT FOUND_ROWS() made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BBP_Topics_Widget->widget, bbp_has_topics, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 20:48:47] WordPress database error MySQL server has gone away for query SELECT * FROM wp_options WHERE option_name = 'blogname' made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, bp_core_admin_bar, do_action, call_user_func_array, bp_adminbar_logo, get_blog_option
    [12-May-2012 20:48:47] WordPress database error MySQL server has gone away for query SELECT user_id, user_login, user_nicename, display_name, user_email, meta_value as caps FROM wp_users u, wp_usermeta um WHERE u.ID = um.user_id AND meta_key = 'wp_2_capabilities' ORDER BY um.user_id made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, bp_core_admin_bar, do_action, call_user_func_array, bp_adminbar_authors_menu
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query
    UPDATE wp_2_posts
    SET post_modified = '2012-05-12 23:27:39',
    post_modified_gmt = '2012-05-12 21:27:39'
    WHERE post_status='publish'
    AND ( ID = 342 OR ID = 343 OR ID = 360 OR ID = 361 OR ID = 405) made by require, require_once, require_once, require_once, do_action, call_user_func_array, live_streams_update_streams, live_streams_update_post_modified
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query
    UPDATE wp_2_postmeta
    SET meta_value = '920'
    WHERE meta_key = 'live_viewers'
    AND ( post_id = 342) made by require, require_once, require_once, require_once, do_action, call_user_func_array, live_streams_update_streams, live_streams_update_live_streams_viewers
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query  SELECT SQL_CALC_FOUND_ROWS  wp_2_posts.* FROM wp_2_posts  WHERE 1=1  AND wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'closed' OR wp_2_posts.post_status = 'private' OR wp_2_posts.post_status = 'hidden')  ORDER BY wp_2_posts.post_date DESC LIMIT 0, 10 made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT FOUND_ROWS() made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'can_compress_scripts' AND site_id = 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, wp_print_head_scripts, print_head_scripts, script_concat_settings, get_site_option
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'can_compress_scripts' AND site_id = 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, wp_print_head_scripts, print_head_scripts, script_concat_settings, get_site_option
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_2_options WHERE option_name = 'super_simple_google_analytics_item' LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, super_simple_google_analytics_print_code, get_option
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_2_terms AS t INNER JOIN wp_2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.term_id = 3 LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, wp_get_nav_menu_object, get_term
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_2_terms AS t INNER JOIN wp_2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.slug = '3' LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, wp_get_nav_menu_object, get_term_by
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT t.*, tt.* FROM wp_2_terms AS t INNER JOIN wp_2_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.name = '3' LIMIT 1 made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, wp_get_nav_menu_object, get_term_by
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT * FROM wp_2_posts  WHERE (post_type = 'page' AND post_status = 'publish')  AND ( ID  44 )    ORDER BY menu_order,wp_2_posts.post_title ASC made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_nav_menu, call_user_func, wp_page_menu, wp_list_pages, get_pages
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query  SELECT SQL_CALC_FOUND_ROWS  wp_2_posts.* FROM wp_2_posts  WHERE 1=1  AND wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'closed' OR wp_2_posts.post_status = 'private' OR wp_2_posts.post_status = 'hidden')  ORDER BY wp_2_posts.post_date DESC LIMIT 0, 4 made by require, require_once, include, get_header, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->slideshow_home, cc_slidertop, slider, query_posts, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT FOUND_ROWS() made by require, require_once, include, get_header, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->slideshow_home, cc_slidertop, slider, query_posts, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query  SELECT SQL_CALC_FOUND_ROWS  wp_2_posts.* FROM wp_2_posts  WHERE 1=1  AND wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'closed' OR wp_2_posts.post_status = 'private' OR wp_2_posts.post_status = 'hidden')  ORDER BY wp_2_posts.post_date DESC LIMIT 0, 3 made by require, require_once, include, do_action, call_user_func_array, CC_Theme_Generator->default_homepage_last_posts, cc_list_posts, query_posts, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT FOUND_ROWS() made by require, require_once, include, do_action, call_user_func_array, CC_Theme_Generator->default_homepage_last_posts, cc_list_posts, query_posts, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query  SELECT SQL_CALC_FOUND_ROWS  wp_2_posts.* FROM wp_2_posts  INNER JOIN wp_2_postmeta ON (wp_2_posts.ID = wp_2_postmeta.post_id)
    INNER JOIN wp_2_postmeta AS mt1 ON (wp_2_posts.ID = mt1.post_id) WHERE 1=1  AND wp_2_posts.post_type = 'live_streams_stream' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'closed' OR wp_2_posts.post_status = 'private' OR wp_2_posts.post_status = 'hidden') AND (wp_2_postmeta.meta_key = 'live_viewers'
    AND  (mt1.meta_key = 'status' AND CAST(mt1.meta_value AS CHAR) = 'live') ) GROUP BY wp_2_posts.ID ORDER BY wp_2_postmeta.meta_value+0 DESC LIMIT 0, 50 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Live_Streams_Widget->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT FOUND_ROWS() made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Live_Streams_Widget->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email , um.meta_value as last_activity FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND um.meta_key = 'last_activity' AND DATE_ADD( um.meta_value, INTERVAL 5 MINUTE ) >= UTC_TIMESTAMP() ORDER BY um.meta_value DESC LIMIT 0, 15 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BP_Core_Whos_Online_Widget->widget, bp_has_members, BP_Core_Members_Template->__construct, bp_core_get_users, BP_Core_User->get_users
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT COUNT(DISTINCT u.ID) FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND um.meta_key = 'last_activity' AND DATE_ADD( um.meta_value, INTERVAL 5 MINUTE ) >= UTC_TIMESTAMP() ORDER BY um.meta_value DESC made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BP_Core_Whos_Online_Widget->widget, bp_has_members, BP_Core_Members_Template->__construct, bp_core_get_users, BP_Core_User->get_users
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT * FROM wp_2_comments JOIN wp_2_posts ON wp_2_posts.ID = wp_2_comments.comment_post_ID WHERE comment_approved = '1' AND wp_2_posts.post_status = 'publish' ORDER BY comment_date_gmt DESC LIMIT 5 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Comments->widget, get_comments, WP_Comment_Query->query
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query  SELECT SQL_CALC_FOUND_ROWS  wp_2_posts.* FROM wp_2_posts  INNER JOIN wp_2_postmeta ON (wp_2_posts.ID = wp_2_postmeta.post_id) WHERE 1=1  AND wp_2_posts.post_type = 'topic' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'closed') AND (wp_2_postmeta.meta_key = '_bbp_last_active_time' ) GROUP BY wp_2_posts.ID ORDER BY wp_2_postmeta.meta_value DESC LIMIT 0, 10 made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BBP_Topics_Widget->widget, bbp_has_topics, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT FOUND_ROWS() made by require, require_once, include, get_footer, locate_template, load_template, require_once, do_action, call_user_func_array, CC_Theme_Generator->sidebar_right, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BBP_Topics_Widget->widget, bbp_has_topics, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT * FROM wp_options WHERE option_name = 'blogname' made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, bp_core_admin_bar, do_action, call_user_func_array, bp_adminbar_logo, get_blog_option
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT DISTINCT b.blog_id, b.id, bm1.meta_value as name, wb.domain, wb.path FROM wp_bp_user_blogs b, wp_blogs wb, wp_bp_user_blogs_blogmeta bm1 WHERE b.blog_id = wb.blog_id AND b.blog_id = bm1.blog_id AND bm1.meta_key = 'name' AND wb.deleted = 0 AND wb.spam = 0 AND wb.mature = 0 AND wb.archived = '0' AND b.user_id = 11 ORDER BY b.blog_id made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, bp_core_admin_bar, do_action, call_user_func_array, bp_adminbar_blogs_menu, bp_blogs_get_blogs_for_user, BP_Blogs_Blog->get_blogs_for_user
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT COUNT(DISTINCT b.blog_id) FROM wp_bp_user_blogs b LEFT JOIN wp_blogs wb ON b.blog_id = wb.blog_id WHERE wb.deleted = 0 AND wb.spam = 0 AND wb.mature = 0 AND wb.archived = '0' AND user_id = 11 made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, bp_core_admin_bar, do_action, call_user_func_array, bp_adminbar_blogs_menu, bp_blogs_get_blogs_for_user, BP_Blogs_Blog->get_blogs_for_user, BP_Blogs_Blog->total_blog_count_for_user
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT * FROM wp_bp_notifications WHERE user_id = 11 AND is_new = 1 made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, bp_core_admin_bar, do_action, call_user_func_array, bp_adminbar_notifications_menu, bp_core_get_notifications_for_user, BP_Core_Notification->get_all_for_user
    [12-May-2012 21:27:39] WordPress database error MySQL server has gone away for query SELECT user_id, user_login, user_nicename, display_name, user_email, meta_value as caps FROM wp_users u, wp_usermeta um WHERE u.ID = um.user_id AND meta_key = 'wp_2_capabilities' ORDER BY um.user_id made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, bp_core_admin_bar, do_action, call_user_func_array, bp_adminbar_authors_menu

    “MySQL server has gone away” is a pretty important error which must be affecting several things, even if it’s not the root cause of this issue. The connection to your database is being dropped, or lost, for some reason.

    I do not know too much about configuring MySQL servers. The relevant documentation is http://dev.mysql.com/doc/refman/5.6/en/gone-away.html — I’d hope that your host would have sufficient technical knowledge to better understand approaches to fix the problem (it’s likely to be a configuration change done on the server setup, rather than your WordPress install).

    I see, I was wondering if that was something way worse than what I initially though myself.

    Well Paul, thanks a lot for your precious insight. I’ll check with my host and see what’s up. Will let you guys know how stuff ends up going.

    I’ll come back here if the strange activity feed beahviour keeps presenting itself after fixing the MySQL issue.

    In the meantime, thanks lots for your precious support. Cheers!

    As it turns out, it was the Add link to facebook plugin (https://wordpress.org/extend/plugins/add-link-to-facebook/) causing the issue. Activity streams started working fine as per usual after disabling the plugin.

    Again, thanks a lot for the great support!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘[fixed] BuddyPress + bbPress activity stream bug’ is closed to new replies.
Skip to toolbar