Re: [RCD] recipient selection problem

[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