wp_term_relationship

[znuff]

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;

[ryan]

That's an old version of the schema that has a bad primary key. You can drop the term tables and decrement the db_version (via wp-admin/options.php) to force an another upgrade. If you don't want to drop the tables, you can change the primary key to (object_id,term_taxonomy_id) with phpmyadmin.