[shaynehammy]

Sigh, finally resolved this myself by the following.....

ALTER TABLE `games_session` CHANGE `sessid` `sessid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `games_list` CHANGE `gid` `gid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `games_league` CHANGE `mid` `mid` bigint( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `games_scores` CHANGE `s_id` `s_id` int( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT;

--------------- Added [DATE]1211583266[/DATE] at [TIME]1211583266[/TIME] ---------------

However, still getting this error when trying to submit a score despite the changes above

mySQL query error: INSERT INTO games_league (mid,gid,position,points,cat) VALUES ('862','715','1','10','1')
mySQL error: Duplicate entry '0' for key 1
mySQL error code:
Date: Friday 23rd 2008f May 2008 10:49:18 PM