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. ;-)
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. ;-)