Author Topic: 1054 error received when clicking on shop or orders  (Read 896 times)


  • Beginner
  • *
  • Posts: 18
1054 error received when clicking on shop or orders
« on: June 24, 2015, 17:15:38 PM »
I am using VM 3.0.9, Joomla 3.4.1
After just getting VM more or less set up how I want it, I am suddenly now getting errors when I try to click on Shop or Orders or on a product.
This is an example:

 1054 Unknown column 'o.virtuemart_order_id' in 'on clause' SQL=SELECT o.*, CONCAT_WS(' ',,u.first_name,u.middle_name,u.last_name) AS order_name , as order_email,pm.payment_name AS payment_method FROM z8jh6_virtuemart_orders as o LEFT JOIN z8jh6_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN z8jh6_virtuemart_paymentmethods_en_gb as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( u.virtuemart_user_id = 515 AND u.virtuemart_user_id = 515 ) order by o.modified_on DESC

I am not a database expert, can anyone tell me how to fix it? We have got a few extensions enabled, Invoice Manager and CSVI Pro are enabled. It was working fine and nobody has done anything which might have caused the errors as far as I know.

Any ideas anyone?