Duplicate entry '72' for key 'PRIMARY' ??
Posted: Tue Oct 12, 2010 3:26 pm
I get that error when i...
Have a ring in the bag already, and try to buy another one (other id or similar).. or a new necklace.
I have them both to be in the playerjewelry DB.
BUT the rings have ID from 1 - 15. Rings have Location of Finger.
Amulets / Necklace have ID from 100+ Have Location of Neck.
I used the: or die( mysql_error() ); i got from chris. wich is a good thing.
But i have no clue what this error means.
Duplicate entry 72, must be the ID of the player, For the test char is ID 72 in DB.
But key PRIMARY. ???
Sidenote: i have more or less exact the same coding for weapons and armors,
but those i can buy 1000´s of the same if i want and not get the error.
Have a ring in the bag already, and try to buy another one (other id or similar).. or a new necklace.
I have them both to be in the playerjewelry DB.
BUT the rings have ID from 1 - 15. Rings have Location of Finger.
Amulets / Necklace have ID from 100+ Have Location of Neck.
I used the: or die( mysql_error() ); i got from chris. wich is a good thing.
But i have no clue what this error means.
Duplicate entry 72, must be the ID of the player, For the test char is ID 72 in DB.
But key PRIMARY. ???
Sidenote: i have more or less exact the same coding for weapons and armors,
but those i can buy 1000´s of the same if i want and not get the error.