Ajax validation not working after github update

[pietrocir]

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

 

[cheesegrits]

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)

So are they joining to their own table?

And if you temporarily unpublish those two joins, does the error go away?

-- hugh

 

[pietrocir]

Joomla users in front-end that are not Super Users fill the form Usagers with personal data of other people who are not Joomla users, sometimes they previously filled personal data of their parents, who also are not Joomla users.
If I unpublish the two databasejoin elements, the issue is still present. Anyway, the issue is only for this group of elements of the table Usagers, for other tables the issue is absent, so I still need to know why only for Usagers.
If I assign to such Joomla users also the Super User group, the issue is absent for them.

 

[pietrocir]

I found the element causing the problem: date_time (date and time of creation of the record); add privilege was for Super Users only, I changed to the user group who is filling the form; modify privilege is remained for Super Users only and in this configuration the issue is gone away.
It is odd because for other tables date_time add privilege is for Super Users only and I have no problems.
Indeed, date_time element was modified a lot in GitHub since Fabrik 3.9 (I had to add pick up for time, otherwise it was saving date without time), is there something new and critical in date_time for my circumstances?

 

[pietrocir]

I changed modify privilege of date_time element in order to let user group different from Super User to modify, otherwise such users could create but not modify when using Ajax validation.