'QUERY ERROR: Duplicate entry '100' for key 2' Help please

[HarryB]

Hello there,

Can somebody please help me. I'm getting the error below after signing up to the game, please can somebody help. I'd really appreciate it.

Thanks

Game Link - www.deadly-planet.com

QUERY ERROR: Duplicate entry '100' for key 2

Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( 'Gangster', 'Gangster', md5('gangster'), 1, 100, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, 'Male', unix_timestamp(), '[email protected]', -1, 'IP.IP.IP.IP', 'IP.IP.IP.IP')

[Ragnar]

Re: 'QUERY ERROR: Duplicate entry '100' for key 2' Help please

Did you get it fixed? I just registered and didn't get any errors. (BTW, the images with text are hard to read.)

[POG1]

Re: 'QUERY ERROR: Duplicate entry '100' for key 2' Help please

you need to set the primary key field to auto incremntial

[Isomerizer]

Re: 'QUERY ERROR: Duplicate entry '100' for key 2' Help please

http://criminalexistence.com/ceforums/i ... ic=20893.0