VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: luxuryvps on February 21, 2012, 09:52:45 AM

Title: Error and Warning when placing orders
Post by: luxuryvps on February 21, 2012, 09:52:45 AM
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): 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
Title: Re: Error and Warning when placing orders
Post by: luxuryvps on February 21, 2012, 13:07:18 PM
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' ?
Title: Re: Error and Warning when placing orders
Post by: luxuryvps on February 22, 2012, 09:26:35 AM
Any further help on this please?
Title: Re: Error and Warning when placing orders
Post by: luxuryvps on February 24, 2012, 10:34:58 AM
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
Title: Re: Error and Warning when placing orders
Post by: rollo on March 12, 2012, 20:54:08 PM
I am experiencing the same error!
Title: Re: Error and Warning when placing orders
Post by: jenkinhill on March 12, 2012, 23:31:49 PM
With VM2.0.3B ?
Title: Re: Error and Warning when placing orders
Post by: nebular on March 23, 2012, 09:35:09 AM
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....?