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.
same here..
Also when I'm trying to delete an order i get an error: Order could not be deleted.
Quote from: Awerso on October 24, 2011, 21:35:01 PM
same here..
Also when I'm trying to delete an order i get an error: Order could not be deleted.
same for me :o
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]
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` =
Still valid for the RC3 h?
ah okey, we take a loook.
Hi,
Red line on the order view fixed.
Hi,
QuoteYou 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?
Quote from: alatak on December 10, 2011, 01:22:56 AM
Hi,
QuoteYou 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.
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
The action cancel can change the stock. But not always
The action delete should not change the stock imho.
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?
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.
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
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.
Hi,
QuoteWhen 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
When updating to the K version, you should recreate or save again the shipment / payment methods. The correct tables will be created.
Was the issue of being able to delete orders ever solved?
I unfortunately have this problem.
I'm using the latest version from SVN and order delete works just fine.
I believe I am using the latest version - VM2.0.0 with J1.7.0
I did update from pre_K and had a couple issues but I thought I resolved all of them and I did run an "install tables or update them if necessary".
Any thoughts on why I still have this problem or a solution?
Thanks!
The SVN is a development version, a precursor to the VM2 update to be released soon. That update should fix your problem.
oops sorry I miss understood your first post.
Thanks!
I put this here as this thread points to a solution but neither seem correct.
http://forum.virtuemart.net/index.php?topic=95895.msg315057#msg315057
H I just upadted form VM 2.0.1a to 2.0.1b and am using J 1.7.3
The orders will not delete in this version for me. ( is this a bug will it be updated in some version?)
I see tha this forum is suggesting to try manually -
My error is VM ERROR
VM : VMMO:: remove 10 ( that my order number)
I cannot open the order and change anything other than the status - then save and try delete .
* nothing here will delete the order -
The name of the buyer and the payment method are missing (in the order) and these are the only one that will not delete.
Hi, on trying to delete orders I got this
QuotevmError:
vmError: VirtueMartModelOrders::remove 29
Order could not be deleted.
All orders are pending, but i can not erase them! Also all data get erased from order details but not the actual order header!!!
J! 2.5.6 VM 2.0.6
QuoteHi, on trying to delete orders I got this
Quote
vmError:
vmError: VirtueMartModelOrders::remove 29
Order could not be deleted.
All orders are pending, but i can not erase them! Also all data get erased from order details but not the actual order header!!!
J! 2.5.6 VM 2.0.6
Is there any news about this? I also get the exact same error message. Im Using Joomla 1.7 and VM 2.0.8e and im really helpless. Someone posted something about manually delete the orders in phpmyadmin, but this cannot be a solution for this... for me this is extremely important because i really need to delete all those test orders..
Thanks very much for a reply
I had this issue in 2.0.6 and 2.0.8 updated to 2.0.10 and all fixed.
and yes you have to delete some in phpmyadmin - to getback to square 1.