VM 3.8.8 500 error when clicking confirm purchase

[glitchydreams]

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

[AH]

Check to see if you have the order_note Shopper Field existing in  VM admin

[glitchydreams]

No there is not.  I tried to make one but unsure on the settings and it didn't work.

[GJC Web Design]

`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