vmError: updateSingleItem and UPDATE `#__virtuemart_orders` SET `order_total`=(SELECT sum(product_final_price*product_quantity) FROM #__virtuemart_order_items where `virtuemart_order_id`=4333)+`order_shipment`+`order_shipment_tax`+`order_payment`+`order_payment_tax`+0, `order_discountAmount`=(SELECT sum(product_subtotal_discount) FROM #__virtuemart_order_items where `virtuemart_order_id`=4333), `order_billDiscountAmount`=`order_discountAmount`+0, `order_salesPrice`=(SELECT sum(product_final_price*product_quantity) FROM #__virtuemart_order_items where `virtuemart_order_id`=4333), `order_tax`=(SELECT sum( product_tax*product_quantity) FROM #__virtuemart_order_items where `virtuemart_order_id`=4333), `order_subtotal`=(SELECT sum(ROUND(product_item_price, )*product_quantity) FROM #__virtuemart_order_items where `virtuemart_order_id`=4333),`order_billTaxAmount`=(SELECT sum( product_tax*product_quantity) FROM #__virtuemart_order_items where `virtuemart_order_id`=4333)+`order_shipment_tax`+`order_payment_tax`+0 WHERE `virtuemart_order_id`=4333
---------------------------
Got that message when adding a new item to an order and saving it, the item was succesfully added aswell as the order correctly saved though.
Maybe cause i set base price 0 for that item?
Regards
Great thank you. Found it, took 15 minutes. :-)
Quote from: Milbo on April 01, 2014, 11:16:15 AM
Great thank you. Found it, took 15 minutes. :-)
Excellent, thanks!