Print Page - Error of order

Title: Error of order
Post by: chs429 on March 19, 2014, 10:47:50 AM

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

Title: Re: Error of order
Post by: jenkinhill on March 19, 2014, 11:06:35 AM

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.

Title: Re: Error of order
Post by: chs429 on March 20, 2014, 05:22:56 AM

Thanks, the problems is fixed now.

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: chs429 on March 19, 2014, 10:47:50 AM