Re: Duplicate entry '3841' for key 1 in query

[mikeh]

This is table structure;

CREATE TABLE `config` (
`config_id` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`type` smallint(6) default '0',
`value` varchar(255) default NULL,
`blob_value` blob,
PRIMARY KEY (`config_id`),
UNIQUE KEY `name` (`name`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 AUTO_INCREMENT=3841 ;

Keyname Type Cardinality Field
PRIMARY PRIMARY 101 config_id
name UNIQUE 101 name

Can you elaborate on what to look for, and how to fix?

Thanks
mike



Edited 3 time(s). Last edit at 11/14/2005 03:00AM by mikeh.