News:

Support the VirtueMart project and become a member

Main Menu

Error and Warning when placing orders

Started by luxuryvps, February 21, 2012, 09:52:45 AM

Previous topic - Next topic

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): 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
Liam Studham - Graphical Designer / Server Engineer
http://www.luxuryvps.com
VPS & Dedicated Servers - Discounts available for all VM Forum users (PM me)

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' ?
Liam Studham - Graphical Designer / Server Engineer
http://www.luxuryvps.com
VPS & Dedicated Servers - Discounts available for all VM Forum users (PM me)

luxuryvps

Liam Studham - Graphical Designer / Server Engineer
http://www.luxuryvps.com
VPS & Dedicated Servers - Discounts available for all VM Forum users (PM me)

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
Liam Studham - Graphical Designer / Server Engineer
http://www.luxuryvps.com
VPS & Dedicated Servers - Discounts available for all VM Forum users (PM me)

rollo


jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

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