clonemeagain
All data is not cleaned up
osTicket 1.12.2
I have found that after the archiver runs via cron, there are still lots of orphaned records left behind. Most of those can be deleted like this:
DELETE FROM dbprefix.soft_threadWHEREobject_type= 'T' ANDobject_idNOT IN (SELECTticket_idFROMsoft_ticket);
DELETE FROM dbprefix.soft_thread_entryWHEREthread_id NOT IN (SELECT id FROM soft_thread);
DELETE FROM dbprefix.soft_thread_entry_emailWHEREthread_entry_id NOT IN (SELECT id FROM soft_thread_entry);
I have also determined that soft_thread_event also seems to be an ever growing table, and I have not yet addressed it with cleanup queries.
The reason why this is an issue for me is that I am hosting on a SiteGround shared account, and all databases are limited to 1GB, so we cannot have an ever-growing database, it needs to be kept pruned.
Thoughts?
