Error of order

[chs429]

Hi all,

There is an error appear at the top of the order page and don't know how to fix, please help. Thanks a lot.

"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 ,u.email as order_email,pm.payment_name AS payment_method FROM gpg6c_virtuemart_orders as o LEFT JOIN gpg6c_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN gpg6c_virtuemart_paymentmethods_zh_tw as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 20"

Best regards,

Joolma: 2.5.17
VM2: 2.0.26

[jenkinhill]

Sounds like you have deleted the middle name user field?  The fields should be unpublished and never deleted or you will get an error like you see.

Updating to the current 2.0.26d version may restore the field and fix the error.

[chs429]

Thanks, the problems is fixed now.