Bug #58027 Mysql Duplicate entry Error to Update A Table
Submitted: 6 Nov 2010 9:26 Modified: 8 Dec 2010 13:44
Reporter: Md Jahidul Islam Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version: OS:Windows (windows 7)
Assigned to: CPU Architecture:Any
Tags: Duplicate entry, error, Udpate, Wordpress

[6 Nov 2010 9:26] Md Jahidul Islam
Description:
Error

SQL query:

UPDATE `wp_term_relationships` SET `term_taxonomy_id` =1034 WHERE `object_id` =3157 AND `term_taxonomy_id` =1

MySQL said: Documentation
#1062 - Duplicate entry '3157-1034' for key 1 

How to repeat:

When i try to update a table with easy wamp - php myadmin sql editor
[8 Nov 2010 13:44] Johannes Taxacher
That sounds like some data error (not a bug of Workbench) - can you check if that problem also appeas when you execute the statement from commandline client?
thanks in advance
[9 Dec 2010 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".