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:
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]
Issue has been resolved:
VM admin tools -> Install or if nesscesary update tables? sorted it out.