[wp-trac] [WordPress Trac] #4410: wp_term_relationship

[WordPress Trac]

#4410: wp_term_relationship
---------------------+------------------------------------------------------
 Reporter:  znuff    |       Owner:  anonymous         
     Type:  defect   |      Status:  new               
 Priority:  high     |   Milestone:  2.3 (trunk)       
Component:  General  |     Version:  2.3               
 Severity:  major    |    Keywords:  database, taxonomy
---------------------+------------------------------------------------------
 After the last wordpress database update (trunk) I'm experiencing problems
 with tags. Every time I post something I get a:
 {{{
 WordPress database error: [Duplicate entry '(the posts id)' for key 1]
 }}}
 Is anyone else experiencing the same issue with the latest database
 version (5539)? or did I miss an update along the way that's causing this?
 This is what I currently have as the table's structure:

 {{{
 CREATE TABLE `wp_term_relationships` (
   `object_id` bigint(20) NOT NULL default '0',
   `term_taxonomy_id` bigint(20) NOT NULL default '0',
   PRIMARY KEY  (`object_id`),
   KEY `term_taxonomy_id` (`term_taxonomy_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 }}}

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4410>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software