I updated Joomla to the 3.9.23 and now it gives this error in Virtuemart: 1054 Unknown column 'Array' in 'where clause' when I try to enter the products. How do I solve it?
Att., Rita Gonçalves
Hi Rita,
Could you share the URL of page where I can see that error? I tried to visit some product pages on your site but there is no issue.
The problem only appears in the administrator. http://rcamisetas.com.br/gkstora/administrator/index.php?option=com_virtuemart&view=product
ritagoncalves Could you share the admin account of your site? the provided account seems not working now.
[Removed by Mods]
Hi ritagoncalves
I access this section in backend: http://rcamisetas.com.br/gkstora/administrator/index.php?option=com_virtuemart&view=product but I don't see any error message like that. Could you check again?
Hi, Please, in the product categories, choose a new one and then return to the product menu where the error occurs. I tried to register new categories and products, but the error does not allow.
It's weird as I tried to create a new category + a new product but when I come back to view product list with above link, it's working normally.
How do I solve it? Do I have to redo the entire store?
HI ritagoncalves Could you try with another browser? as I mentioned above, it still works fine at my end.
Hi saguaros In the administrator, filter by a category that you will see the error. It goes for all browsers. Attached error image.
There seems to be something wrong with Virtuemart on your site, this kind of error in backend doesn't relate to our site template, could you please try to contact Virtuemart for help?
Olá saguaros, This error only happens on this model and when it was updated to the current version of Joomla. The store was working perfectly. So I'll have to throw it away and redo it, because Virtuemart says it's a problem with the model.
ritagoncalves Let me know if you need any further help then.
Olá saguaros This GKStora model has an error. When you update the version of Joomla, the Virtuemart Store does not work. I redid everything and updated Joomla and there is the error again.
I just tried to create a new category: Test by JA and a new product for test but it worked properly in Virtuemart.
Could you check again?