Sql Help!

Dracoy

Diabloii.Net Member
Sql Help!

Code:
mySQL query error: INSERT INTO ibf_games_list
        			(gname,gwords,gtitle,bgcolor,gwidth,gheight,active,object,gkeys,gcat,added,highscore_type) VALUES
                    ('mahjong','','Mah Jong',000,400,400,1,'','',1,1112646734,'high')

mySQL error: Duplicate entry '127' for key 1
mySQL error code: 
Date: Monday 04th of April 2005 01:32:14 PM
Does anyone know how to add another key or something? I checked there is no duplicaate entry probably using the keys or something ><
 

kryo

Diabloii.Net Member
If you've got auto_increment set on a small key field (for example, a signed TINYINT would yeild a maximum value of 127, so that's probably what you've got), you'll run into problems like that.

You should be able to fix it by simply changing the problem key to something larger, like INT(11).
 

Dracoy

Diabloii.Net Member
kryo said:
If you've got auto_increment set on a small key field (for example, a signed TINYINT would yeild a maximum value of 127, so that's probably what you've got), you'll run into problems like that.

You should be able to fix it by simply changing the problem key to something larger, like INT(11).
Where would i find this TINYINT?
Found it how do i change it in mysql manager?
 

kryo

Diabloii.Net Member
Not sure of the specifics of the frontend you use, but it should be as simple as executing a command to the effect of "ALTER TABLE [table name] MODIFY [field name] INT(11);", if I recall the syntax.
 
Top