Author Topic: error in backend orders page  (Read 1644 times)

stuart.prevos

  • Beginner
  • *
  • Posts: 36
error in backend orders page
« on: May 22, 2012, 12:19:11 pm »

Hi
VM 2.0.6
J 2.6
Upgraded from 2.0.4, now when I go to view orders in backend I get this error
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 ,pm.payment_name AS payment_method FROM nia8w_virtuemart_orders as o LEFT JOIN nia8w_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN nia8w_virtuemart_paymentmethods_en_gb as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE o.virtuemart_vendor_id = "1" ORDER BY created_on DESC LIMIT 0, 15

Any suggestion would be welcome

stuart.prevos

  • Beginner
  • *
  • Posts: 36
Re: error in backend orders page
« Reply #1 on: May 23, 2012, 13:13:25 pm »
well it seems there may be some validation bugs in VM 2.0.6. I deleted the user middle name field and that is what caused it to stop working, I just had to recreate the middle name field in config.