Error message really need help please

[arnibean]

Hey guys

so im running virtuemart 3.0.12 and joomla 3.4.5
and im using ajax mini cart pro for my cart plugin

after updating i get the following error when i click "show cart" OR "confirm purchase":

1054 - Unknown column 'order_create_invoice_pass' in 'field list' SQL=INSERT INTO `i1mq9_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`,`coupon_code`,`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','390','1','VCZ907','p_PvYZYFv1','hxZq0qk1','ADcdb38e2f6','2','2','0','0','0','0','2','0','2.5','0','0','0','-2.5','001002','0','52','P','52','1','1','1','151.231.224.xx','en-GB','2015-11-13 19:54:17','390','2015-11-13 19:54:17','390')

Any help please?
im really stuck

[GJC Web Design]

have u tried VM admin-> tools-> Install or if necessary update tables ?

only try that one.. the rest change data!

[arnibean]

hey thanks for the reply but already tried this. 

[GJC Web Design]

hmm -- on a fresh install the column is there..  try creating it manually in phpmyadmin

ALTER TABLE `#__virtuemart_orders` ADD `order_create_invoice_pass` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;

[arnibean]

thank you i managed to get into phpmyadmin
but i have no idea where to look next :/
sorry to be a pain could you help?

[GJC Web Design]

hmm .. u can do a ton of damage in there if you don't know what your doing!

u need to check if the column exists .. if not add it with the query I gave.. change the table prefix to match yours

back up your site and DB first

[arnibean]

it defintely isnt here. so i create a new table? this could be fun

[GJC Web Design]

no! add the missing column... just run the query.. it will add

[arnibean]

ok! haha sorry for being such a newbie

[arnibean]

well now the error isnt coming up when i click show cart but it is when i click confirm order 

[arnibean]

I COULD VIRTUALLY HUG YOU RIGHT NOW
thanks so much! total legend

ps. i made a spelling error XD

[GJC Web Design]

 

but would be interesting to know why the table didn't update on the "update"...  hmmm

what did u update from?

order_create_invoice_pass is new from 3.0.10 I think

[arnibean]

from 3.0.1
im now faced with a new error.
comes up with thank you for your order (order hasnt gone through)

comes up with

restricted
Access!com_vituemart_cart_order_notfound

[mattia14]

Hallo everybody, sorry but I have the same problem... can somebody pleas tell me how to go to the vm admin?

thank you a lot

[jenkinhill]

I think you mean phpMyAdmin.  Usually accessed through your server cPanel, but be sure to make a backup of your site and of the database before trying to make an edit.

This may help:  https://www.siteground.co.uk/tutorials/phpmyadmin/