Cannot import contactgroupmembers

[rhopek]

We are migrating data from some old servers to some new servers. All servers are running 0.5.3 (not upgrading until all data is migrated). We have the users, contacts and contactgroups imported, but when we try to import the contactgroupmembers, we get:

MySQL #1452 - Cannot add or update a child row: a foreign key constraint fails (`roundcubemail`.`contactgroupmembers`, CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE)

The only notable difference here is that we went from MySQL 5.1.56 to 5.5.19. We've seen old bug reports from the 0.3-0.4 days, mostly surrounding MyISAM/InnoDB conversion issues, but all of these servers have RoundCube using InnoDB tables.

We need to get these groupmembers imported badly. Any thoughts would be appreciated.

[rhopek]

Anyone? We have hundreds of customers for which we we need to import these records.

[alec]

It looks that contactgroupmembers table contains records pointing to non-existent contact_id.

[thanhnv]

I have a same problem. Please help us ! Tks

[thanhnv]

hi ,

I just deleted this database and create new database , after that , I import *.sql to new database. It works fine.