Print Page - Cannot import contactgroupmembers

Title: Cannot import contactgroupmembers
Post by: rhopek on January 18, 2012, 06:22:31 AM

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.

Title: Cannot import contactgroupmembers
Post by: rhopek on January 20, 2012, 02:11:42 AM

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

Title: Cannot import contactgroupmembers
Post by: alec on January 20, 2012, 02:30:54 AM

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

Title: Re: Cannot import contactgroupmembers
Post by: thanhnv on October 17, 2012, 04:46:31 AM

I have a same problem. Please help us ! Tks

Title: Re: Cannot import contactgroupmembers
Post by: thanhnv on October 17, 2012, 05:07:40 AM

hi ,

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

Roundcube Community Forum

Release Support => Pending Issues => Topic started by: rhopek on January 18, 2012, 06:22:31 AM