• Resolved lacike

    (@lacike)


    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\tip_entry = ‘45.76.83.59’,\n\t\t\t’ at line 12 for query INSERT INTO wp_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

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘spbc_firewall_logs duplicate key error’ is closed to new replies.