News:

Looking for documentation? Take a look on our wiki

Main Menu

1054 error received when clicking on shop or orders

Started by dancingkazzaf, June 24, 2015, 17:15:38 PM

Previous topic - Next topic

dancingkazzaf

Hi,
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.company,u.first_name,u.middle_name,u.last_name) AS order_name ,u.email 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?

Thanks.