[SOLVED] Moved a site and not able to do orders any more.

[chetanmadaan]

Hi -

i moved a website from one cpanel server to another one and started having this strange issue.

Code Select Expand


vmdebug Problem in store TableOrders Unknown column 'order_billTax' in 'field list' SQL=INSERT INTO `j25_virtuemart_orders` (`virtuemart_order_id`,`virtuemart_user_id`,`virtuemart_vendor_id`,`order_number`,`order_pass`,`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`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','8497','1','6c3d01483','p_dacf0','10.95','10.95','0','0','0','0','10.95','0','0','0','0','0','0','0','144','P','144','1','1','2','','xxxxxxxx','2013-03-15 22:27:57','8497','2013-03-15 22:27:57','8497')

I checked the database and found out that column 'order_billTax' doesn't exist... does it has to be there?

Thanks

[chetanmadaan]

FYI!
"Install or if necessary update tables " in the tools and migration part and that seems to have added that column.

Thank you!