Author Topic: Fixed: Couldn't Create Order Error  (Read 1326 times)

BonaFide

  • Beginner
  • *
  • Posts: 35
Fixed: Couldn't Create Order Error
« on: December 31, 2013, 09:06:23 am »
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]
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

  • Beginner
  • *
  • Posts: 35
Re: Fixed: Couldn't Create Order Error
« Reply #1 on: December 31, 2013, 10:45:40 am »
Issue has been resolved:

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