:: Forums ⇒

flood protection - duplicate entry error

#1: flood protection - duplicate entry error Author: SnoSheriff,

Posted: Fri Mar 28, 2008 2:07 am
----
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

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

Posted: Fri Mar 28, 2008 3:31 am
----
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?

#3: Re: flood protection - duplicate entry error Author: SnoSheriff,

Posted: Fri Mar 28, 2008 3:55 am
----
I moved from 9.0.6.1

#4: Re: flood protection - duplicate entry error Author: SnoSheriff,

Posted: Fri Mar 28, 2008 4:21 am
----
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

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

Posted: Fri Mar 28, 2008 4:38 am
----
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.)

#6: Re: flood protection - duplicate entry error Author: SnoSheriff,

Posted: Fri Mar 28, 2008 4:47 am
----
how do I verify the robots.txt?

Here is the pic of my settings:

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

Posted: Fri Mar 28, 2008 4:57 am
----
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 ...

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

Posted: Mon Mar 31, 2008 4:30 am
----
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.

#9: Re: flood protection - duplicate entry error Author: kringel, Location: Wermelskirchen, Germany

Posted: Mon Dec 15, 2008 8:35 am
----
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 Sad

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?

#10: Re: flood protection - duplicate entry error Author: kringel, Location: Wermelskirchen, Germany

Posted: Wed Jan 07, 2009 6:40 pm
----

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 Sad

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?

#11: Re: flood protection - duplicate entry error Author: Phoenix, Location: Netizen

Posted: Thu Jan 08, 2009 12:50 am
----
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.

#12: SQL Error:Duplicate entry 'MÓyû' for key 1? Author: hadi00, Location: Syria

Posted: Tue Jun 30, 2009 1:52 pm
----
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

#13: Re: SQL Error:Duplicate entry 'MÓyû' for key 1? Author: hadi00, Location: Syria

Posted: Tue Jun 30, 2009 1:56 pm
----
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

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

Posted: Sun Jul 26, 2009 5:19 am
----
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.

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

Posted: Wed Jul 29, 2009 12:11 pm
----

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

-> Problems AFTER Install/Upgrade

All times are GMT

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