Title: error in your SQL syntax
Last modified: August 20, 2016

---

# error in your SQL syntax

 *  Resolved [venture37](https://wordpress.org/support/users/venture37/)
 * (@venture37)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/error-in-your-sql-syntax-1/)
 * Seeing lots of errors like this logged in my error log since upgrading to version
   1.1
 *     ```
       2013/01/27 20:55:58 [error] 49410#0: *48 FastCGI sent in stderr: "WordPress database error 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 '' at line 1 for query SELECT ip FROM wp_simple_security_access_log WHERE login_result = 0 and time LIKE '2013-01-27%' GROUP BY ip HAVING COUNT(ip) >=  made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, Simple_Security_Tools->security_check" while reading response header from upstream, client: 192.74.228.145, server: geeklan.co.uk, request: "POST /wp-comments-post.php HTTP/1.0", upstream: "fastcgi://unix:/tmp/php.socket:", host: "www.geeklan.co.uk", referrer: "http://www.geeklan.co.uk/?p=48&cpage=1#comment-188881+++++++++++++Result:+chosen+nickname+%22typeRampoffep%22;+success+%28from+first+page%29;"
       2013/01/27 20:56:00 [error] 49410#0: *53 FastCGI sent in stderr: "WordPress database error 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 '' at line 1 for query SELECT ip FROM wp_simple_security_access_log WHERE login_result = 0 and time LIKE '2013-01-27%' GROUP BY ip HAVING COUNT(ip) >=  made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, Simple_Security_Tools->security_check" while reading response header from upstream, client: 192.74.228.145, server: geeklan.co.uk, request: "GET /?p=48&cpage=1 HTTP/1.0", upstream: "fastcgi://unix:/tmp/php.socket:", host: "www.geeklan.co.uk", referrer: "http://www.geeklan.co.uk/?p=48&cpage=1#comment-194818"
       ```
   
 * [http://wordpress.org/extend/plugins/simple-security/](http://wordpress.org/extend/plugins/simple-security/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [ChrisHurst](https://wordpress.org/support/users/chrishurst/)
 * (@chrishurst)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/error-in-your-sql-syntax-1/#post-3408022)
 * Sorry to hear of the trouble, this issue should be resolved with the latest version,
   please upgrade when you can.
 * Thank You!

Viewing 1 replies (of 1 total)

The topic ‘error in your SQL syntax’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/simple-security_cacaca.svg)
 * [Simple Security](https://wordpress.org/plugins/simple-security/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/simple-security/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/simple-security/)
 * [Active Topics](https://wordpress.org/support/plugin/simple-security/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/simple-security/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/simple-security/reviews/)

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 1 reply
 * 2 participants
 * Last reply from: [ChrisHurst](https://wordpress.org/support/users/chrishurst/)
 * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/error-in-your-sql-syntax-1/#post-3408022)
 * Status: resolved