News:

Looking for documentation? Take a look on our wiki

Main Menu

Error: Menu List Orders

Started by sarmin, January 24, 2015, 15:14:19 PM

Previous topic - Next topic

sarmin

i have a menu with type "List order"
i buy some products and then go to this menu
have the error on the top of page
vmError: exeSortSearchListQuery Unknown column 'u.middle_name' in 'field list' SQL=SELECT o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,u.email as order_email,pm.payment_name AS payment_method FROM s3gsn_virtuemart_orders as o LEFT JOIN s3gsn_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN s3gsn_virtuemart_paymentmethods_ru_ru as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( u.virtuemart_user_id = 859 AND o.virtuemart_vendor_id = "1" ) ORDER BY virtuemart_order_id DESC
http://my.jetscreenshot.com/demo/20150124-m431-43kb.jpg

who can help to understand the problem? and maybe some issues?

bluezeyes

#1
Quote from: sarmin on January 24, 2015, 15:14:19 PM
i have a menu with type "List order"
i buy some products and then go to this menu
have the error on the top of page
vmError: exeSortSearchListQuery Unknown column 'u.middle_name' in 'field list' SQL=SELECT o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name , [...] FROM [...] s3gsn_virtuemart_order_userinfos as u [...]
who can help to understand the problem?

The cause of your problem is a missing column middle_name
in the table s3gsn_virtuemart_order_userinfos

Which version of VM, joomla, PHP  you use?

Regards,

Bluezeyes

sarmin

PHP Version 5.4.32
VirtueMart 2.6.10
Joomla! 2.5.24

GJC Web Design

perhaps update your VM to last 2.6.14 will fix it?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

sarmin

thnx. update is helping. i haven`t message about new version in admin panel.
thnx alot  :D