Title: Undefined variable /SQL syntax error
Last modified: November 12, 2018

---

# Undefined variable /SQL syntax error

 *  Resolved [Henk Verlinde](https://wordpress.org/support/users/ve6304/)
 * (@ve6304)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/undefined-variable-sql-syntax-error/)
 * `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 7 years, 7 months ago by [Henk Verlinde](https://wordpress.org/support/users/ve6304/).
      Reason: Code display
    -  This topic was modified 7 years, 7 months ago by [Henk Verlinde](https://wordpress.org/support/users/ve6304/).
      Reason: Code display

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/undefined-variable-sql-syntax-error/#post-10872448)
 * Hey Henk,
 * Thanks for your bug report!
 * Just released v4.7.2 that takes care of the bug.
 * peace,
    Rolf
    -  This reply was modified 7 years, 7 months ago by [cageehv](https://wordpress.org/support/users/cageehv/).

Viewing 1 replies (of 1 total)

The topic ‘Undefined variable /SQL syntax error’ is closed to new replies.

 * ![](https://ps.w.org/rvg-optimize-database/assets/icon-256x256.png?rev=3350597)
 * [Optimize Database after Deleting Revisions](https://wordpress.org/plugins/rvg-optimize-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rvg-optimize-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rvg-optimize-database/)
 * [Active Topics](https://wordpress.org/support/plugin/rvg-optimize-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rvg-optimize-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rvg-optimize-database/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [cageehv](https://wordpress.org/support/users/cageehv/)
 * Last activity: [7 years, 7 months ago](https://wordpress.org/support/topic/undefined-variable-sql-syntax-error/#post-10872448)
 * Status: resolved