Author Topic: [VM 2.0.7d] Order backend not working - another bug  (Read 2737 times)

eddydesigner

  • Beginner
  • *
  • Posts: 8
[VM 2.0.7d] Order backend not working - another bug
« on: May 31, 2012, 09:43:02 am »
As title...

in backend i can't diplay oders 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 v8urx_virtuemart_orders as o LEFT JOIN v8urx_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN v8urx_virtuemart_paymentmethods_it_it as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE o.virtuemart_vendor_id = "1" ORDER BY created_on DESC LIMIT 0, 10

HELP!

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9374
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: [VM 2.0.7d] Order backend not working - another bug
« Reply #1 on: May 31, 2012, 13:46:21 pm »
oha

looks like you deleted hte middle_name from the userinfos. Hmmm we did not consider that. The most performant way is to forbid to delete this fields.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

mux

  • Beginner
  • *
  • Posts: 8
Re: [VM 2.0.7d] Order backend not working - another bug
« Reply #2 on: November 13, 2012, 13:11:04 pm »
Hi

I am getting following 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 ,u.email as order_email,pm.payment_name AS payment_method FROM c32vt_virtuemart_orders as o LEFT JOIN c32vt_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN c32vt_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, 100

How to slove this?
Thanks in advance

gkrellm

  • Beginner
  • *
  • Posts: 4
Re: [VM 2.0.7d] Order backend not working - another bug
« Reply #3 on: December 09, 2012, 23:56:42 pm »
Same error after deleting almost all fields in Shopper Fields (unlocked for editing by changing .php file).

I restored table structure of
Code: [Select]
preffix_virtuemart_userinfos
preffix_virtuemart_userfields
preffix_virtuemart_userfield_values
preffix_virtuemart_order_userinfos

and now all work fine like before.