weird error message

  • Resolved asterix30

    (@asterix30)


    10 years, 6 months ago

    Hi,

    I am getting this error message while creating a backup:
    WordPress database error: [Table ‘SOMENAME.prefix_bp_messages_recipients’ doesn’t exist]
    SELECT SUM(unread_count) FROM prefix_bp_messages_recipients WHERE user_id = 1 AND is_deleted = 0 AND sender_only = 0

    WordPress database error: [Table ‘SOMENAME.prefix_bp_friends’ doesn’t exist]
    SELECT initiator_user_id FROM prefix_bp_friends WHERE friend_user_id = 1 AND is_confirmed = 0

    There are indeed no such tables, so why is the plugin looking for them?
    Thank you!

    https://wordpress.org/plugins/better-wp-security/

Viewing 5 replies - 1 through 5 (of 5 total)
  • dwinden

    (@dwinden)

    10 years, 6 months ago

    Those 2 tables seem to be related to a plugin named BuddyPress.

    Is the BuddyPress plugin currently installed and activated ?

    Or was it installed in the past and deactivated and deleted ?

    Anyway it’s not the iTSec plugin backup code which is executing those 2 SQL Select commands …
    Looks like something else is being triggered while creating the backup …

    dwinden

    Thread Starter asterix30

    (@asterix30)

    10 years, 6 months ago

    That is true, buddypress is installed and active. But, this message arises when I hit the – Create Backup button in the Ithemes Security settings panel. I do not see any direct connection to buddypress. But I will ask them too. Thanks

    Thread Starter asterix30

    (@asterix30)

    10 years, 6 months ago

    I have disabled some functionality in buddypress, and the message does not show up anymore.

    Thanks

    dwinden

    (@dwinden)

    10 years, 6 months ago

    Ah I just noticed your post about tweaking the BuddyPress plugin which seems to fix the issue.

    May no longer be relevant but below some info on the origin of the 2 SQL statements:

    The first SQL select statement’s origin is the get_inbox_count() function from the BuddyPress plugin bp-messages/classes/class-bp-messages-thread.php file.

    The second SQL select statement origin is the get_friendship_request_user_ids() function from the BuddyPress plugin bp-friends/classes/class-bp-friends-friendship.php file.

    Do think those 2 missing tables should exist for BuddyPress to function properly …

    dwinden

    Thread Starter asterix30

    (@asterix30)

    10 years, 6 months ago

    Thank you for identifying the issue. I appreciate that. I am at the very beginning of a project and it would be very bad, if I would be running a faulty plugin. I will address the issue to buddypress developers.

    Thanks again))

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

The topic ‘weird error message’ is closed to new replies.