• Resolved German Cabezas

    (@gercabace)


    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.

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL error working with Database Optimizer’ is closed to new replies.