Manually change order status

[seyi]

Hello

Using
- Joomla 1.7
- Virtuemart 1.9.8.RC2J

In the backend, when I try to manually change the order status of an order on the order list, nothing happens.

[Awerso]

same here..

Also when I'm trying to delete an order i get an error: Order could not be deleted.

[miguel365]

same here..

Also when I'm trying to delete an order i get an error: Order could not be deleted.

same for me 

[PRO]

just worked for me

you have to go INSIDE the actual order to change it

I DO GET an empty error message container as soon as I open an order.



is there a js error when you hit save?

[attachment cleanup by admin]

[PRO]

Trying to delete EMPTYS the information from the order, but it is still in the order list.

When I click on the deleted order I get.


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM `678_virtuemart_payment_plg_standard` WHERE `virtuemart_order_id` =

[Milbo]

Still valid for the RC3 h?

ah okey, we take a loook.

[alatak]

Hi,

Red line on the order view fixed.

[alatak]

Hi,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM `678_virtuemart_payment_plg_standard` WHERE `virtuemart_order_id` =

I cannot reproduce that error.
Can you give more input?

[PRO]

Hi,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM `678_virtuemart_payment_plg_standard` WHERE `virtuemart_order_id` =

I cannot reproduce that error.
Can you give more input?

When you delete order. The order stays there. BUT the address, user etc. is gone.

When you click the order link of the order that was deleted.

[bunglehaze]

I am getting an issue where you cancel an order or delete it from the backend but the stock does not get returned available - 1 show's in stock as an example but I get a product out of stock notification while adding to cart

[Milbo]

The action cancel can change the stock. But not always

The action delete should not change the stock imho.

[bunglehaze]

Oddly though the stock seems to have returned back (ie there was 1 in stock before the test sale and after cancellation it is now showing 1) but trying to add it to cart throws up the product out of stock message - perhaps an issue with the database I guess from an earlier test release but any idea where I need to look to manually fix it?

[Milbo]

ai,
maybe that is connected to the virtual stock, thx. That means it puts it back in the virtual stock, but not from the already ordered products stock.

[kg]

Confirming that delete order in  RC3_Pre_K doen't work.
Order data is erased, but order is still there.

Error message is:
Order could not be deleted.
VirtueMartModelOrders::remove 1

When debugging I can see that it has to do with the shipping method issue reported in other posts. The error from debug is:
Table 'xxxxxx.jos_virtuemart_order_shipment_weight_countries' doesn't exist SQL=DELETE from `jos_virtuemart_order_shipment_weight_countries` WHERE `virtuemart_order_id` = 1

[Milbo]

virtuemart_order_shipment_weight_countries

This is an old table, be sure that you installed the aio correclty and of course, when you used before a buggy plugin, there will stay rests in the sytem. But it shouldnt hurt.