Edit Shop problem

[Midhat]

Hi,
When I try to open a link Shop in backend I get the following error:

Code Select Expand

An error has occurred.
1054 Unknown column 'u.company' in 'field list' SQL=SELECT o.*, CONCAT_WS(' ',u.first_name,u.last_name) AS order_name ,u.email as order_email, pm.payment_name AS payment_method, u.company AS company, u.city AS city, u.zip AS zip, u.phone_1 AS phone, st.address_type AS st_type, st.company AS st_company, st.city AS st_city, st.zip AS st_zip, u.customer_note AS customer_note FROM #__virtuemart_orders as o LEFT JOIN #__virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN #__virtuemart_order_userinfos as st ON st.virtuemart_order_id = o.virtuemart_order_id AND st.address_type="ST" LEFT JOIN #__virtuemart_paymentmethods_en_gb as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( u.virtuemart_user_id = 42 AND u.virtuemart_user_id = 42 ) order by o.modified_on DESC
Return to Control Panel

I also have this Warning:
You are using single vendor mode, but it seems more than one user is set as vendor

Joomla 3.5.1
Virtuemart 3.0.16
Custom template: No
OS Linux o
PHP 5.4.45
MySQLi 10.0.20-MariaDB-cll-lve
Caching Disabled
GZip Disabled
http://stefijano.com/

[GJC Web Design]

just started happening?
upgrade?
migration?
what have u changed?
tried the table updater in tools?

[Midhat]

I just filled out the fields in one of the shop tabs and after save I got this error.

Are you referring to this: "Install or if necessary update tables"
Will I lose my data I entered?

Thanks,
Midhat

[GJC Web Design]

this is a new install?

did u delete the company shopper field? Where are u accessing orders from then?

Are you referring to this: "Install or if necessary update tables"
Will I lose my data I entered?

this will have no effect on a new install  -- no data is lost

[Rasputina]

i'm having the same problem here, could u solve it? needing help

[Studio 42]

i'm having the same problem here, could u solve it? needing help

Go to the userfields and check if company field exist else add it.
This is the direct link to userfields  YOURSITE/administrator/index.php?option=com_virtuemart&view=userfields

[stawebnice]

I saw this in some templates by templatemonster.

You need to go to database via PhpMyAdmin, and in table virtuemart_vmusers see in the column "user_is_vendor", how many users have 1: http://imtp.me/c6s402lj3 
then change 1 to 0 for user that is not vendor.

The ID will fit with the user in table _virtuemart_userinfos so you can see which seller you want to pick as vendor....

this will fix the problem with more vendors

[Studio 42]

The problem is

1054 Unknown column 'u.company' in 'field list'

SO i think that my answer is right.

[Milbo]

I saw this in some templates by templatemonster.

You need to go to database via PhpMyAdmin, and in table virtuemart_vmusers see in the column "user_is_vendor", how many users have 1: http://imtp.me/c6s402lj3 
then change 1 to 0 for user that is not vendor.

The ID will fit with the user in table _virtuemart_userinfos so you can see which seller you want to pick as vendor....

this will fix the problem with more vendors

This is another problem and can most time solved automatically (in single vendor shops) by using the command for it in "update/migration", second tab. Use there "set store owner", you just need to find out the id of the shopowner (see user list).

The answer of Patrick is correct. They deleted the company from the userfields, so also from the "userinfo" and "order_userinfo". I think I should forbidd deletion of them. Maybe they should be just trashed. On the other hand, vm3.0.18.x has this fix.