Hi,
Thanks, the call stack helps a lot.
The error comes from an indexing issue with a MySQL query in the smart search component of joomla.
So I'm not sure why it's failing.
The problem happens because you have the "force canonical URLs on listings" set to "generate if missing". And a product is being displayed without a canonical URL already configured. Because of that, the system has to update the canonical URL and that triggers a product data save, which triggers a reindexing.
So, checking the call stack and the code involved before it goes to Joomla, I see several ways you can circumvent the problem:
- you could set the "force canonical URLs on listings" to "use if specified"
- you could make sure you have a canonical URL set for all the products products and that their URL is valid (that will be hard)
- you could change the finder - hikashop plugin's "access level" setting in the Joomla plugins manager so that it is only triggered on the backend, not on the frontend (not unless you're a super user)
- you could try to clear the smart search index and reindex it from the backend. Maybe that will clear the duplicate index issue ?