I've been searching for my answer and felt here would be a good place to end my struggle. Thanks in advance.
VM 3.8.8 Joomla 3.9.23
Receiving this error when clicking confirm purchase. It's reports back a 500 error.
Error message data:
1 Unknown column 'order_note' in 'field list'
Query:
INSERT INTO `t23sa_virtuemart_orders`
(`virtuemart_order_id`,`virtuemart_user_id`,`virtuemart_vendor_id`,`order_note`,`order_number`,`order_pass`,`order_create_invoice_pass`,`invoice_locked`,`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`,`user_shoppergroups`,`payment_currency_id`,`payment_currency_rate`,`virtuemart_paymentmethod_id`,`virtuemart_shipmentmethod_id`,`ip_address`,`order_language`,`STsameAsBT`,`paid`,`paid_on`,`o_hash`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES
('0','1314','1','','866L028','p_RAAsebmU','dUHGG911','0','TEad02348','25','10','0','0','0','0','10','0','15','0','0','0','0','0','26','P','26','1','4','26','1','5','1','154.6.17.xx','en-GB','1','0','0','3fdf18e217389bb77dbd11b225dbbc44','2021-10-13 06:12:52','1314','2021-10-13 06:12:52','1314')
in file: /home/public_html/libraries/joomla/database/driver/mysqli.php line: 665
Check to see if you have the order_note Shopper Field existing in VM admin
No there is not. I tried to make one but unsure on the settings and it didn't work.
`order_note` varchar(5000) -- I wonder why it isn't already there?
is a standard field in VM3.8.8
CREATE TABLE IF NOT EXISTS `#__virtuemart_orders` (
`virtuemart_order_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT,
`virtuemart_user_id` int(1) UNSIGNED NOT NULL DEFAULT '0',
`virtuemart_vendor_id` int(1) UNSIGNED NOT NULL DEFAULT '0',
`order_note` varchar(5000),
etc
have u tried the VM tools -> Install or if necessary update tables