[Vtigercrm-developers] Purge / clear data

Alan Lord alanslists at gmail.com
Mon Jul 1 13:12:00 GMT 2019

On 01/07/2019 13:32, Sutharsan J wrote:
> HI
> If your database has proper foreign key constraints, it will remove all 
> entity data when you clear vtiger_crmentity table (i.e flush recycle 
> bin). Eg, For accounts
> ALTER TABLE `vtiger_account`
>    ADD CONSTRAINT `fk_1_vtiger_account` FOREIGN KEY (`accountid`) 
> REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;

This is correct but these were only added relatively recently to the 
migration scripts. If you are upgrading and you have inconsistent row 
ids between any of the tables these constraints fail.


More information about the vtigercrm-developers mailing list