> [Native message: Table 'roundcubemail.contactgroups' doesn't exist] > > So the DB structure seems to be corrupted, I will modify it per hand.
creating the contactgroups table failed. things i did: 1. all my existing tables were of latin1_swedish_ci collation. i changed that to utf8. 2. all my tables were myisam, i updated to innodb 3. users.user_id defaults to null. i do not know if the constraint has been a problem too.. > CREATE TABLE `contactgroups` ( > `contactgroup_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, > `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', users.user_id defaults null. contactgroups.user_id defaults '0'.. > `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', > `del` tinyint(1) NOT NULL DEFAULT '0', > `name` varchar(128) NOT NULL DEFAULT '', > PRIMARY KEY(`contactgroup_id`), > CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`) > REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, maybe this constraint might be an issue? i then managed to create the table when ommiting the /*!40000 ENGINE=INNODB */ command and then altered the engine from myisam to innodb. i also omitted the ENGINE declaration for contactgroupmembers and again altered the engine afterwards. fyi: i'm running an older mysql 5.0 release. maybe this will help you in tracking down this issue? thanks for creating such a great release! cheers, raoul -- ____________________________________________________________________ DI (FH) Raoul Bhatia M.Sc. email. [email protected] Technischer Leiter IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at Barawitzkagasse 10/2/2/11 email. [email protected] 1190 Wien tel. +43 1 3670030 FN 277995t HG Wien fax. +43 1 3670030 15 ____________________________________________________________________ _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/8f4f07cd
