ERROR 1062: Duplicate entry '0' for key

[Anon]

Hey... any idea why i would get this error when I was trying to update a record?

ERROR 1062: Duplicate entry '0' for key 1

thanks 🙂

[[deleted]]

Maybe because you already have a record with value '0' in that table, and that column is set to 'unique'?

[Anon]

This error is caused by attempting to insert a duplicate record in the database column that is designated to be UNIQUE.