SQL error on databasejoin filter, after update

[vladimir84]

After updating the Ubuntu and apache and mysql and php, I get an error when I select any value in the filter for a filed that is
1. databasejoin
2. rendered as checkboxes
3. filter as dropdown

the values are all in the dropdown, but any value I select, I get the following error:

getData:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) LIMIT 0, 10' at line 43 SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `arhivamaster`.`PDF` AS `arhivamaster___PDF`, `arhivamaster`.`PDF` AS `arhivamaster___PDF_raw`, `arhivamaster`.`OB` AS `arhivamaster___OB_raw`, `osnovnibroj`.`ob` AS `arhivamaster___OB`, `arhivamaster`.`pbr1` AS `arhivamaster___pbr1`, `arhivamaster`.`pbr1` AS `arhivamaster___pbr1_raw`, `arhivamaster`.`pbr2` AS `arhivamaster___pbr2_raw`, `pb2`.`broj` AS `arhivamaster___pbr2`, `arhivamaster`.`pbr3` AS `arhivamaster___pbr3`, `arhivamaster`.`pbr3` AS `arhivamaster___pbr3_raw`, `arhivamaster`.`pbr3` AS `arhivamaster___pbr3_raw`, `pb3`.`broj` AS `arhivamaster___pbr3`, `arhivamaster`.`pbr3` AS `arhivamaster___pbr3_raw`, `pb3`.`broj` AS `arhivamaster___pbr3`, `arhivamaster`.`datum_unos` AS `arhivamaster___datum_unos`, `arhivamaster`.`datum_unos` AS `arhivamaster___datum_unos_raw`, `arhivamaster`.`tipdok` AS `arhivamaster___tipdok_raw`, `tipdokumenta`.`tip_dok` AS `arhivamaster___tipdok`, `arhivamaster`.`izvodjac` AS `arhivamaster___izvodjac_raw`, `izvodjaci`.`izvodjac` AS `arhivamaster___izvodjac`, (SELECT GROUP_CONCAT(objekti.objekat SEPARATOR '//..*..//') FROM arhivamaster_repeat_objekat LEFT JOIN objekti ON objekti.id = arhivamaster_repeat_objekat.objekat WHERE arhivamaster_repeat_objekat.parent_id = `arhivamaster`.`id`) AS arhivamaster_repeat_objekat___objekat, (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM arhivamaster_repeat_objekat WHERE parent_id = `arhivamaster`.`id`) AS `arhivamaster_repeat_objekat___objekat_raw`, (SELECT GROUP_CONCAT(objekat SEPARATOR '//..*..//') FROM arhivamaster_repeat_objekat WHERE arhivamaster_repeat_objekat.parent_id = `arhivamaster`.`id`) AS arhivamaster_repeat_objekat___objekat_id, (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM arhivamaster_repeat_objekat WHERE parent_id = `arhivamaster`.`id`) AS `arhivamaster_repeat_objekat___params`, `arhivamaster`.`opis_srb` AS `arhivamaster___opis_srb`, `arhivamaster`.`opis_srb` AS `arhivamaster___opis_srb_raw`, `arhivamaster`.`opis_it` AS `arhivamaster___opis_it`, `arhivamaster`.`opis_it` AS `arhivamaster___opis_it_raw`, `arhivamaster`.`datum_dok` AS `arhivamaster___datum_dok`, `arhivamaster`.`datum_dok` AS `arhivamaster___datum_dok_raw`, `arhivamaster`.`brojdok` AS `arhivamaster___brojdok`, `arhivamaster`.`brojdok` AS `arhivamaster___brojdok_raw`, `arhivamaster`.`duplikat` AS `arhivamaster___duplikat`, `arhivamaster`.`duplikat` AS `arhivamaster___duplikat_raw`, `arhivamaster`.`id` AS slug , `arhivamaster`.`id` AS `__pk_val` FROM `arhivamaster` LEFT JOIN `osnovnibroj` AS `osnovnibroj` ON `osnovnibroj`.`id` = `arhivamaster`.`OB` LEFT JOIN `tipdokumenta` AS `tipdokumenta` ON `tipdokumenta`.`id` = `arhivamaster`.`tipdok` LEFT JOIN `izvodjaci` AS `izvodjaci` ON `izvodjaci`.`id` = `arhivamaster`.`izvodjac` LEFT JOIN `pb2` AS `pb2` ON `pb2`.`id` = `arhivamaster`.`pbr2` LEFT JOIN `pb3` AS `pb3` ON `pb3`.`id` = `arhivamaster`.`pbr3` WHERE ( arhivamaster.OB <> 81 AND arhivamaster.OB <> 80 AND arhivamaster.OB <> 78 AND arhivamaster.OB <> 104 AND arhivamaster.OB <> 81 AND ( arhivamaster.OB <> 107 OR arhivamaster.OB = 81 AND (arhivamaster.pbr1 = 'OS' OR arhivamaster.pbr1 LIKE '[\"OS\"%' OR arhivamaster.pbr1 LIKE '%\"OS\"%' OR arhivamaster.pbr1 LIKE '%\"OS\"]')) OR ( arhivamaster.OB = 78 AND (arhivamaster.pbr1 = 'LOC' OR arhivamaster.pbr1 LIKE '[\"LOC\"%' OR arhivamaster.pbr1 LIKE '%\"LOC\"%' OR arhivamaster.pbr1 LIKE '%\"LOC\"]')) ) AND ( `arhivamaster`.`id` IN () ) LIMIT 0, 10

I tried using the latest verison from github https://github.com/Fabrik/fabrik/tree/joomla25:
with the latest commit: 0cd1e0aa82e3da0117a3c2bcad97db646118be56

This is the MySQL version:

Spoiler

mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (i686) using readline 6.3

Connection id: 338
Current database:
Current user: vladimir@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 1 hour 8 min 24 sec

Threads: 1 Questions: 9535 Slow queries: 0 Opens: 743 Flush tables: 1 Open tables: 201 Queries per second avg: 2.323

PHP:

Spoiler

PHP Version 5.5.9-1ubuntu4.4


System Linux athena-virtualbox 3.13.0-36-generic #63-Ubuntu SMP Wed Sep 3 21:30:45 UTC 2014 i686
Build Date Sep 4 2014 06:53:45
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php5/apache2
Loaded Configuration File /etc/php5/apache2/php.ini
Scan this dir for additional .ini files /etc/php5/apache2/conf.d
Additional .ini files parsed /etc/php5/apache2/conf.d/05-opcache.ini, /etc/php5/apache2/conf.d/10-pdo.ini, /etc/php5/apache2/conf.d/20-curl.ini, /etc/php5/apache2/conf.d/20-gd.ini, /etc/php5/apache2/conf.d/20-json.ini, /etc/php5/apache2/conf.d/20-mysql.ini, /etc/php5/apache2/conf.d/20-mysqli.ini, /etc/php5/apache2/conf.d/20-pdo_mysql.ini, /etc/php5/apache2/conf.d/20-readline.ini
PHP API 20121113
PHP Extension 20121212
Zend Extension 220121212
Zend Extension Build API220121212,NTS
PHP Extension Build API20121212,NTS
Debug Build no
Thread Safety disabled
Zend Signal Handling disabled
Zend Memory Manager enabled
Zend Multibyte Support provided by mbstring
IPv6 Support enabled
DTrace Support enabled
Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, tls
Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk

I tried recreating table, recreating the element, the values are there, the list shows all the data, but I can't filter out any value.

 

[vladimir84]

friendly *bump*