spbc_firewall_logs duplicate key error
-
Hello,
apache error log is full of dpbc_firewall_logs insertion errors. I tried upgrading the plugin to the most recent one and it keeps adding more lines. What might be the issue and how to solve it?
www.****.sk [Tue Oct 24 12:53:05.718218 2017] [-:error] [pid 113846] [client 45.76.83.59:48620] 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 ‘\\’45.76.83.59, 4\n\t\t\tON DUPLICATE KEY UPDATE \n\t\t\t\t
ip_entry
= ‘45.76.83.59’,\n\t\t\t’ at line 12 for query INSERT INTOwp_spbc_firewall_logs
\n\t\t\tSET \n\t\t\t\tentry_id
= ‘ba40dbc3171dd651c2096d049d621dde’,\n\t\t\t\tip_entry
= ‘45.76.xx.xx’,\n\t\t\t\tentry_timestamp
= ‘1508842385’,\n\t\t\t\tallowed_entry
= 1,\n\t\t\t\tblocked_entry
= 0,\n\t\t\t\tstatus
= ‘PASS’,\n\t\t\t\tpage_url
= ‘https://www.****.sk/’,\n\t\t\t\thttp_user_agent
= ‘Mozilla/5.0 (compatible; Statusdroid/1.0; +https://www.statusdroid.com/pages/bot/)’,\n\t\t\t\trequest_method
= ‘GET’,\n\t\t\t\tx_forwarded_for
= \\’45.76.83.59, 4\n\t\t\tON DUPLICATE KEY UPDATE \n\t\t\t\tip_entry
= ‘45.76.83.59’,\n\t\t\t\tentry_timestamp
= ‘1508842385’,\n\t\t\t\tallowed_entry
=allowed_entry
+ 1,\n\t\t\t\tblocked_entry
=blocked_entry
,\n\t\t\t\tstatus
= ‘PASS’,\n\t\t\t\tpage_url
= ‘https://www.****.sk/’,\n\t\t\t\thttp_user_agent
= ‘Mozilla/5.0 (compatible; Statusdroid/1.0; +https://www.statusdroid.com/pages/bot/)’,\n\t\t\t\trequest_method
= ‘GET’,\n\t\t\t\tx_forwarded_for
= \\’45.76.83.59, 4 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/security-malware-firewall/security-malware-firewall.php’), SpbcFireWall::firewall_update_logs
- The topic ‘spbc_firewall_logs duplicate key error’ is closed to new replies.