| carrzkiss |
First Post Posted on: 05-11-10 01:32 PM |
| Duplicate entry - sqldriver.pm |
|
[Thu Sep 16 11:41:10 2004] spider.cgi: DBD::mysql::st execute failed: Duplicate entry '1095349285' for key 1 at g:/InetPub/wwwroot/search/cgi-bin/dir/sqldriver.pm line 1209. Content-type: text/html
The above error happens sometimes when Spidering.
What Exactly does this error mean?
I thought that it mean that there was already a link in the database
So it is not going to allow a "Duplicate Entry" ?
But I messed up a little while ago and spidered the same "3" links. So that put them in the same Category "2x a piece" And with it allowing that to happen, then this error has to mean something else?
Please explain? |
|
|
|
|
|
| carrzkiss |
Reply #: 1 Posted on: 05-11-10 01:35 PM |
| Re: Duplicate entry - sqldriver.pm |
|
Update:
I just spidered the same site, and it spidered without any
Duplicate Error = message ?
Very strang? |
|
|
|
|
|
| mewsoft |
Reply #: 2 Posted on: 05-11-10 02:36 PM |
| Re: Duplicate entry - sqldriver.pm |
|
| Please post the error message itself that you see. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| carrzkiss |
Reply #: 3 Posted on: 05-11-10 04:40 PM |
| Re: Duplicate entry - sqldriver.pm |
|
| OK, on the next time that it happens, It is not very often. |
|
|
|
|
|
 |
| carrzkiss |
Reply #: 4 Posted on: 05-12-10 11:36 AM |
| Re: Duplicate entry - sqldriver.pm |
|
[Fri Sep 17 09:50:56 2004] spider.cgi: DBD::mysql::st execute failed: Duplicate entry '1095429061' for key 1 at g:/InetPub/wwwroot/search/cgi-bin/dir/sqldriver.pm line 1194. Content-type: text/html
SQL Error
SQL Error: Duplicate entry '1095429061' for key 1
Query:
INSERT INTO Pending_Links (ID, Cat_ID, User_ID, Title, URL, Description, Keywords, Status, Expire, Start_Date, End_Date, Update_Date, Template, Language, Rank, Price, Score, URL1, URL2, Location, URL_Image, URL_Icon, FName, LName, Company, Job_Title, Street, City, State, Zip, Country, Phone, Fax, Website, Email, Extra1, Extra2) VALUES ('1095429061', '3277', 'dsimpson@lsue.edu', 'Buckwheat Zydeco', 'http://www.lsue.edu/acadgate/music/dural.htm', 'Photographs of and information about Buckwheat Zydeco.', 'Acadiana,zydeco,Buckwheat,Zydeco,Stanley,Dural', '', '', '', '', '', '', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'dsimpson@lsue.edu', '', '')
Line 1194, File g:/InetPub/wwwroot/search/cgi-bin/dir/sqldriver.pm. |
|
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 05-12-10 05:45 PM |
| Re: Duplicate entry - sqldriver.pm |
|
| DO you have any kind or cashing like perlex or mod_perl or other programs that cash perl scripts? it can happens if you have 2 calls at the same second to the submit pending links which should not happen, may be you can slow down your mouse speed it may be do some what is called "contact bounce" meaning each click can lead to more than one click. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| carrzkiss |
Reply #: 6 Posted on: 05-13-10 12:46 AM |
| Re: Duplicate entry - sqldriver.pm |
|
OK, I will do some checking on that.
Does the search engine look for a record to see if it is already listed?
Like example:
You submit a link: www.domain.com
Will the search engine notice that there is already a link called:
www.domain.com listed or not?
Thanks |
|
|
|
|
|
|