auto reply table can not be created

Joni-Pekka Kurronen <[email protected]>
Newsgroups gmane.mail.imap.dbmail
Message-ID <[email protected]>


> EXECUTE:
> 
> CREATE TABLE dbmail_auto_replies (
>         user_idnr bigint(20) UNSIGNED DEFAULT '0' NOT NULL,
>         start_date DATETIME NOT NULL,
>         stop_date DATETIME NOT NULL,
>         reply_body MEDIUMTEXT,
>         INDEX user_idnr_index (user_idnr),
>         FOREIGN KEY user_idnr_fk (user_idnr)
>                 REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON
> UPDATE CASCADE
> ) ENGINE InnoDB DEFAULT CHARSET=utf8;
> 
> 
> 
> RESULT:
> 
> Failed to execute SQL : SQL CREATE TABLE dbmail_auto_replies ( user_idnr
> bigint(20) UNSIGNED DEFAULT '0' NOT NULL, start_date DATETIME NOT NULL,
> stop_date DATETIME NOT NULL, reply_body MEDIUMTEXT, INDEX
> user_idnr_index (user_idnr), FOREIGN KEY user_idnr_fk (user_idnr)
> REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE InnoDB DEFAULT CHARSET=utf8; failed : Can't create table
> `dbmail`.`dbmail_auto_replies` (errno: 121 "Duplicate key on write or
> update")
> 
> TABLES CREATED:
>  	dbmail_acl 	Table (InnoDB) 	0 	13
> 	dbmail_aliases 	Table (InnoDB) 	10 	4
> 	dbmail_authlog 	Table (InnoDB) 	0 	12
> 	dbmail_auto_notifications 	Table (InnoDB) 	0 	2
> 	dbmail_envelope 	Table (InnoDB) 	0 	3
> 	dbmail_filters 	Table (InnoDB) 	0 	5
> 	dbmail_header 	Table (InnoDB) 	0 	3
> 	dbmail_headername 	Table (InnoDB) 	0 	2
> 	dbmail_headervalue 	Table (InnoDB) 	0 	5
> 	dbmail_keywords 	Table (InnoDB) 	0 	2
> 	dbmail_mailboxes 	Table (InnoDB) 	1 	13
> 	dbmail_messages 	Table (InnoDB) 	0 	12
> 	dbmail_mimeparts 	Table (InnoDB) 	0 	4
> 	dbmail_partlists 	Table (InnoDB) 	0 	6
> 	dbmail_pbsp 	Table (InnoDB) 	0 	3
> 	dbmail_physmessage 	Table (InnoDB) 	0 	4
> 	dbmail_referencesfield 	Table (InnoDB) 	0 	3
> 	dbmail_replycache 	Table (InnoDB) 	0 	4
> 	dbmail_sievescripts 	Table (InnoDB) 	0 	4
> 	dbmail_subscription 	Table (InnoDB) 	0 	2
> 	dbmail_upgrade_steps 	Table (InnoDB) 	4 	3
> 	dbmail_usermap 	Table (InnoDB) 	0 	4
> 	dbmail_users 	Table (InnoDB) 	4 	13
> 	user_id_index 	Index 	Index 	2
> 	mailbox_id_index 	Index 	Index 	2
> 	alias_index 	Index 	Index 	1
> 	client_idnr_index 	Index 	Index 	1
> 	user_idnr_index 	Index 	Index 	1
> 	physmessage_id_1 	Index 	Index 	1
> 	physmessage_id_2 	Index 	Index 	2
> 	user_id 	Index 	Index 	1
> 	physmessage_id 	Index 	Index 	4
> 	headername_id 	Index 	Index 	1
> 	headervalue_id 	Index 	Index 	1
> 	physmessage_id_headername_id 	Index 	Index 	2
> 	
>     	Name    	Type    	Rows    	Fields   
> 	physmessage_id_headervalue_id 	Index 	Index 	2
> 	headername_id_headervalue_id 	Index 	Index 	2
> 	headername 	Index 	Index 	1
> 	hash 	Index 	Index 	2
> 	headervalue 	Index 	Index 	1
> 	sortfield 	Index 	Index 	1
> 	datefield 	Index 	Index 	1
> 	owner_idnr_name_index 	Index 	Index 	2
> 	name_index 	Index 	Index 	1
> 	owner_idnr_index 	Index 	Index 	1
> 	seq_index 	Index 	Index 	1
> 	physmessage_id_index 	Index 	Index 	1
> 	mailbox_idnr_index 	Index 	Index 	1
> 	seen_flag_index 	Index 	Index 	1
> 	unique_id_index 	Index 	Index 	1
> 	status_index 	Index 	Index 	1
> 	mailbox_status 	Index 	Index 	2
> 	dbmail_messages_seq_index 	Index 	Index 	1
> 	message_parts 	Index 	Index 	4
> 	part_id 	Index 	Index 	1
> 	ipnumber_index 	Index 	Index 	1
> 	since_index 	Index 	Index 	1
> 	replycache_1 	Index 	Index 	3
> 	owner_idnr_2 	Index 	Index 	2
> 	name 	Index 	Index 	1
> 	owner_idnr 	Index 	Index 	1
> 	from_version 	Index 	Index 	2
> 	usermap_idx_1 	Index 	Index 	3
> 	userid_index 	Index 	Index 	1
> 	dbmail_ccfield 	View 	
> 	
> 	dbmail_datefield 	View 	
> 	
> 	dbmail_fromfield 	View 	
> 	
> 	dbmail_subjectfield 	View 	
> 	
> 	dbmail_tofield 	View 	
> 	
> 
> 
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.