:: Forums ⇒

flood protection - duplicate entry error

#16: Re: flood protection - duplicate entry error Author: layingback,

Posted: Wed Jul 29, 2009 8:50 pm
----
And for what it's worth, different site, same server/account, approx. 11.5 hours later, from same bot at same URL, and same duplicate key:

Code::

On /CPGNuCalendar/view=day/date=20321128.html
While executing query "INSERT INTO wps_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x43da7486, '1248925173', '0', DEFAULT)"

the following error occured: Duplicate entry 'CÚt' for key 1

In: /home/layin2/public_html/sbcwineries/includes/classes/security.php on line: 308

Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 67.218.116.134
Host: crawl-9c.cuil.com

#17: Re: flood protection - duplicate entry error Author: layingback,

Posted: Thu Jul 30, 2009 6:15 am
----
And 2 more, 1 for each site, at 18:50 for the 1st site, and 16:07 for the 2nd, everything else as before exactly.

#18: Re: flood protection - duplicate entry error Author: layingback,

Posted: Thu Jul 30, 2009 8:26 am
----
And again to 2nd site at 00:43 ...

This 2nd site is semi-dormant, so if you want Admin access to investigate, Nano, just ask.

#19: Re: flood protection - duplicate entry error Author: NanoCaiordo, Location: Melbourne, AU

Posted: Fri Jul 31, 2009 4:55 pm
----
... data get removed regularly every ((($times+1)*2)/$delay)+$time

so this error may appear few times every minute, but it doesn't.

If, on your logs, there are 2 or more entries from this bot accessing your site at the same time, then it would confirm my theory.

#20: Re: flood protection - duplicate entry error Author: layingback,

Posted: Fri Jul 31, 2009 9:40 pm
----
Nano,

I've found 3 dup errors, and have attached the email texts, and the matching segment of the daily log.

Easiest way I found to match the emails to the log entries is to search on the CPGNuCalendar date cited in the emails.

On 1 error the 2 accesses in question are same time, but 1 pair are 1 ms apart, and 1 pair are 2 ms apart. However there are a lot more cases I can see when the accesses are at same time, but no dup error was raised. So ... ???

#21: Re: flood protection - duplicate entry error Author: NanoCaiordo, Location: Melbourne, AU

Posted: Sun Aug 02, 2009 6:25 am
----
A screen shot of your security page settings would be handy.

At this stage I have no clue. But I'll nail it and hang it on my wall Very Happy

#22: Re: flood protection - duplicate entry error Author: layingback,

Posted: Sun Aug 02, 2009 9:04 am
----
Here you go ...

Pls send picture when you've fixed! Wink

-> Problems AFTER Install/Upgrade

All times are GMT

Go to page Previous 1, 2 :| |: Page 2 of 2