Title: ON DUPLICATE KEY UPDATE errors Last modified: January 25, 2018 --- # ON DUPLICATE KEY UPDATE errors * Resolved [rwmichel](https://wordpress.org/support/users/rwmichel/) * (@rwmichel) * [8 years, 4 months ago](https://wordpress.org/support/topic/on-duplicate-key-update-errors/) * Every visit is resulting in WP db errors in nginx error logs. An example: * 2018/01/24 23:56:49 [error] 28343#0: *670105 FastCGI sent in stderr: “PHP message: WordPress database error Unknown column ‘entry_id’ in ‘where clause’ for query SELECT allowed_entry + blocked_entry as cnt FROM `wp_spbc_firewall_logs` WHERE entry_id = ‘5ee3dbc141771099fc6c8a01cf57de47’; 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- malwa re-firewall.php’), SpbcFireWall->check_ip PHP message: WordPress database error Unknown column ‘entry_id’ in ‘field list’ for query INSERT INTO `wp_spbc_firewall_logs`(` entry_id`, `ip_entry`, `entry_timestamp`, `allowed_entry`, `blocked_entry`, ` status`, `page_url`, `http_user_agent`, ` request_method`,`x_forwarded_for`) VALUES (‘5ee3dbc141771099fc6c8a01cf57de47’, ‘174.78.249.18’, 1516838208, 1, 0,‘ PASS’, ‘[https://www.neptunesystems.com/](https://www.neptunesystems.com/) ?wc- ajax=get_refreshed_fragments’, ‘Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/ 537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari /537.36’, ‘POST’, ‘174.78.249.18’) ON DUPLICATE KEY UPDATE ip_entry = ip_entry, entry_timestamp = 1516838208, allowed_entry = allowed_entry + 1, blocked_entry = blocked_entry + 0, status = ‘PASS’, page_url = ‘[https://www.neptunesystems.com/?wc-ajax=get_refreshed_fragments’](https://www.neptunesystems.com/?wc-ajax=get_refreshed_fragments’);, http_user_agent = http_user_agent, request_method = ‘POST’, x_forwarded_for =‘ 174.78.249.18’ made by require(‘wp-blog-header.php’), require_once(‘wp” while reading respons e header from upstream, client: 174.78.249.18, server: [http://www.neptunesystems.com](http://www.neptunesystems.com), request: “POST /?wc-ajax=get_refreshed_fragments HTTP/1.1”, upstr eam: “fastcgi:// unix:/var/run/php-fpm/php-fpm.sock:”, host: “www.neptunesystems.com”, referrer:“ [https://www.neptunesystems.com/products/apex-controllers/apex-controller-system/”](https://www.neptunesystems.com/products/apex-controllers/apex-controller-system/”); * WP/4.9.2 Security by CleanTalk/2.3 nginx/1.13.6 PHP-FPM/5.6 * Please assist/advise… * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fon-duplicate-key-update-errors%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 4 replies - 1 through 4 (of 4 total) * Plugin Support [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/) * (@sergecleantalk) * [8 years, 4 months ago](https://wordpress.org/support/topic/on-duplicate-key-update-errors/#post-9900560) * Hello, * Thank you for your request. * We will investigate this. Please give us 1-2 working days. * We will contact you. * Best regards * [Safronik](https://wordpress.org/support/users/safronik/) * (@safronik) * [8 years, 4 months ago](https://wordpress.org/support/topic/on-duplicate-key-update-errors/#post-9913473) * Hello, * We have fixed that. Please, install the plugin from here: [https://www.dropbox.com/s/48tcctfbn9dc5de/security-malware-firewall.zip?dl=0](https://www.dropbox.com/s/48tcctfbn9dc5de/security-malware-firewall.zip?dl=0) * Contact us if you have other questions. * Thread Starter [rwmichel](https://wordpress.org/support/users/rwmichel/) * (@rwmichel) * [8 years, 4 months ago](https://wordpress.org/support/topic/on-duplicate-key-update-errors/#post-9914403) * Thank you. 2.4 has resolved the ON DUPLICATE KEY UPDATE errors. I’ll monitor closely for a bit. wordpress.org still lists 2.3 as the latest; may I assume that 2.4 should be considered a beta? * Plugin Support [amagsumov](https://wordpress.org/support/users/amagsumov/) * (@amagsumov) * [8 years, 4 months ago](https://wordpress.org/support/topic/on-duplicate-key-update-errors/#post-9916603) * Hello, * Yes, you are right, 2.4 is in beta status. * Feel free to contact us anytime. * Best regards. Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘ON DUPLICATE KEY UPDATE errors’ is closed to new replies. * ![](https://ps.w.org/security-malware-firewall/assets/icon-256x256.gif?rev=3518712) * [Security Plugin, Firewall & Malware Scanner with Auto Removal](https://wordpress.org/plugins/security-malware-firewall/) * [Frequently Asked Questions](https://wordpress.org/plugins/security-malware-firewall/#faq) * [Support Threads](https://wordpress.org/support/plugin/security-malware-firewall/) * [Active Topics](https://wordpress.org/support/plugin/security-malware-firewall/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/security-malware-firewall/unresolved/) * [Reviews](https://wordpress.org/support/plugin/security-malware-firewall/reviews/) * 4 replies * 4 participants * Last reply from: [amagsumov](https://wordpress.org/support/users/amagsumov/) * Last activity: [8 years, 4 months ago](https://wordpress.org/support/topic/on-duplicate-key-update-errors/#post-9916603) * Status: resolved