Habbo (Wabbo) Duplicate entry '4' for key 'PRIMARY'

[Timothy]

So I am 'trying' to get WabboCMS to work with MercuryEMU etc. And it works just the register gives me the error "Duplicate entry '4' for key 'PRIMARY'" and its a bit irritating although when I refresh it says the username is taken so when I login it works perfectly just the register is a bit bugged. -_- I went through the whole db trying to see if I can fix it but I do not know. ANY HELP?

 

[ChrisRetro]

Screenshot?

 

[Timothy]

Screenshot?

It just says on a white page, "Duplicate entry '4' for key 'PRIMARY'"
LOL

 

[Jerry]

The reason why the error has been generated is because there is already an existing value of 4 for the column ID in which you define it as PRIMARY KEY (values are unique) in the table you are inserting.

Why not set the column ID as AUTO_INCREMENT?

 

[Timothy]

The reason why the error has been generated is because there is already an existing value of 4 for the column ID in which you define it as PRIMARY KEY (values are unique) in the table you are inserting.

Why not set the column ID as AUTO_INCREMENT?

It is set as AUTO_INCREMENT lol

 

[ChrisRetro]

Check for the same value of '4' if you find it change it to something else...

 

[Timothy]

Check for the same value of '4' if you find it change it to something else...

In were in the users table? lol

 

[ChrisRetro]

Screen Shot your user table ( Design Table )

 

[Timothy]

Screen Shot your user table ( Design Table )

You must be registered for see images attach

and

You must be registered for see images attach

 

[Jerry]

Should be either in user_stats table or the user_info table.

 

[Timothy]

Should be either in user_stats table or the user_info table.

No only has the one account I registered in which did still bring up the error but still registered me so lol

===FIXED===
Yeah, I am retarded I missed going through though's tables. My bad, lol.

 

[ChrisRetro]

Well done