Error en virtuemart 2.0 vmError: exeSortSearchListQuery
hola como puedo arreglar esta error me aparece en las pestañas de pedidos y no se me reflejan los pedidos realizados por los clientes
- 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 ,u.email as order_email,pm.payment_name AS payment_method FROM w47fa_virtuemart_orders as o LEFT JOIN w47fa_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN w47fa_virtuemart_paymentmethods_es_es as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 20
- Aquí os envió una captura de pantalla para que os hagáis una idea