Support » Plugin: Optimize Database after Deleting Revisions » Undefined variable /SQL syntax error

  • Resolved Henk Verlinde

    (@ve6304)


    Notice: Undefined variable: s in /srv/www/example.com/current/web/app/plugins/rvg-optimize-database/classes/odb-cleaner.php on line 794

    WordPress databasefout: [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 'prefix_ AND p1.post_modified` < date_sub(now(), INTERVAL 0 DAY) ORD’ at line 9]
    SELECT ” AS site, p1.ID, p1.post_parent, p1.post_title, p1.post_modified FROM prefix_posts p1, prefix_posts p2 WHERE p1.post_type = ‘revision’ AND p1.post_parent = p2.ID prefix_ AND p1.post_modified < date_sub(now(), INTERVAL 0 DAY) ORDER BY UCASE(p1.post_title)`

    4.7.1

    • This topic was modified 1 year ago by Henk Verlinde. Reason: Code display
    • This topic was modified 1 year ago by Henk Verlinde. Reason: Code display
Viewing 1 replies (of 1 total)
  • Plugin Author cageehv

    (@cageehv)

    Hey Henk,

    Thanks for your bug report!

    Just released v4.7.2 that takes care of the bug.

    peace,
    Rolf

    • This reply was modified 1 year ago by cageehv.
Viewing 1 replies (of 1 total)
  • The topic ‘Undefined variable /SQL syntax error’ is closed to new replies.