Delete Transients Database Error

  • Resolved ljmac

    (@ljmac)


    11 years, 3 months ago

    Hi,

    The new option to delete expired transients appears to be producing a database error:

    [09-Dec-2013 00:00:03 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 ‘WHERE b.option_name = replace(a.option_name,’_timeout’, ”)
    AND (a.option_name ‘ at line 2 for query
    DELETE FROM as_options a, as_options b
    WHERE b.option_name = replace(a.option_name,’_timeout’, ”)
    AND (a.option_name like ‘_transient_timeout_%’ or a.option_name like ‘_site_transient_timeout_%’)
    AND a.option_value < ‘1386547143’
    made by do_action_ref_array, call_user_func_array, rvg_optimize_db_cron, rvg_delete_transients

    I’m using MySQL version 5.1.22, if that makes any difference.

    https://www.ads-software.com/plugins/rvg-optimize-database/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor cageehv

    (@cageehv)

    Hey ljmac,

    Thanks for catching that!

    I just released a new version (v2.7.1) of the plugin that will fix this issue.

    Rolf

    Thread Starter ljmac

    (@ljmac)

    As we say down here in oz, no worries – thanks for the quick fix!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Delete Transients Database Error’ is closed to new replies.