Welcome Visitor, Please Login or Register Now Sunday, May 11, 2025 01:59 PM 
Forums Index > Mewsoft Products > Searchawy > Duplicate entry - sqldriver.pm
New Topic   New Reply
Search for:
Author Message
carrzkiss carrzkiss's personal page
Registered Member
Posts: 51 Display member's posts
Joined: 05-11-25 01:59 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Duplicate entry - sqldriver.pm Edit Delete Reply with quote Quote
First Post Posted on: 05-11-10 01:32 PM next post first post
[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 carrzkiss's personal page
Registered Member
Posts: 51 Display member's posts
Joined: 05-11-25 01:59 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Duplicate entry - sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 05-11-10 01:35 PM next post previous post
Update:

I just spidered the same site, and it spidered without any
Duplicate Error = message ?

Very strang?
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 05-11-25 01:59 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Duplicate entry - sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 05-11-10 02:36 PM next post previous post
Please post the error message itself that you see.

Mewsoft Support
www.mewsoft.com
carrzkiss carrzkiss's personal page
Registered Member
Posts: 51 Display member's posts
Joined: 05-11-25 01:59 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Duplicate entry - sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 05-11-10 04:40 PM next post previous post
OK, on the next time that it happens, It is not very often.
carrzkiss carrzkiss's personal page
Registered Member
Posts: 51 Display member's posts
Joined: 05-11-25 01:59 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Duplicate entry - sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 05-12-10 11:36 AM next post previous post
[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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 05-11-25 01:59 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Duplicate entry - sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 05-12-10 05:45 PM next post previous post
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 carrzkiss's personal page
Registered Member
Posts: 51 Display member's posts
Joined: 05-11-25 01:59 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Duplicate entry - sqldriver.pm Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 05-13-10 12:46 AM last post previous post
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
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print  

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.2672 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation