Error and Warning when placing orders

[luxuryvps]

Hi all,

- Virtuemart 2.0.1H - Was about to upgrade to N when I noticed the error. Have checked the release notes between 'H' and 'N' and their doesnt seem to be any notes of this being fixed.
- Joomla! 2.5.1 Stable [ Ember ]

Error(replaced DB prefix with xxxxx):

Code Select Expand

Error

        vmError: VmTableData::store failed - Unknown column 'virtuemart_shipmentmethod_id' in 'field list' SQL=INSERT INTO `xxxxx_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','3','bf6332d9','0','Delivery MethodsAll orders can be collected for free. Makeport can also Deliver, and if requested, install the items for you. Your quote will contain a price for Delivery and one for Installation as a reference should you wish to use the services.','16','KG','0','0','0','2012-02-21 08:42:02','42','2012-02-21 08:42:02','42')

Warning

        Info: SELECT * FROM `#__virtuemart_shipment_plg_weight_countries` WHERE `virtuemart_order_id` = 3 getOrderMethodNamebyOrderId

Thank you for your order!
Payment method Quote RequestQuotes will be E-Mailed directly to our staff. Quotes will be processed in the order they are received. We aim to get a quote back to you the same day, as long as it is submitted within UK office hours.
VMPAYMENT_STANDARD_PAYMENT_INFO_TEXT
Order Number bf6332d9
Amount £0.00

A user will add products to cart, place the order and agree to the terms, then confirm the order. This happens upon Confirming the order. The order is placed fine, saved in the database fine, and can be looked at, edited and approved from the Admin Backend. Also the emails are sent fine without any problems. The only problem is that the error is plastered over the screen!

Please note, the code snippet is copied from an admin account placing the order. A non-admin account only gets the 'Warning' section of the code snippet.

Thanks for any help in advanced guys,
Liam

[luxuryvps]

Still having a little play around and cant seem to find any way of sorting this out. I will update from H when the next beta version is released(today hopefully?). Is this something that has been reported/fixed since 'H' ?

[luxuryvps]

Any further help on this please?

[luxuryvps]

Still had no reply in 3 days, could really do with some assitance with this. Im currently using MySQL 5.1(latest build) so im assuming there should be no problems with this?

Liam

[rollo]

I am experiencing the same error!

[jenkinhill]

With VM2.0.3B ?

[nebular]

Here I have the same problem.

I have installed Joomla 1.7.5 and virtuemart 2.0.2 STABLE¡¡¡¡¡¡¡ I updated from 2.0.0 Stable and this worked fine.

STABLE = Less problems or more problems....?