List errors when changing filters

[prophoto]

I am getting db errors when filtering data, is this a fabrik problem or something I setup wrong?

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 ') ORDER BY `acrs2`.`Contract` ASC, `acrs2`.`Data_Period` ASC LIMIT 0, 10' at line 31 SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `acrs2`.`id` AS `acrs2___id`, `acrs2`.`id` AS `acrs2___id_raw`, `acrs2`.`date_time` AS `acrs2___date_time`, `acrs2`.`date_time` AS `acrs2___date_time_raw`, `acrs2`.`User_Id` AS `acrs2___User_Id_raw`, `vi43k_users`.`id` AS `acrs2___User_Id`, `acrs2`.`Contract` AS `acrs2___Contract`, `acrs2`.`Contract` AS `acrs2___Contract_raw`, `acrs2`.`Data_Period` AS `acrs2___Data_Period`, `acrs2`.`Data_Period` AS `acrs2___Data_Period_raw`, `acrs2`.`5A1` AS `acrs2___5A1`, `acrs2`.`5A1` AS `acrs2___5A1_raw`, `acrs2`.`5A1_1` AS `acrs2___5A1_1`, `acrs2`.`5A1_1` AS `acrs2___5A1_1_raw`, `acrs2`.`5A1_2` AS `acrs2___5A1_2`, `acrs2`.`5A1_2` AS `acrs2___5A1_2_raw`, `acrs2`.`5A1_3` AS `acrs2___5A1_3`, `acrs2`.`5A1_3` AS `acrs2___5A1_3_raw`, `acrs2`.`5A1_4` AS `acrs2___5A1_4`, `acrs2`.`5A1_4` AS `acrs2___5A1_4_raw`, `acrs2`.`6D7` AS `acrs2___6D7`, `acrs2`.`6D7` AS `acrs2___6D7_raw`, `acrs2`.`7F1` AS `acrs2___7F1`, `acrs2`.`7F1` AS `acrs2___7F1_raw`, `acrs2`.`7F2` AS `acrs2___7F2`, `acrs2`.`7F2` AS `acrs2___7F2_raw`, `acrs2`.`id` AS slug , `acrs2`.`id` AS `__pk_val` FROM `acrs2` LEFT JOIN `vi43k_users` AS `vi43k_users` ON `vi43k_users`.`id` = `acrs2`.`User_Id` WHERE ( `acrs2`.`Contract` = ) ORDER BY `acrs2`.`Contract` ASC, `acrs2`.`Data_Period` ASC LIMIT 0, 10

 

[troester]

Which filter did you set up, a prefilter on "Contract"? (which seems to have an empty value)

 

[prophoto]

I checked each record and none are empty in contract. Also profilers are off for the list.

 

[prophoto]

bump bump

 

[prophoto]

help me its been 3 weeks since I've received a reply!

 

[troester]

errors when filtering data

Which filter are you using: element set to filter, search all, URL filtering, filter in content plugin, a prefilter?

 

[prophoto]

This has been fixed with the latest updates via Joomla Update then Github.