stonedeft

Thank you this works... Kudos!!!

I will never upgrade. Plugin system cannot handle the heavy modifications to meet our company requirements. I reviewed the "delete client" and "delete users" routines under the method validateClientDeleteable() of the Clients Model, it checks if user has services, invoices and transactions, so logically, if I truncate those 3 tables I can successfully delete the client. I may leave footprints behind on other tables , but I think it will not break the system. fingers crossed

I cannot reinstall, I have some modifications on the database structure and heavy mods on some controller files. I just need to delete all clients and all services, invoices and transactions.

Hello, I am now done with tweaking and modifying some sections of blesta. While doing so I have created test Client accounts, services and transaction. I am now ready to go live and upload on a production server. I would like to delete all of the test accounts, with related services, invoices transactions, payment accounts and support tickets. I tried manually truncating the following tables. All seems well but when I tried to run Cron, something broke. accounts_cc clients client_account client_notes client_settings contacts contact_numbers contact_permissions cron_task_runs invoices invoice_delivery invoice_lines log_account_access log_contacts log_cron log_emails log_gateways log_transactions log_users services services_domains service_fields sessions transactions transactions_applied What Database Tables do I need to truncate. Thank you.