News:

Support the VirtueMart project and become a member

Main Menu

issue with orders page

Started by jimpett81, January 03, 2017, 11:37:08 AM

Previous topic - Next topic

jimpett81

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






Jörgen

Hello

The customer_note is missing in userfields.

Add this userfield.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

jimpett81

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

Jörgen

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

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Milbo

Or update, the new version has a check (vm3.0.18.7)
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jimpett81

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