• Resolved dbayon24

    (@dbayon24)


    Hi,

    Reviewing the server error logs, we found that this query produced an error:
    SELECT?MAX(id)?FROM?wp_bp_notifications?WHERE?user_id?=?0?AND?component_name?IN?('xprofile','friends','messages','activity','groups','members','buddypress_member_review','notification-buddypress')?AND?is_new?=?1;

    We find that in the wp_bp_notifications table, there are more than 784526 results for user_id=0

    SELECT * FROM wp_bp_notifications WHERE user_id = 0 ORDER BY wp_bp_notifications.date_notified DESC

    We don’t have a user with user_id=0

    Is this an error? Why are records saved in this table for the user user_id=0?

    Can we optimize this somehow?

    Can we delete those records?

    Thank you!



    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Kuba Mikita

    (@kubitomakita)

    Hey, we don’t save anything explicitly to the database with this plugin. It uses the BuddyPress functions to save the notification data, so maybe the notification is not properly configured?

Viewing 1 replies (of 1 total)
  • The topic ‘Sql error in wp_bp_notifications query’ is closed to new replies.