WordPress.org

Ready to get started?Download WordPress

Forums

Simple Security
[resolved] error in your SQL syntax (2 posts)

  1. venture37
    Member
    Posted 1 year ago #

    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/

  2. ChrisHurst
    Member
    Plugin Author

    Posted 1 year ago #

    Sorry to hear of the trouble, this issue should be resolved with the latest version, please upgrade when you can.

    Thank You!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic