Lid |
|
Hey,
Ik heb deze query:
INSERT INTO mantis_user_table (username, realname, email, password, date_created, enabled) VALUES ('blaat', 'blaat', 'email', '0cc175b9c0f1b6a831c399e269772661', NOW(), 0)
INSERT INTO mantis_user_table (username, realname, email, password, date_created, enabled) VALUES ('blaat', 'blaat', 'email', '0cc175b9c0f1b6a831c399e269772661', NOW(), 0)
Dit is de structuur:
CREATE TABLE `mantis_user_table` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(32) NOT NULL default '',
`realname` varchar(64) NOT NULL default 'verborgen',
`email` varchar(64) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`date_created` datetime NOT NULL default '1970-01-01 00:00:01',
`last_visit` datetime NOT NULL default '1970-01-01 00:00:01',
`enabled` tinyint(4) NOT NULL default '0',
`protected` tinyint(4) NOT NULL default '0',
`access_level` smallint(6) NOT NULL default '10',
`login_count` int(11) NOT NULL default '0',
`lost_password_request_count` smallint(6) NOT NULL default '0',
`failed_login_count` smallint(6) NOT NULL default '0',
`cookie_string` varchar(64) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_user_cookie_string` (`cookie_string`),
UNIQUE KEY `idx_user_username` (`username`),
KEY `idx_enable` (`enabled`),
KEY `idx_access` (`access_level`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
CREATE TABLE `mantis_user_table` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(32) NOT NULL default '', `realname` varchar(64) NOT NULL default 'verborgen', `email` varchar(64) NOT NULL default '', `password` varchar(32) NOT NULL default '', `date_created` datetime NOT NULL default '1970-01-01 00:00:01', `last_visit` datetime NOT NULL default '1970-01-01 00:00:01', `enabled` tinyint(4) NOT NULL default '0', `protected` tinyint(4) NOT NULL default '0', `access_level` smallint(6) NOT NULL default '10', `login_count` int(11) NOT NULL default '0', `lost_password_request_count` smallint(6) NOT NULL default '0', `failed_login_count` smallint(6) NOT NULL default '0', `cookie_string` varchar(64) NOT NULL default '', UNIQUE KEY `idx_user_cookie_string` (`cookie_string` ), UNIQUE KEY `idx_user_username` (`username` ), KEY `idx_enable` (`enabled` ), KEY `idx_access` (`access_level` ) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
Heeft iemand enig idee waarom ik de volgende error krijg?
Duplicate entry '' for key 2
Ik vermoed dat het iets met het veld cookie_string te maken heeft, maar ik ben niet zeker.
Het betreft een mantis tabel.
Kilian
|