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
have u tried VM admin-> tools-> Install or if necessary update tables ?
only try that one.. the rest change data!
hey thanks for the reply but already tried this. :(
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 ;
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?
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
it defintely isnt here. so i create a new table? this could be fun :P
no! add the missing column... just run the query.. it will add
ok! haha sorry for being such a newbie :)
well now the error isnt coming up when i click show cart but it is when i click confirm order >:(
I COULD VIRTUALLY HUG YOU RIGHT NOW
thanks so much! total legend :D
ps. i made a spelling error XD
:-[
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
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
:(
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
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/
I would wonder, why your updater is not updating the tables correctly for you. I would enable vmdebug and use the tools. BEWARE you must enable the use of the tools in the vmconfig and when you used it one time the right todo so is RESET, you must enable it again. This is a security feature!