[Clear Client Data For Production Launch]

if you have zero real customers, bellow sql is what I had to do in similar case, it's remove all row in each considered table:

 

Run one line by one sql query:

truncate support_replies;

truncate support_tickets;

truncate invoice_delivery;

truncate invoice_lines;

truncate invoices;

truncate order_services;

truncate orders;

truncate service_fields;

truncate services;

truncate transaction_applied;

truncate transactions;

truncate log_account_access;

truncate log_contacts;

truncate log_emails;

truncate log_gateways;

truncate log_modules;

truncate log_phpids;

truncate log_services;

truncate log_transactions;

truncate log_users;

truncate log_cron;

 

 

But save your database before, so if you find it's not fine for you, you can back

 

 

 

Thank you this works... Kudos!!!

[Clear Client Data For Production Launch]

what you will do in case of upgrade ?

 

you need to truncate orders table ,and some other tables also ....

 

as licensecart suggested , re-install blesta , but before save your currecnt database tructure to compare it with  the new tables . 

 

another soltion is to not delete any thing, just change the autoincrement number of invoice to begin from the first

 

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 

[Clear Client Data For Production Launch]

Just re-install Blesta. You shouldn't use a production environment for testing on, or you should have a backup database to restore.

 

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.  

[Clear Client Data For Production Launch]

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.