MariaDB issue with duplicate postmeta
-
Hi,
Great tool, works great on a MySql db, I run into an issue when trying to use the tool on a WP install with MariaDB. All the functions works except for the duplicate Post Meta. When launching the Sweep plugin. I get the following errors.
Notice: Undefined property: wpdb::$termmeta in /data/www/html/greenpeace-usa/develop/usa/wp-includes/wp-db.php on line 675 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 '' at line 1] SELECT COUNT(*) FROM Notice: Undefined property: wpdb::$termmeta in /data/www/html/greenpeace-usa/develop/usa/wp-includes/wp-db.php on line 675 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 wp_terms)' at line 1] SELECT COUNT(meta_id) FROM WHERE term_id NOT IN (SELECT term_id FROM wp_terms) Notice: Undefined property: wpdb::$termmeta in /data/www/html/greenpeace-usa/develop/usa/wp-includes/wp-db.php on line 675 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 'GROUP BY term_id, meta_key, meta_value HAVING count > 1' at line 1] SELECT COUNT(meta_id) AS count FROM GROUP BY term_id, meta_key, meta_value HAVING count > 1Scrolling down to the Duplicate Post Meta it gives me a total, when I click the button to Sweep, nothing happens.The button gets to sweeping, never returns back.
Checking the Chrome Developer Tools and nothing shows to be return on the Ajax call.
Hope to get this sorted, as the tool will be of big help.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
The topic ‘MariaDB issue with duplicate postmeta’ is closed to new replies.