Support » Plugin: Simple Security » error in your SQL syntax

  • Resolved venture37

    (@venture37)


    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/

Viewing 1 replies (of 1 total)
  • Plugin Author ChrisHurst

    (@chrishurst)

    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.