vtiger

[doyleshawn]

Getting a error when viewing records (contacts, accounts) after upgrading from 5.03 to 5.04. Any ideas?

[doyleshawn]

Restored from backup and tried again. This time selecting to update the database from 5.0 to 5.4 (I'm pretty sure 5.03 was installed)

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

This is the only error, and I can't seem to find anything that doesn't work.
Since this looks like it's just a constraint, can I add it manually or do I need to be concerned?

TIA
-Shawn

[Asha]

Hi,
doyleshawn wrote:

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

This is the only error, and I can't seem to find anything that doesn't work.
Since this looks like it's just a constraint, can I add it manually or do I need to be concerned?

If this is the only query that is failing and everything else is working fine for you, you can try adding this constraint manually. That shouldn't cause any harm.

But I doubt if you can succeed in manually adding this constraint. I have a doubt that you data in vtiger_parenttabrel table is not consistent with vtiger_parenttab which might be causing the constraint addition to fail.

Anyway, you can continue using the CRM without this constraint too.