VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: kallbron on December 11, 2015, 15:24:45 PM

Title: Problem error 1054
Post by: kallbron on December 11, 2015, 15:24:45 PM
Hi it is the first time i use virtuemart. i have a problem. when i push button order confirmation, displays error 1054 UNKNOWN COLUMN 'ORDER_CREATE_INVOICE_PASS' IN 'FIELD LIST' SQL=INSERT INTO `OGIRC_VIRTUEMART_ORDERS` (`VIRTUEMART_ORDER_ID`,`VIRTUEMART_USER_ID`,`VIRTUEMART_VENDOR_ID`,`ORDER_NUMBER`,`ORDER_PASS`,`ORDER_CREATE_INVOICE_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`,`IP_ADDRESS`,`ORDER_LANGUAGE`,`CREATED_ON`,`CREATED_BY`,`MODIFIED_ON`,`MODIFIED_BY`) VALUES ('0','607','1','6NWY03','P_WFGW1TEF','DRBSZQD7','PO63D4D0B7E','33.9','33.9','0','0','0','0','33.9','0','0','0','0','0','0','0','47','P','47','1','1','1','62.38.248.XX','EL-GR','2015-12-11 14:07:21','607','2015-12-11 14:07:21','607')

please help me to resolve it!! thank you in advance!!!!
Title: Re: Problem error 1054
Post by: GJC Web Design on December 11, 2015, 15:55:52 PM
rebuild tables in VM database tools?

Install or if necessary update tables?
Title: Re: Problem error 1054
Post by: kallbron on December 11, 2015, 15:57:55 PM
First of all thanks for your response.

how i can do this?
Title: Re: Problem error 1054
Post by: GJC Web Design on December 11, 2015, 16:00:45 PM
Come on ... learn and discover your new software.. click things.. read the manual, read the tooltips,    http://docs.virtuemart.net/manual