[Vtigercrm-developers] unable to add user (a migration report)

[Alan Lord]

On 21/10/14 13:05, Zebra Hosting wrote:
> With the DB debug on I was able to find this error:
>
> Query: insert into vtiger_user2role (userid, roleid) values(16,'H2')
> failed. Cannot add or update a child row: a foreign key constraint fails
> (`dream_crm2`.`vtiger_user2role`, CONSTRAINT `fk_2_vtiger_user2role`
> FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE)

I would definitely check vtiger_field and vtiger_blocks for duplicate 
fields and blocks (especially for the vtiger_users tablename).

We were seeing this type of error yesterday which turned out to be due 
to an earlier query failure caused by duplicate fields - check the 
vtigercrm.log as well...

HTH

Al