Phoca Forum

Hi,

sorry for the [Urgent] but it is...
I hope your indulgence.


It's time to go online for our shop...
So I'd like to clean all the database infos gathered during development tests.
I have already deleted dummies products but now I need to clean orders.

1°On backend I changed the order statuts to 'Pending'. And then deleted them. OK
2° With phpMyAdmin I see that `jos_vm_orders` is empty now.
But I should reinitialize increment by this SQL command :
ALTER TABLE `jos_vm_orders` AUTO_INCREMENT =1
3°But 3 tables created by Phoca are still with old datas :
`#__{vm}_bills`
`#__{vm}_deliveries`
`#__{vm}_delivery_item`

Should I delete all the datas from these 3 tables and then reinitialize increment ?

Is it safe ?
No other tables to clean ?

Thanks for your help.
Paul

Hi, sorry, I think this is more VM question, you can delete all data from IDNR addon tables (see in guide which they are), if you want to clean all your VM data, then I think, you need to clean the order table but maybe some others too - but this is then question on VM forum

Jan