News:

Support the VirtueMart project and become a member

Main Menu

Order Edit Vmerror 2.5.5

Started by lindapowers, April 01, 2014, 06:54:55 AM

Previous topic - Next topic

lindapowers

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

Milbo

Great thank you. Found it, took 15 minutes. :-)
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

lindapowers

Quote from: Milbo on April 01, 2014, 11:16:15 AM
Great thank you. Found it, took 15 minutes. :-)

Excellent, thanks!