News:

Support the VirtueMart project and become a member

Main Menu

Error when finished buying - what now?

Started by rollo, March 13, 2012, 18:09:34 PM

Previous topic - Next topic

rollo

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



rollo

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...

swr_inc

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

Simon Reynolds

#3
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