WordPress database error Duplicate entry 'xxxxxxxxxxxxx' for key 1 for query INS

[WordpressDude]

getting this error since 3 weeks ago

Code: [Select]

[05-Dec-2011 00:06:47] WordPress database error Duplicate entry '2071806934' for key 1 for query INSERT INTO wp_avhfdas_ipcache (ip, spam, added, lastseen) VALUES ('2071806934', 0, '2011-12-05 00:06:47', '2011-12-05 00:06:47') made by require, require_once, include, get_header, do_action, call_user_func_array, AVH_FDAS_Public->handleActionGetHeader, AVH_FDAS_SpamCheck->doSpamcheckMain, AVH_FDAS_SpamCheck->_doSpamCheckFunctions, AVH_FDAS_SpamCheck->_handleResults, AVH_FDAS_DB->insertIp
[05-Dec-2011 01:44:43] WordPress database error Duplicate entry '3475950784' for key 1 for query INSERT INTO wp_avhfdas_ipcache (ip, spam, added, lastseen) VALUES ('3475950784', 0, '2011-12-05 01:44:43', '2011-12-05 01:44:43') made by require, require_once, include, get_header, do_action, call_user_func_array, AVH_FDAS_Public->handleActionGetHeader, AVH_FDAS_SpamCheck->doSpamcheckMain, AVH_FDAS_SpamCheck->_doSpamCheckFunctions, AVH_FDAS_SpamCheck->_handleResults, AVH_FDAS_DB->insertIp
[05-Dec-2011 05:24:12] WordPress database error Duplicate entry '3475949358' for key 1 for query INSERT INTO wp_avhfdas_ipcache (ip, spam, added, lastseen) VALUES ('3475949358', 0, '2011-12-05 05:24:12', '2011-12-05 05:24:12') made by require, require_once, include, get_header, do_action, call_user_func_array, AVH_FDAS_Public->handleActionGetHeader, AVH_FDAS_SpamCheck->doSpamcheckMain, AVH_FDAS_SpamCheck->_doSpamCheckFunctions, AVH_FDAS_SpamCheck->_handleResults, AVH_FDAS_DB->insertIp
[05-Dec-2011 07:16:32] WordPress database error Duplicate entry '28053307' for key 1 for query INSERT INTO wp_avhfdas_ipcache (ip, spam, added, lastseen) VALUES ('28053307', 0, '2011-12-05 07:16:32', '2011-12-05 07:16:32') made by require, require_once, include, get_header, do_action, call_user_func_array, AVH_FDAS_Public->handleActionGetHeader, AVH_FDAS_SpamCheck->doSpamcheckMain, AVH_FDAS_SpamCheck->_doSpamCheckFunctions, AVH_FDAS_SpamCheck->_handleResults, AVH_FDAS_DB->insertIp

[Peter]

I'll look into it.

[Peter]

I see the same kind of messages on my site.
When I check the IP's mentioned in my access logs I see that the IP's visit the site twice within the same second.
So 1st time hits, IP is not in the cache, the plugin adds the IP to the cache DB
Before the IP is written to the DB the 2nd time hits, IP is not in cache so the plugin adds it BUT by that time the 1st hit has finished the DB action and you get the error message, I don't think there is much I can do about this situation.

[WordpressDude]

ok when you do I'm sure you will let us know.
Your plugin is the best out there and I use it on all my sites.