...

View Full Version : #1062 - Duplicate entry '23933-27243-0' for key 'membersid'



basketmen
11-20-2011, 05:40 PM
Hi guys,

I have a table, the table name is account,
its have 2 fields : membersid, and categoryid



i want to change the categoryid field content, i run this in phpmyadmin :


update `account` set categoryid = replace (categoryid, '1' , '2');



but get this error message


#1062 - Duplicate entry '23933-27243-2' for key 'membersid'








- what should i do so i can change the field content? Please help.
I already tried changing the field TYPE, from INT, to BIGINT, like other person suggested, but still get that error message

- this is the screenshot from the field Structure

http://i291.photobucket.com/albums/ll284/basketmen/field.jpg

Old Pedant
11-20-2011, 09:22 PM
Don't show the field info. Show the entire table's info, including the indexes.

I would guess that you have a composite key defined on that table and indeed when you tried to change the category from 1 to 2 you managed to create a duplicate composite key.

Try issuing the command

DESCRIBE TABLE account;

and if you can't figure out what it shows you, show the result to us.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum