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?
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
PHP Version 5.4.32
VirtueMart 2.6.10
Joomla! 2.5.24
perhaps update your VM to last 2.6.14 will fix it?
thnx. update is helping. i haven`t message about new version in admin panel.
thnx alot :D