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

[Zebra Hosting]

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)
1452: 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)

                              ADOConnection._Execute(insert into vtiger_user2role (userid, roleid) values(16,'H2')) % line 1027, file: adodb.inc.php<file://var/www/vhosts/dreamwoodinternational.com/crm.dreamwoodinternational.com/libraries/adodb/adodb.inc.php>
                           ADOConnection.Execute(insert into vtiger_user2role (userid, roleid) values(?,?), Array[2]) % line  359, file: PearDatabase.php<file://var/www/vhosts/dreamwoodinternational.com/crm.dreamwoodinternational.com/include/database/PearDatabase.php>
                        PearDatabase.pquery(insert into vtiger_user2role (userid, roleid) values(?,?), Array[2]) % line  965, file: Users.php<file://var/www/vhosts/dreamwoodinternational.com/crm.dreamwoodinternational.com/modules/Users/Users.php>
                     Users.insertIntoEntityTable(vtiger_user2role, Users) % line  766, file: Users.php<file://var/www/vhosts/dreamwoodinternational.com/crm.dreamwoodinternational.com/modules/Users/Users.php>
                  Users.saveentity(Users) % line 1145, file: Users.php<file://var/www/vhosts/dreamwoodinternational.com/crm.dreamwoodinternational.com/modules/Users/Users.php>



Bastiaan Houtkooper
Zebra Hosting

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141021/e12ded4d/attachment.html>