Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: Duplicate entry error in jump.cgi

Quote Reply
Re: Duplicate entry error in jump.cgi In reply to
One of two things --

You changed the .def file or database definition.

Or, more likely, you made a change to jump.cgi so it's not properly exectuing the test block that first checks to see if the entry exists before trying to update the hits table.

The hits table needs a compound key, such that LinkID and IP are not individually uniqute, but the combination of a LinkID-IP _is_ unique.

What it seems to be doing is attempting to input the second hit on the link as a "hit"

Check your .def files and make sure they are not individually "unique"

------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/








Subject Author Views Date
Thread Duplicate entry error in jump.cgi Dan Kaplan 5621 Feb 25, 2000, 11:52 AM
Post Re: Duplicate entry error in jump.cgi
pugdog 5503 Feb 25, 2000, 4:43 PM
Post Re: Duplicate entry error in jump.cgi
Dan Kaplan 5437 Feb 25, 2000, 5:26 PM
Post Re: Duplicate entry error in jump.cgi
Dan Kaplan 5409 Feb 25, 2000, 11:40 PM
Post Re: Duplicate entry error in jump.cgi
Dan Kaplan 5409 Feb 26, 2000, 10:26 AM
Post Re: Duplicate entry error in jump.cgi
pugdog 5419 Feb 26, 2000, 5:11 PM
Post Re: Duplicate entry error in jump.cgi
Dan Kaplan 5438 Feb 26, 2000, 6:05 PM
Post Re: Duplicate entry error in jump.cgi
pugdog 5447 Feb 27, 2000, 11:19 AM
Post Re: Duplicate entry error in jump.cgi
Dan Kaplan 5415 Feb 27, 2000, 11:50 AM
Post Re: Duplicate entry error in jump.cgi
pugdog 5414 Feb 27, 2000, 4:08 PM
Post Re: Duplicate entry error in jump.cgi
Dan Kaplan 5468 Feb 27, 2000, 4:49 PM
Thread Re: Duplicate entry error in jump.cgi
pugdog 5438 Feb 27, 2000, 6:33 PM
Thread Re: Duplicate entry error in jump.cgi
fifthseason 5344 Jun 20, 2000, 3:14 AM
Thread Re: Duplicate entry error in jump.cgi
pugdog 5356 Jun 20, 2000, 11:57 AM
Thread Re: Duplicate entry error in jump.cgi
fifthseason 5366 Jun 20, 2000, 2:25 PM
Post Re: Duplicate entry error in jump.cgi
pugdog 5350 Jun 20, 2000, 6:21 PM