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 : but get this error message - 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
Changing the field type and changing a field in a record that produces a duplicate index entry are two totally different things. As far as the first one goes, you can't change the categoryid to 2 if there's already a record for memberid 3933-27243-2 with a categoryid of 2. Changing the field type won't help - you're still trying to create a duplicate record. For that one memberid, just delete the record that has a categoryid of 1.