Can't save changes to "SHOP" after 3.6.2 update Getting "Serious Error" message.

[dgmsteel]

Joomla 3.9.12
Virtuemart 3.6.2

After updating to Virtuemart version 3.6.2 I get a "Serious problem with your store" message if I attempt to make any changes to Shop. Any Ideas it's quite worrying.


Error
vmError: There is a serious problem with your store, there are entries with the same virtuemart_vendor_id 1 enable the vmdebug or check your virtuemart log files and fix it immediatly. Use the setStoreOwner function in Tools and Migration
vmError: storing user data
vmError: Was not able to save the VirtueMart user data

[Jörgen]

It seems to be broken, several users marked as the store owner, take a backup and do as the error message sais:

Use the setStoreOwner function in Tools and Migration

Jörgen @ Kreativ Fotografi

[dgmsteel]

It seems to be broken, several users marked as the store owner, take a backup and do as the error message sais:

Use the setStoreOwner function in Tools and Migration

Jörgen @ Kreativ Fotografi

Hi I tried that using the ID of the existing Vendor and the ID of another Super user and I get this error:

An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `virtuemart_vendor_id` = "1"' at line 1

I also looked in phpmyadmin and `virtuemart_vendor_id` = "1"'


Weirdly if I change the Vendor ID in phpmyadmin, the error goes away but then I can't define a currency!

[GJC Web Design]

the answers are the same as above .. check your vendor setup directly in the vm user tables. There should be only one marked as vendor if u have a single vendor store ...
Try setting the vendor directly in the tools menu to who it should be