error after deleting almost all fields in Shopper Fields :
" vmError: exeSortSearchListQuery Unknown column 'u.first_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 el5sc_virtuemart_orders as o LEFT JOIN el5sc_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN el5sc_virtuemart_paymentmethods_vi_vn as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 30 "
How do I fix them.
And I have another question I am using VM 2.0.10 I have to upgrade to the new version no. and when upgrading data be lost?
sorry for my english
You should not delete the fields. Just unpublish them. This should be fixed by a reinstall of VM2.0.10 - but then you must update as that old version has critical security issues. Installation/updating using Joomla's extensions manager does not remove product/user data etc. but you must update both the main VM component and the aio component. Test the update on a backup copy of the site first.