"QUERY ERROR: Duplicate entry '100' for key 2" with Mccodes V2 register page.

[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')

[Isomerizer]

Re: "QUERY ERROR: Duplicate entry '100' for key 2" with Mccodes V2 register page

INSERT INTO users (userid, 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( NULL, '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')

As your trying to overwrite current columns in the db, also you should quote your sql.