[Vtigercrm-developers] Purge / clear data

[Alan Lord]

Usually when you empty the recycle bin it _should_ remove the entire 
record from the database... As I recall however there were a few modules 
where this didn't quite happen correctly and either the row in the 
crmnetity, or the module's main and/or "cf" tables were left accidentally.

You'll need to write some queries looking for "orphan" rows, and ideally 
make sure that all references to that record are removed, think things 
like events/emails, only-run-once workflow triggers etc...

I'm not aware of any docs on this subject.

These "orphan" records can actually cause issues with some of the newer 
migration scripts which try to set foreign key constraints.

I tried to search for the issue I reported but code.vtiger.com appears 
to be rather unresponsive right now. (Search for "migration" or similar)

HTH


Al



On 26/06/2019 20:32, Stuart Maynard-Keene wrote:
> Hi, I have a configured install of vTiger 6.5, which over numerous years I have added functionality and custom fields to. I would like to duplicate this install to create a new version but without the existing data.
> 
> By existing data, I mean leads, documents (file in /storage). I have already 'deleted' through the interface and emptied trash however the records are still in the relevant table, only flagged to 1. From a GDPR perspective this is also very suspect.
> 
> I'm pretty conversant with the MySQL data structure and entity tables but I was wondering if there is a simple way to purge this data or if there is any sort of documentation out there to take on this task.
> 
> Any advice would be grateful.
> 
>   
> --
>   
> Cheers,
> Stu
> 
> 
> 
> _______________________________________________
> http://www.vtiger.com/
>