Log in

View Full Version : error when submitting score


Nexus[l33t]
12-07-2006, 07:53 PM
]hi, suddenly out of nowhere a user started getting this error when submitting a score. i tried playing different games and am getting the same error.

mySQL query error: INSERT INTO games_scores
(mid,gid,name,score,ip,timespent,datescored) VALUES
('359','914','MAXFACTOR','8778','38.99.84.12','17' ,'1165507855')

mySQL error: Duplicate entry '1' for key 1
mySQL error code:
Date: Thursday 07th of December 2006 09:10:55 AM

and

mySQL query error: INSERT INTO games_scores
(mid,gid,name,score,ip,timespent,datescored) VALUES
('1','2','machino','60','69.178.114.236','34','116 5527819')

mySQL error: Duplicate entry '1' for key 1
mySQL error code:
Date: Thursday 07th of December 2006 02:43:39 PM

any ideas?

nul7
12-08-2006, 11:09 PM
I get errors when I enable it to save every score... try setting it to save only one score and see if that helps.

Nexus[l33t]
12-08-2006, 11:56 PM
thanks, i do have it set to save every score. i'll look at changing that setting. but what i did was went into phpmyadmin and ran the check, optimize, repair options on the games_scores table. that solved the problem, hopefully permanently.

thanks again