Database error Duplicate entry

This happens when the spammers hammer your site. Sometimes they try to post withing one second, the first write to the database hasn’t yet completed when the 2nd write is performed.

Hello !

To avoid this error (while being hammered) ??

$result = $wpdb->query($wpdb->prepare(“INSERT DELAYED INTO $wpdb->avhfdasipcache (ip, spam, added, lastseen) VALUES (%s, %d, %s, %s)”, $ip, $spam, $date, $date) ON DUPLICATE KEY UPDATE ip=’$ip’,spam=’$spam’,… );

https://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

Maybe you can update the files , thank you

petesky, this would be good to try; what’s the complete code chunk? I tried to adapt what you posted but got errors.

I just released v3.6.1 with the above fix.

Thanks!