News:

Support the VirtueMart project and become a member

Main Menu

error in backend orders page

Started by stuart.prevos, May 22, 2012, 12:19:11 PM

Previous topic - Next topic

stuart.prevos


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

stuart.prevos

well it seems there may be some validation bugs in VM 2.0.6. I deleted the user middle name field and that is what caused it to stop working, I just had to recreate the middle name field in config.