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
It seems to be broken, several users marked as the store owner, take a backup and do as the error message sais:
QuoteUse the setStoreOwner function in Tools and Migration
Jörgen @ Kreativ Fotografi
Quote from: Jörgen on October 13, 2019, 15:33:25 PM
It seems to be broken, several users marked as the store owner, take a backup and do as the error message sais:
QuoteUse 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!
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