[buddypress-trac] [BuddyPress Trac] #8676: Database Errors for multiple notifications

[buddypress-trac]

#8676: Database Errors for multiple notifications
--------------------------+-----------------------------
 Reporter:  mike80222     |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  (not sure)    |    Version:
 Severity:  normal        |   Keywords:
--------------------------+-----------------------------
 Wordpress 5.9.2
 BuddyPress 10.2.0 Legacy or Nouveau
 Either 2022 or 2020 Themes.

 (1) Send two private messages to someone.

 (2) That person clicks on one of the notifications, and the error happens
 Sometimes it happens if the recipient just refreshes their profile (and
 hence the notifications)

 Note: There need to be multiple private message notifications. If there’s
 just one notification the error doesn’t appear to happen.

 More info in: https://buddypress.org/support/topic/database-
 errors/#post-323944

 This is the way the error looks with Nouveau:

 `[31-Mar-2022 17:41:07 UTC] WordPress database error You have an error in
 your SQL syntax; check the manual that corresponds to your MariaDB server
 version for the right syntax to use near ') AND user_id = 2 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 = 2 AND component_name = 'messages' AND component_action =
 'new_message' made by do_action('wp_ajax_messages_get_thread_messages'),
 WP_Hook->do_action, WP_Hook->apply_filters,
 bp_nouveau_ajax_get_thread_messages, 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`

-- 
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/8676>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac