Print Page - Error when finished buying

Title: Error when finished buying - what now?
Post by: rollo on March 13, 2012, 18:09:34 PM

I get an error when I finished buying a test-item from my shop:

vmError: VmTableData::store failed - Unknown column 'virtuemart_shipmentmethod_id' in 'field list' SQL=INSERT INTO `adv75_virtuemart_shipment_plg_weight_countries` (`id`,`virtuemart_order_id`,`order_number`,`virtuemart_shipmentmethod_id`,`shipment_name`,`order_weight`,`shipment_weight_unit`,`shipment_cost`,`shipment_package_fee`,`tax_id`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','16','55ab016','2','Standardversand','0','','','','','2012-03-13 17:02:36','42','2012-03-13 17:02:36','42')

What can I do ?

I use VM 2.0.2 an Joomla 1.7.1 stable release

Regards, Rollo

Title: Re: Error when finished buying - what now?
Post by: rollo on March 13, 2012, 19:22:57 PM

I added following fields to the database:
virtuemart_shipmentmethod_id
shipment_name
shipment_weight_unit
shipment_package_free
created_on
created_by
modified_on
modified_by

The error message is gone, I will try if it continues to work without errors...

Title: Re: Error when finished buying - what now?
Post by: swr_inc on March 21, 2012, 00:54:13 AM

Can you please let me know how do I change the database?
I'm sorry but I'm not used to programming...

Title: Re: Error when finished buying - what now?
Post by: Simon Reynolds on April 01, 2012, 19:24:27 PM

I have just upgraded to 2.0.3H. It seems to have cleared the problem.

Don't forget to upgrade and run Aio after

Just tested right through to Pay Pal sandbox with no problems

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: rollo on March 13, 2012, 18:09:34 PM