Duplicate entry '' for key 2 for unique key

[msolution]

Im getting vague errors with keys with multiple attributes,

this is my table,

CREATE TABLE my_table ( 
`id` int(11) NOT NULL auto_increment,
`site_id` bigint(11) NOT NULL default '1',
`blog_id` bigint(11) NOT NULL default '1',
`title` varchar(255) NOT NULL default '',
`enabled` int(11) NOT NULL default '1',
PRIMARY KEY `id` (`id`), 
UNIQUE KEY `k_sites_id` (`site_id`, `blog_id`),
KEY `k_site_id` (`site_id`),
KEY `k_blog_id` (`blog_id`),
KEY `k_enabled` (`enabled`),
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;";

and these are the errors im getting:

Duplicate entry '1095-6' for key 2

on checking the table with where site_id = '1095', it has no row where blog_id = 6

any help is appreciated 🙂

mysql version: 5.0.77

[dagon]

msolution;10977906 wrote:

on checking the table with where site_id = '1095', it has no row where blog_id = 6

any help is appreciated 🙂

are you sure this returns nothing:

SELECT * from my_table WHERE site_id="1095" AND blog_id="6"