Print Page - Error when viewing Orders in backend

Title: Error when viewing Orders in backend
Post by: stuart.prevos on May 21, 2012, 14:38:17 PM

Hi
VM 2.0.6
J 2.6
Upgraded from 2.0.4, now when I go to view orders in backend I get this error
vmError: exeSortSearchListQuery Unknown column 'u.middle_name' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,pm.payment_name AS payment_method FROM nia8w_virtuemart_orders as o LEFT JOIN nia8w_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN nia8w_virtuemart_paymentmethods_en_gb as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE o.virtuemart_vendor_id = "1" ORDER BY created_on DESC LIMIT 0, 15

Any suggestion would be welcome

Title: Re: Error when viewing Orders in backend
Post by: mux on November 13, 2012, 13:56:03 PM

Hi

I am having the same problem
But no help i get yet

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Templating & Layouts => Topic started by: stuart.prevos on May 21, 2012, 14:38:17 PM