Author Topic: Cannot delete Orders  (Read 6037 times)

dimarini

  • Beginner
  • *
  • Posts: 7
Cannot delete Orders
« on: February 11, 2012, 12:58:01 pm »
Hello,
A strange thing happened!
In the backend in component Virtuemart, Orders & Shoppers I want to delete some orders!
When I tried to do so a red notice appeared saying "Order could not be deleted. VirtueMartModelOrders::remove 30"!
What is the problem and how to delete this order?

Thank you!

John2400

  • Virtuemart - the Future is ever Changing
  • Global Moderator
  • Hero Member
  • *
  • Posts: 1511
  • VirtueMart Version: 2.9.9F on joomla 3.3.6
Re: Cannot delete Orders
« Reply #1 on: February 13, 2012, 05:51:18 am »
This happened to me,

After updating to 2.0.1 e then f it disappeared.

Could you write to show which versions you are using.
Virtuemart versions 2.6.10 plus 11 on Joomla 2.5.25

and testing Virtuemart 2.9.9f on joomla 3.3.6

The new VM - <3 is looking good . Some new options not in 2 .. this will make customers happy

knirving

  • Beginner
  • *
  • Posts: 6
Re: Cannot delete Orders
« Reply #2 on: April 21, 2012, 19:46:56 pm »
I had the same issue today on two sites at 1.5.26 and VM 2.0.6

Received this Error:


        vmError:
        vmError: VirtueMartModelOrders::remove 12
        Order could not be deleted.

topart

  • Beginner
  • *
  • Posts: 1
Re: Cannot delete Orders
« Reply #3 on: April 24, 2012, 17:01:36 pm »
me 2.06

estaser

  • Beginner
  • *
  • Posts: 8
Re: Cannot delete Orders
« Reply #4 on: May 01, 2012, 12:45:08 pm »
Can you remove the orders? I have de same problem...  :'(

Clocked0ne

  • Jr. Member
  • **
  • Posts: 51
Re: Cannot delete Orders
« Reply #5 on: May 14, 2012, 21:03:25 pm »
Same problem here also on Joomla 1.7 and VM 2.0.6

ZX81

  • Beginner
  • *
  • Posts: 40
Re: Cannot delete Orders
« Reply #6 on: May 14, 2012, 21:37:45 pm »
I had got this problem on v2.0.4. My problem was caused when I deleted my paypal payment method (I was trying to fix another problem). I found that the orders have a link to the payment method and for some reason VM tries to validate the payment method on delete. The only way I could get around this was to delete the orders directly from the database.

Did you delete a payment method? If not maybe you deleted something else that is mandatory for orders?

ZX

Clocked0ne

  • Jr. Member
  • **
  • Posts: 51
Re: Cannot delete Orders
« Reply #7 on: May 15, 2012, 02:07:37 am »
Nothing was changed between the orders being placed and attempting to delete them, one was a new order placed only yesterday. As they are test orders I simply deleted them from the database and it is no big deal, live orders will simply be cancelled as necessary instead.

Tikkiro

  • Jr. Member
  • **
  • Posts: 81
Re: Cannot delete Orders
« Reply #8 on: July 10, 2012, 17:24:28 pm »
Glad to find I'm not alone on this one.  For me, it's primarily test orders that never went through to payment I'm unable to get deleted in the component but, as others have mentioned, it's relatively easy to do in the database although more care is required as it's not always so easy to be sure and of course easy, when you know your way around the DB - not so for a newbie :(   Perhaps the VM guys will take notice & work to provide a fix soon.

John2400

  • Virtuemart - the Future is ever Changing
  • Global Moderator
  • Hero Member
  • *
  • Posts: 1511
  • VirtueMart Version: 2.9.9F on joomla 3.3.6
Re: Cannot delete Orders
« Reply #9 on: July 11, 2012, 03:21:06 am »
I too could not delete some orders -

 I thank the developers for having a look and I found they can be deleted in the PHP myadmin - table ***.virtuemart .orders ** I pulled up the orders page in VM2 back end and then opened the table as well and deleted one at a time then refreshed - just to make sure -.

* always best to backup first - .
Virtuemart versions 2.6.10 plus 11 on Joomla 2.5.25

and testing Virtuemart 2.9.9f on joomla 3.3.6

The new VM - <3 is looking good . Some new options not in 2 .. this will make customers happy

avkeele

  • Beginner
  • *
  • Posts: 26
Re: Cannot delete Orders
« Reply #10 on: January 27, 2013, 16:13:09 pm »
It's January 2013, and I'm having this problem with VM 2.0.18a on Joomla 2.5.8. When I try to delete a test order, I get:

vmError: Seems the used shipmentmethod got deleted
vmError: TableOrders delete Order shipmentTable = #__virtuemart_shipment_plg_ `virtuemart_order_id` = 19 dbErrorMsg
vmError: VirtueMartModelOrders::remove 19
Order could not be deleted.

I did not change shipment methods or anything else between creating the test order and attempting to delete it. Hopefully the developers will add this to the bugs to be fixed

ufo_hk

  • Jr. Member
  • **
  • Posts: 74
    • 4success Ltd
Re: Cannot delete Orders
« Reply #11 on: March 20, 2013, 00:04:51 am »
Joomla 2.5.9 Vm 2.0.20b recently updated from 2.0.18

Tried deleting order in admin - received error message:
vmError: Seems the used shipmentmethod got deleted
vmError: TableOrders delete Order shipmentTable = #__virtuemart_shipment_plg_ `virtuemart_order_id` = 19 dbErrorMsg
vmError: VirtueMartModelOrders::remove 1
Order could not be deleted.

So entered database "xxxx_virtuemart_orders" table and deleted offending order. Seemed to work fine as order disppeared.

However considering that the OP was logged over a year ago would be nice for someone to confirm if this is a suitable/correct solution

t68

  • Jr. Member
  • **
  • Posts: 110
Re: Cannot delete Orders
« Reply #12 on: April 16, 2013, 09:22:00 am »
Also have problems removing some testorders. get error message:
"vmError:
vmError: VirtueMartModelOrders::remove 16
Order could not be deleted."

Weird thing: when I mark an order and press delete the name and email in the order is deleted and I end up with an almost empty order with an ID that cannot be deleted.

Se some posts about entering the DB to remove. How do I do that. Not familiar with doing stuff directly in the DB.

ufo_hk

  • Jr. Member
  • **
  • Posts: 74
    • 4success Ltd
Re: Cannot delete Orders
« Reply #13 on: September 04, 2013, 06:42:18 am »
@t68

Follow instructions in this thread from ivus - re manually deleting orders:
http://forum.virtuemart.net/index.php?topic=107570.0

You need to access your database to edit usually via PHPmyadmin, check with your hoster.

VirtueMart Forum

Re: Cannot delete Orders
« Reply #13 on: September 04, 2013, 06:42:18 am »