Database Errors: BuddyPress, bbPress, and GP

  • Mike Witt

    (@mike80222)


    4 years, 2 months ago

    I’m just looking for any ideas on how to debug this. I asked about it on the BuddyPress forum they basically said “Ask bbPress and GeneratePress.” So I’m doing that 🙂

    WordPress 5.9.2, BuddyPress 10.1.0, bbPress 2.6.9, GP 3.1.3

    (I haven’t upgraded to BP 10.2.0 yet, but I don’t see any fixes that seems to apply to this.)
    It happens “once in a while” since upgrading to BP 10.1.0. (Four times since March 9th.)
    It *might* be related to email notifications (mentions?) in a bbPress closed topic.

    [09-Mar-2022 17:13:53 UTC] WordPress 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 ') AND user_id = 1348 AND component_name = 'messages' AND component_action = 'new' at line 1 for query UPDATE wp_bp_notifications SET is_new = 0 WHERE item_id IN () AND user_id = 1348 AND component_name = 'messages' AND component_action = 'new_message' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/generatepress/page.php'), generate_do_template_part, get_template_part, locate_template, load_template, require('/themes/generatepress/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, bp_replace_the_content, apply_filters('bp_replace_the_content'), WP_Hook->apply_filters, BP_Members_Theme_Compat->single_dummy_content, bp_buffer_template_part, bp_get_template_part, bp_locate_template, load_template, require('/plugins/buddypress/bp-templates/bp-legacy/buddypress/members/single/home.php'), bp_get_template_part, bp_locate_template, load_template, require('/plugins/buddypress/bp-templates/bp-legacy/buddypress/members/single/messages.php'), bp_get_template_part, bp_locate_template, load_template, require('/plugins/buddypress/bp-templates/bp-legacy/buddypress/members/single/messages/single.php'), bp_thread_the_message, BP_Messages_Thread_Template->the_message, do_action('thread_loop_start'), WP_Hook->do_action, WP_Hook->apply_filters, bp_messages_screen_conversation_mark_notifications, bp_notifications_mark_notifications_by_item_ids, BP_Notifications_Notification::update_id_list

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

    (@fernandoazarcon2)

    4 years, 2 months ago

    Hi Mike,

    Looks like the error trickles down to a SQL request by BuddyPress bp_replace_the_content.

    Moreover, it appears that the reason why there is generatepress in the error log is only because the SQL request is being ran by your plugin inside our template, page.php, and GeneratePress doesn’t have any code or functionalities that should have any effect on SQL requests.

    If you have a staging website, you can test this by using a different theme.

    Lastly, to debug, did you add any new plugins or codes in your website? Looking at these might also be helpful.

    Hope this clarifies. 🙂

    Thread Starter Mike Witt

    (@mike80222)

    4 years, 2 months ago

    Thank you @fernandoazarcon2. That is helpful. I am going to try to duplicate this problem on a test site. Unfortunately it doesn’t happen often and I haven’t been able to figure out how to reproduce the error so far. Anyway, that information helps. I appreciate it.

    fernandoazarcon2

    (@fernandoazarcon2)

    4 years, 2 months ago

    You’re welcome Mike! Glad to be of assistance! Hope the cause of the issue gets found as soon as possible. Feel free to reach out anytime if assistance with anything else is needed. 🙂

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

The topic ‘Database Errors: BuddyPress, bbPress, and GP’ is closed to new replies.