flood protection - duplicate entry error

[SnoSheriff]

Last night I upgraded to DF9.2.1. Today I got hundreds of emails similar to this one:

On /Your_Account.html
While executing query "INSERT INTO cpg_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x4430f21d, '1206658018', '0', DEFAULT)"

the following error occured: Duplicate entry 'D0�' for key 1

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

[layingback]

I reported same as bug report 2 days ago - dragonflycms.org/Proje.../id=1039/.

In the interests of trying to narrow this down: what version of DF did you upgrade from?

[SnoSheriff]

I moved from 9.0.6.1

[SnoSheriff]

Just got another similar email. I'm concerned that I'm blocking google bots. Is that the case here?

On /Your_Account.html
While executing query "INSERT INTO cpg_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x42f94679, '1206694750', '0', DEFAULT)"

the following error occured: Duplicate entry 'B�Fy' for key 1

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

Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 66.249.70.121
Host: crawl-66-249-70-121.googlebot.com

[layingback]

I also moved directly from 9.0.6.1. So I suspect that the connection. Hopefully Nano will see this.

Yes, that seems to be googlebot - or one of them. You can turn off flooding in meantime. I'm surprised that googlebot was hammering this hard - I thought it usually obeyed robots.txt. You have the correct version of robots.txt installed? (Note this bug - if indeed it is a bug - is not the issue with regard to stopping googlebot. As it had already got into your flooding list before the dup issue.)

[SnoSheriff]

how do I verify the robots.txt?

Here is the pic of my settings:

[layingback]

It should be in your top level DF folder. Make sure it matches 1 on 9.2.1 zip. Should have a crawl-delay: 20 entry.

You haven't changed it from tight to loose yet I see ...

[NanoCaiordo]

Nothing wrong with the crawl delay, it wasnt hammering and the system did not blocked it in any way.

The duplicate keys, somehow, sometimes happen. I'm aware of this issue from few months already, i could suppress the error as a workaround but this is something that i dont want to. I want to fix it, no hide it.

[kringel]

Hi, guys!

I receive this error message as well, but this error occurs everytime someone tries to log in... I can't even reach admin panel! I've changed some security rights just before this error's first appereance but I can't remember, what I've changed

Quote::

On /content/index.php While executing query "INSERT INTO dragonfly_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x559ec410, '1229325296', '0', DEFAULT)" the following error occured: Duplicate entry 'U��' for key 1 In: /*****/content/includes/classes/security.php on line: 308 Guest information: User id: 2 Username: kringel Admin: No IP: ... Host: ...

What can I do to make my homepage accessible again?

[kringel]

kringel wrote:

Hi, guys! I receive this error message as well, but this error occurs everytime someone tries to log in... I can't even reach admin panel! I've changed some security rights just before this error's first appereance but I can't remember, what I've changed

Hello, again

I've reinstalled Dragonfly and changed only flooding settings to "loose" and "15 Minutes ban" - and *booom* I'm out again. Where are these settings saved in the database?

[Phoenix]

In your case, those settings are saved in the dragonfly_config_custom table.

However, remember, if you change settings directly in the database, you must also delete the cache/conbfig_MAIN_CFG.php file so that it can re-generate.

[hadi00]

hello, i just got this, what do u think ? should I worry about something?
thnx every one..

Code::

While executing query "INSERT INTO cms_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x4dd379fb, '1246311596', '0', DEFAULT)" the following error occured: Duplicate entry 'MÓyû' for key 1 In: /home/_XX_/public_html/includes/classes/security.php on line: 308 Guest information: User id: 1 Username: Anonymous. Admin: No

[hadi00]

Ok, got two another :

Code::

On /header/header_CBStageSh1.html While executing query "INSERT INTO cms_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x51348f20, '1246316529', '0', DEFAULT)" the following error occured: Duplicate entry 'Q4 ' for key 1 In: /home/_XX_/public_html/includes/classes/security.php on line: 308 Guest information: User id: 1 Username: Anonymous. Admin: No IP: 81.52.143.32 Host: natcrawlbloc03-32.net.m1.fti.net

--------

Code::

On /Left/left_artists.html While executing query "INSERT INTO cms_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x51348f20, '1246316529', '0', DEFAULT)" the following error occured: Duplicate entry 'Q4 ' for key 1 In: /home/_XX_/public_html/includes/classes/security.php on line: 308 Guest information: User id: 1 Username: Anonymous. Admin: No IP: 81.52.143.32 Host: natcrawlbloc03-32.net.m1.fti.net

[NanoCaiordo]

I still believe this error only happens when the same client access your site for the first time simultaneously.

No fix at this stage but speeding up the Security class by removing all latest debug functions introduced might helps.

[layingback]

NanoCaiordo wrote:

I still believe this error only happens when the same client access your site for the first time simultaneously. No fix at this stage but speeding up the Security class by removing all latest debug functions introduced might helps.

Looks as if I can pop that bubble. These 2 were emailed a little over 2 minutes apart, triggered by the same bot/IP address. This is an exceedingly obnoxious bot (this is the only site that I haven't blocked it on), but that said, the 2nd error can't have been the "first time".

At 04:12:42

Code::

On /CPGNuCalendar/view=day/date=20060413.html While executing query "INSERT INTO nuke_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x43da7486, '1248891163', '0', DEFAULT)" the following error occured: Duplicate entry 'CÚt†' for key 1 In: /home/asq7092/public_html/section/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

And at 04:14:28

Code::

On /Forums/viewtopic/t=29/view=previous.html While executing query "INSERT INTO nuke_security_flood (flood_ip,flood_time,flood_count,log) VALUES (0x43da7486, '1248891269', '0', DEFAULT)" the following error occured: Duplicate entry 'CÚt†' for key 1 In: /home/asq7092/public_html/section/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