Fixed: Couldn't Create Order Error

[BonaFide]

I recently updated VM to the latest version 2.0.26a running on Joomla 2.5.17

Can no longer checkout when placing an order as it gives the below error:

Couldn't place order

No order created

Have also attached screenshot. No changes were made to configuration at all during update process. Why is it throwing out this error now?

Below is the error log from the com_virtuemart.log file:

Code Select Expand

2013-12-31 08:23:50 ERROR vmError: TableOrders: :store failed<br />Unknown column 'customer_number' in 'field list' SQL=INSERT INTO `jos_virtuemart_orders` (`virtuemart_order_id`,`virtuemart_user_id`,`virtuemart_vendor_id`,`order_number`,`order_pass`,`customer_number`,`order_total`,`order_salesPrice`,`order_billTaxAmount`,`order_billTax`,`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`,`order_language`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','96','1','26e8016','p_1e1bf','RV766ee0f21','858','858','0','0','0','0','858','0','0','0','0','0','0','0','153','P','153','1','3','1','','127.0.0.1','en-GB','2013-12-31 08:23:50','96','2013-12-31 08:23:50','96')
2013-12-31 08:23:50 ERROR vmError: Couldn't create order



[attachment cleanup by admin]

[BonaFide]

Issue has been resolved:

VM admin tools -> Install or if nesscesary update tables? sorted it out.