SQL error working with Database Optimizer
-
Hi, I’ve just install last version. When I was clearing “Orphan attachments” (Database Optimizer]), this error showed up:
·····························
[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 post_type = ‘attachment” at line 1]
SELECT ID FROM wp_posts WHERE post_parent NOT IN (SELECT ID FROM wp_posts) AND post_parent != 0 WHERE post_type = ‘attachment’
························Maybe WHERE clause should be AND:
WHERE post_type = ‘attachment’ –> AND post_type = ‘attachment’Regards.
The topic ‘SQL error working with Database Optimizer’ is closed to new replies.