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

Started by dgmsteel, October 13, 2019, 15:22:37 PM

Previous topic - Next topic

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:
QuoteUse the setStoreOwner function in Tools and Migration

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

dgmsteel

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!


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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation