News:

Support the VirtueMart project and become a member

Main Menu

Deleting user fields created db error 3.0.17

Started by maxispin, December 07, 2016, 20:30:12 PM

Previous topic - Next topic

maxispin

Deleting user fields created db error 3.0.17.

DB updater didn't help.

An error has occurred.
1054 Unknown column 'u.phone_1' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.company,u.first_name,u.last_name) AS order_name ,u.email as order_email, pm.payment_name AS payment_method, u.company AS company, u.city AS city, u.zip AS zip, u.phone_1 AS phone, st.address_type AS st_type, st.company AS st_company, st.city AS st_city, st.zip AS st_zip, u.customer_note AS customer_note FROM #__virtuemart_orders as o LEFT JOIN #__virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN #__virtuemart_order_userinfos as st ON st.virtuemart_order_id = o.virtuemart_order_id AND st.address_type="ST" LEFT JOIN #__virtuemart_paymentmethods_fi_fi as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id ORDER BY created_on DESC LIMIT 0, 30
Return to Control Panel
VM 3.0.17.6 | VM 2.0.24c | VM 1.1.9

maxispin

Adding back

phone_1   Phone   text
COM_VIRTUEMART_SHOPPER_FORM_PHONE

solved error (as it should have).


Behavior was not expected.
VM 3.0.17.6 | VM 2.0.24c | VM 1.1.9