[SOLVED] I have big problem. I don´t create new mail account

[crecos]

(03-27-2009 01:13 AM)crecos Wrote:  

(03-26-2009 08:38 AM)joximu Wrote:  I mean the structure!

Code:

CREATE TABLE `mail_users` (
`mail_id` int(10) unsigned NOT NULL auto_increment,
`mail_acc` varchar(200) collate utf8_unicode_ci default NULL,
`mail_pass` varchar(150) collate utf8_unicode_ci default NULL,
`mail_forward` text collate utf8_unicode_ci,
`domain_id` int(10) unsigned default NULL,
`mail_type` varchar(30) collate utf8_unicode_ci default NULL,
`sub_id` int(10) unsigned default NULL,
`status` varchar(255) collate utf8_unicode_ci default NULL,
`mail_auto_respond` tinyint(1) NOT NULL default '0',
`mail_auto_respond_text` text collate utf8_unicode_ci,
`quota` int(10) default '10485760',
`mail_addr` varchar(200) collate utf8_unicode_ci default NULL,
PRIMARY KEY  (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

please compare with your structure!

/J

Sorry,
I´m drop table mail_users and use your sql query (create again table mail_users) but problem is constantly the same.

Okey, I testing ubuntu 8.04 - 8.10.... mysql 5.0 and 5.1 but problem spring up only if mysql server is on external server... if ispCP and mysql server on one machine.... problem don´t exist.

some idea?