Bug in Prefilter on databasejoin

[swissgregi]

I have a simple list with a repeated databasejoin.
If i create a menu with a prefilter on the databasejoin, i get a error.

getData:Unknown column 'firma_repeat_kategorie_id.kategorie_id' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `firma`.`id` AS `firma___id`, `firma`.`id` AS `firma___id_raw`, `firma`.`date_time` AS `firma___date_time`, `firma`.`date_time` AS `firma___date_time_raw`, `firma`.`kanton_id` AS `firma___kanton_id_raw`, `kantone`.`kanton` AS `firma___kanton_id`, `firma`.`name` AS `firma___name`, `firma`.`name` AS `firma___name_raw`, `firma`.`beschreibung` AS `firma___beschreibung`, `firma`.`beschreibung` AS `firma___beschreibung_raw`, (SELECT GROUP_CONCAT(kategorien.kategorie SEPARATOR '//..*..//') FROM firma_repeat_kategorie_id LEFT JOIN kategorien ON kategorien.id = firma_repeat_kategorie_id.kategorie_id WHERE firma_repeat_kategorie_id.parent_id = `firma`.`id`) AS firma_repeat_kategorie_id___kategorie_id, (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM firma_repeat_kategorie_id WHERE parent_id = `firma`.`id`) AS `firma_repeat_kategorie_id___kategorie_id_raw`, (SELECT GROUP_CONCAT(kategorie_id SEPARATOR '//..*..//') FROM firma_repeat_kategorie_id WHERE firma_repeat_kategorie_id.parent_id = `firma`.`id`) AS firma_repeat_kategorie_id___kategorie_id_id, (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM firma_repeat_kategorie_id WHERE parent_id = `firma`.`id`) AS `firma_repeat_kategorie_id___params`, `firma`.`id` AS slug , `firma`.`id` AS `__pk_val` FROM `firma` LEFT JOIN `kantone` AS `kantone` ON `kantone`.`id` = `firma`.`kanton_id` WHERE ( firma_repeat_kategorie_id.kategorie_id LIKE '%Reinigung%' ) LIMIT 0, 10

This marked sql query refers to a table on a subselect. The table firma_repeat_kategorie_id is not available for a WHERE condition.

This should be fixed.

Thanks

 

[rob]

hi

I've had a go at fixing this one in github - could you update from there and tell me if the changes work for you?

Cheers
Rob

 

[swissgregi]

Hmm, i can't update.
I do the update like here: http://fabrikar.com/forums/index.php?wiki/update-from-github/
After that i to "Extension Manager", "Update", "Purge Cache" and "Find Updates".. but then Joomla finds the same updates again and again.

This problem i have with all my Fabrik installations. Is there something wrong with github update at moment?

 

[swissgregi]

Oh, it was my fault. sorry.
It works now. Thanks alot!