MySQL 5.5 Sytax Errors

  • Resolved ljmac

    (@ljmac)


    2 years, 7 months ago

    Hi,

    I am still running MySQL 5.5 (the best performing version on my setup), but whenever I go to your plugin’s admin pages, I get the following PHP errors:

    [24-Aug-2022 05:29:30 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 term_id NOT IN (SELECT term_id FROM as_terms)’ at line 1 for query SELECT COUNT(meta_id) FROM WHERE term_id NOT IN (SELECT term_id FROM as_terms) made by do_action(‘tools_page_advanced_db_cleaner’), call_user_func_array, ADBC_Advanced_DB_Cleaner->aDBc_main_page_callback, include_once(‘/plugins/advanced-database-cleaner/includes/clean_db.php’), include_once(‘/plugins/advanced-database-cleaner/includes/class_general_cleanup.php’), ADBC_Clean_DB_List->__construct, ADBC_Clean_DB_List->aDBc_prepare_elements_to_clean, aDBc_count_all_elements_to_clean, aDBc_count_elements_to_clean

    [24-Aug-2022 05:30:45 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 term_id NOT IN (SELECT term_id FROM as_terms)’ at line 1 for query SELECT COUNT(meta_id) FROM WHERE term_id NOT IN (SELECT term_id FROM as_terms) made by require_once(‘wp-admin/admin.php’), do_action(‘tools_page_advanced_db_cleaner’), call_user_func_array, ADBC_Advanced_DB_Cleaner->aDBc_main_page_callback, include_once(‘/plugins/advanced-database-cleaner/includes/clean_db.php’), include_once(‘/plugins/advanced-database-cleaner/includes/class_general_cleanup.php’), ADBC_Clean_DB_List->__construct, ADBC_Clean_DB_List->aDBc_prepare_elements_to_clean, aDBc_count_all_elements_to_clean, aDBc_count_elements_to_clean

    It doesn’t appear to cause any actual problems, however.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter ljmac

    (@ljmac)

    I have found it produces the following error while optimising as well:

    [25-Aug-2022 19: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 term_id NOT IN (SELECT term_id FROM as_terms)’ at line 1 for query DELETE FROM WHERE term_id NOT IN (SELECT term_id FROM as_terms) made by do_action_ref_array, call_user_func_array, aDBc_clean_scheduled_elements, aDBc_clean_elements_type

    I hope it doesn’t cause any harm – your plugin certainly does appear to be the very best of its type.

    Thread Starter ljmac

    (@ljmac)

    Some further info: I have tried earlier versions of this plug in, and I have found that 2.0 and earlier do not have this problem.

    Plugin Author Younes JFR.

    (@symptote)

    Hi,

    Thank you very much for reporting this. I will check it and solve it in the next version.

    Best regards,
    Younes

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL 5.5 Sytax Errors’ is closed to new replies.