News:

Looking for documentation? Take a look on our wiki

Main Menu

Error Message

Started by lacyj, September 27, 2012, 10:46:08 AM

Previous topic - Next topic

lacyj


        vmError: TableOrders: :store failed
At checkout, I'm getting this error message.  Please advise.

       Unknown column 'order_salesPrice' in 'field list' SQL=INSERT INTO `ok8zq_virtuemart_orders` (`virtuemart_order_id`,`virtuemart_user_id`,`virtuemart_vendor_id`,`order_number`,`order_pass`,`order_total`,`order_salesPrice`,`order_billTaxAmount`,`order_billDiscountAmount`,`order_discountAmount`,`order_subtotal`,`order_tax`,`order_shipment`,`order_shipment_tax`,`order_payment`,`order_payment_tax`,`coupon_discount`,`order_discount`,`order_currency`,`order_status`,`user_currency_id`,`user_currency_rate`,`virtuemart_paymentmethod_id`,`virtuemart_shipmentmethod_id`,`customer_note`,`ip_address`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','42','1','8ad403','p_43a7d','12.95','12.95','0','0','0','12.95','0','0','0','0','0','0','0','144','P','144','1','2','1','','50.130.64.153','2012-09-27 08:40:31','42','2012-09-27 08:40:31','42')
        vmError: Couldn't create order
        No order created


bytelord

Hello,

Do you use any third-party payment plugins? if yes, can you disable them and test it again?

Also please try to go to Tools -> Tools and Migration and then click on Install tables or if necessary update them?

Regards
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!