vtiger

[jcarlosa]

Congratulations for the beatiful release 5.0.3.

I migrate from 5.0.2 and at end when execute scripts two comand don´t execute:

ALTER TABLE vtiger_parenttabrel ADD CONSTRAINT fk_2_vtiger_parenttabrel FOREIGN KEY (parenttabid) REFERENCES vtiger_parenttab(parenttabid) ON DELETE CASCADE;

ALTER TABLE vtiger_ticketgrouprelation ADD CONSTRAINT fk_1_vtiger_ticketgrouprelation FOREIGN KEY (groupname) REFERENCES vtiger_groups(groupname) ON UPDATE CASCADE;

The first i execute manualy and success, but a second occurs this msg:

Erro
comando SQL:

ALTER TABLE vtiger_ticketgrouprelation ADD CONSTRAINT fk_1_vtiger_ticketgrouprelation FOREIGN KEY ( groupname ) REFERENCES vtiger_groups( groupname ) ON UPDATE CASCADE
Mensagens do MySQL :

#1216 - Cannot add or update a child row: a foreign key constraint fails

Please any help me.

Tanks a lot.

[Liza]

Dear jcarlosa,
Kindly refer the following link. This may help you.
http://forums.vtiger.com/viewtopic.php?t=14772

Thanks & Regards,
Liza.