I'm on J2.5.6 and VM 2.6.4 (last available release), using Gantry template (last available release).
Here are my server details:
Linux orion2 3.2.0-30-generic #48-Ubuntu SMP Fri Aug 24 16:52:48 UTC 2012 x86_64
5.5.32-0ubuntu0.12.04.1
utf8_general_ci
PHP 5.3.10-1ubuntu3.3+hs.1
It is normal not being able to remove orders? As I select an order and press the "delete" button, an error message comes out: vmError: VirtueMartModelOrders::remove ...(ID number).
I have no problems deleting orders, using J2.5.20 and VM2.6.6 (released 3 days ago) with Joomla/VM default templates.
There are reports in earlier versions of being unable to delete orders, with a "fix" posted here: http://forum.virtuemart.net/index.php?topic=107570.0 There can be problems if the payment or shipping method originally used for that order has been deleted.
Joomla 2.5.6 is old and insecure, so you may consider updating that. http://forum.virtuemart.net/index.php?topic=118683.0
Sorry Kelvyn, I do run J2.5.20 and vm 2.6.6. So, what could be the problem? I have red the post you mentioned but I don't think I'll be able to fix it.
I just noticed that as I try to remove an order, all data inside it are deleted (not the orede in the oreder list) but then COM_VIRTUEMART_UNKNOWN_ORDER_STATUS is written as the only data. Hope this means something.
I used the debug and this message came out:
JDatabaseMySQLi::query: 1146 - Table 'natured_it_dbjmi.yo1g7_virtuemart_payment_plg_' doesn't exist SQL=DELETE from `yo1g7_virtuemart_payment_plg_` WHERE `virtuemart_order_id` = 62
does it means something is missing?
If the problem is caused by deleted payment methods, then I do not have any change to solve it.
Invoices are connected to orders, so, according to my country rules, I have to start to invoice from number 1. But I cannot delete invoices (that I issued as test) without deleting orders. Is there a way to do it from DB?
In theory empty these tables
[attachment cleanup by admin]