Hello,
I'm having issues checking out on my website. When I enter in all of the information and select 'Confirm Purchase' on the checkout page it doesn't go through to Paypal. Instead it reloads the checkout page and gives me the following error at the top:
QuotevmError: TableOrders: :store failed
Unknown column 'customer_number' in 'field list' SQL=INSERT INTO `unrl1_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','401','1','908803','p_7ef48','21232f297a57a5a743894a0e4a801fc3','25.98','19.99','3.46933884','{\"1\":{\"virtuemart_calc_id\":1,\"calc_name\":\"Tax 21%\",\"calc_value\":\"21.0000\",\"result\":3.46933884}}','-13.8779','-13.8779','30.39856116','3.46933884','5.99','0','0','0','0','-13.8779','144','P','144','1','2','3','','76.113.224.217','en-GB','2013-11-09 20:40:00','401','2013-11-09 20:40:00','401')
vmError: Couldn't create order
No order created
If anyone can give me some insight on this it would be very much appreciated!!
more info would help - what version, have you recently updated, migrated?
Have you tried in VM admin tools -> Install or if nesscesary update tables?