Hi,
I am not certain that this is the correct area to post this but I can't see where database issues would go and the error has occurred since updating.
The issue I have is that I can no longer see my orders page in the backend. The orders are still coming in and they are in the database okay but you can't view them. I have had similar errors after updating and always been able to figure out how to correct them in the tables, but this one has me stumped. The error is below:
Unknown column 'u.customer_note' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.company,u.first_name,u.middle_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_en_gb as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id ORDER BY created_on DESC LIMIT 0, 50
VirtueMart 3.0.17.6 and Joomla! 3.6.4
Thanks for any help you can offer.
Regards,
James
Hello
The customer_note is missing in userfields.
Add this userfield.
regards
Jörgen @ Kreativ Fotografi
Hi,
Thanks for the quick reply. Would this be a case of adding the field to the _virtuemart_orders table?
Sorry for my ignorance.
Regards,
James
No
You have to add a new userfield called customer_note.
Go To userfields in the backend and You will see.
This is the note that the customer uses to make notes to an order.
regards
Jörgen @ Kreativ Fotografi
Or update, the new version has a check (vm3.0.18.7)
Hi,
Thanks for the help. I have added a customer_note field and it works now. I will also update to the newest version soon also.
Regards,
James