So, the debug information show us that the problem is not coming from HikaShop but from the system plugin "jvfixitemid".
Here the debug data (we removed some sensible content)
Code:
1 JApplicationCms->execute() - index.php:45
2 JApplicationSite->doExecute() - libraries/cms/application/cms.php:252
3 JApplicationSite->route() - libraries/cms/application/site.php:215
4 JApplicationCms->route() - libraries/cms/application/site.php:763
5 JApplicationBase->triggerEvent() - libraries/cms/application/cms.php:1098
6 JEventDispatcher->trigger() - libraries/joomla/application/base.php:106
7 JEvent->update() - libraries/joomla/event/dispatcher.php:160
8 call_user_func_array() - libraries/joomla/event/event.php:69
9 plgSystemJvfixitemid->onAfterRoute()
10 JDatabaseDriver->loadResult() - plugins/system/jvfixitemid/jvfixitemid.php:63
11 JDatabaseDriverMysqli->execute() - libraries/joomla/database/driver.php:1357
That debug indicates that the SQL error is generated in the plugin "jvfixitemid"
The 10th line is where the query is made and called.
I think that, because the state is populate dynamically by an AJAX call ; there is no itemId (it is not a SEF url) and that system plugin can't handle it properly.
Please see that directly with the support of jvfixitemid.
Regards,
