I get an error when I try to delete

  • Resolved jksastrology

    (@jksastrology)


    4 years, 2 months ago

    Hello,

    I love the idea of this plugin. However, it does not work for me.

    I get the following error, when selecting any date from the drop down fields.

    Deleting Activity Older Than: 2020-05-06
    Please wait…

    Notice: Trying to get property ‘table_name’ of non-object in /home/customer/www/astrodate.co.uk/public_html/wp-content/plugins/bp-bulk-delete/bpbd-admin.php on line 222

    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 ‘WHERE date_recorded < ‘2020-05-06” at line 1]
    SELECT id FROM WHERE date_recorded < ‘2020-05-06’

    Are you able to point me in the right direction of how I could resolve this error?

    Thank you.

    Jamie

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author shanebp

    (@shanebp)

    4 years, 2 months ago

    We cannot duplicate your issue.

    The table name is retrieved from a BuddyPress object:
    {$bp->activity->table_name}

    We aren’t sure why the standard approach is not working.
    Perhaps there is some customization of your database structure?

    You could try changing this:
    "SELECT id FROM {$bp->activity->table_name} WHERE date_recorded < %s",
    To a hardcoded table name:
    "SELECT id FROM your-activity-table-name WHERE date_recorded < %s",

    Thread Starter jksastrology

    (@jksastrology)

    4 years, 2 months ago

    Hello,

    I just thought I would update you with my progress. I have just managed to solve the problem, and thought you would be interested to know what produced that error. It is becuase I did not have a setting called “User Groups” enabled in my buddypress settings.

    Once this setting was activated, I could then see other bulk delete options on your plugin. Which is great by the way!

    However, it seems to delete all messages regardless of the date I select. But maybe this is becuase I do not have the “activity streams” setting activated.

    Thank you,

    Jay

    Plugin Author shanebp

    (@shanebp)

    4 years, 1 month ago

    Thanks for letting us know that we were not checking for active BP components.
    That has been fixed as of Version 1.4

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘I get an error when I try to delete’ is closed to new replies.