Issue with Cascade dropdown + filter dropdown enabled

Tessa

Member
Hi, I have a few forms set with a databasejoin, and a cascading dropdown element (set up correctly). I've done this a zillion times in joomla 2.5, but this is my first fabrik site i'm building in joomla 3.3.

For each page I set up a databasejoin element +cascading dropdown with both set to a dropdown, the list page turns into a 500 error:
500

Error: 500

filter query error: factory_id Incorrect table name '' SQL=SELECT DISTINCT(`tbl_factory`.`factory`) AS `text`, `tbl_skiboot_productionschedule`.`factory_id` AS `value` FROM `tbl_skiboot_productionschedule` INNER JOIN `` AS `tbl_factory` ON `tbl_factory`.`id` = `tbl_skiboot_productionschedule`.`factory_id` WHERE `tbl_skiboot_productionschedule`.`factory_id` IN ('') ORDER BY `tbl_factory`.`factory`ASC LIMIT 0, 100


So for a work around, I have to change all my cascading dropdowns to databasejoins.

Have you seen this issue before? Latest github update, yesterday, but I had this issue months before. Not a big deal but just a slight hassle. ;-)
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top