I’m using Joomla! 3.9.5, Fabrik 3.9, php 7.2.16, MySQL 5.6.41-84.1-log and default Joomla template. Without github update, my website was working since last year without problems, when this week I updated by github I got problems with Ajax validation under certain circumstances: if I have notempy validation on a field element, when I write something in this element and I change focus, validation is endless (progress clock turns without stopping) and I cannot continue to fill the form, if I leave empty this field and I save the record, I get the error pasted below. This problem is present only if the Joomla! user in front-end is NOT Super User, if it is Administrator or someone else, the problem is present. Moreover the Ajax validation problem is present only for a group of elements (Usagers) and not for the other groups. Usagers is different from the others because of there are two databasejoin elements to id element in this group (I record personal data including the ids of parents if they were previously saved), but I have not validation for these databasejoin elements but in other field elements in the group; the group is not repeatable.
If I disable Ajax validation, I can save records if required elements are not empty, but if I press save with some required element with empty value, I get the same error.
Here the error:
1054 Unknown column 'Array' in 'where clause'
/web/htdocs/www.spacaci.it/home/libraries/joomla/database/driver/mysqli.php:665
Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
3 JDatabaseDriver->loadObjectList() JROOT/components/com_fabrik/models/list.php:2013
4 FabrikFEModelList->getRecordCounts() JROOT/components/com_fabrik/models/form.php:4451
5 FabrikFEModelForm->getRelatedTables() JROOT/components/com_fabrik/views/form/view.base.php:192
6 FabrikViewFormBase->display() JROOT/components/com_fabrik/views/form/view.html.php:37
7 FabrikViewForm->display() JROOT/components/com_fabrik/controllers/form.php:516
8 FabrikControllerForm->handleError() JROOT/components/com_fabrik/controllers/form.php:302
9 FabrikControllerForm->process() JROOT/libraries/src/MVC/Controller/BaseController.php:710
10 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fabrik/fabrik.php:181
11 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
12 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
13 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
14 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
15 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
16 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
If I disable Ajax validation, I can save records if required elements are not empty, but if I press save with some required element with empty value, I get the same error.
Here the error:
1054 Unknown column 'Array' in 'where clause'
/web/htdocs/www.spacaci.it/home/libraries/joomla/database/driver/mysqli.php:665
Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
3 JDatabaseDriver->loadObjectList() JROOT/components/com_fabrik/models/list.php:2013
4 FabrikFEModelList->getRecordCounts() JROOT/components/com_fabrik/models/form.php:4451
5 FabrikFEModelForm->getRelatedTables() JROOT/components/com_fabrik/views/form/view.base.php:192
6 FabrikViewFormBase->display() JROOT/components/com_fabrik/views/form/view.html.php:37
7 FabrikViewForm->display() JROOT/components/com_fabrik/controllers/form.php:516
8 FabrikControllerForm->handleError() JROOT/components/com_fabrik/controllers/form.php:302
9 FabrikControllerForm->process() JROOT/libraries/src/MVC/Controller/BaseController.php:710
10 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fabrik/fabrik.php:181
11 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
12 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
13 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
14 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
15 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
16 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49