Database Syntax Errors
-
I originally reported this years ago with version 3.1, but upon trying the plugin again I have found these errors remain (also after upgrading my server). I am getting database syntax errors in relation to your orphaned term meta cleanup – see the following:
When I go to the General clean-up panel in the plugin settings:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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"When I do a manual cleanup with orphaned term meta enabled:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 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_Clean_DB_List->process_bulk_action, aDBc_clean_all_elements_type, aDBc_clean_elements_type"When I do a scheduled cleanup with orphaned term meta enabled:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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"As you can see I have a non-standard database prefix – I don’t know if this has anything to do with it. I really hope you can fix this, as your plugin is clearly the best of its type.
The topic ‘Database Syntax Errors’ is closed to new replies.