cchiacchierini
Member
Getting the following error when initiating a filter of a list:
500 Fabrik has generated an incorrect query for the list.
URL: library2015.ocom.edu/journal-tracking
Joomla 3.4.1
Fabrik latest from Git.
500 Fabrik has generated an incorrect query for the list.
Code:
Unknown column 'journal_checkin.JAI' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `journal_checkin`.`id_raw` AS `journal_checkin___id_raw`,
`journal_checkin`.`id_raw` AS `journal_checkin___id_raw_raw`,
`journal_checkin`.`date_time_raw` AS `journal_checkin___date_time_raw`,
`journal_checkin`.`date_time_raw` AS `journal_checkin___date_time_raw_raw`,
`journal_checkin`.`journal_title_raw` AS `journal_checkin___journal_title_raw`,
`journal_checkin`.`journal_title_raw` AS `journal_checkin___journal_title_raw_raw`,
`journal_checkin`.`volume_raw` AS `journal_checkin___volume_raw`,
`journal_checkin`.`volume_raw` AS `journal_checkin___volume_raw_raw`,
`journal_checkin`.`issue_raw` AS `journal_checkin___issue_raw`,
`journal_checkin`.`issue_raw` AS `journal_checkin___issue_raw_raw`,
`journal_checkin`.`expected_date_raw` AS `journal_checkin___expected_date_raw`,
`journal_checkin`.`expected_date_raw` AS `journal_checkin___expected_date_raw_raw`,
`journal_checkin`.`order_status_raw` AS `journal_checkin___order_status_raw`,
`journal_checkin`.`order_status_raw` AS `journal_checkin___order_status_raw_raw`,
`journal_checkin`.`Date_raw` AS `journal_checkin___Date_raw`,
`journal_checkin`.`Date_raw` AS `journal_checkin___Date_raw_raw`,
`journal_checkin`.`alma_raw` AS `journal_checkin___alma_raw`,
`journal_checkin`.`alma_raw` AS `journal_checkin___alma_raw_raw`,
`journal_checkin`.`Date_completed_raw` AS `journal_checkin___Date_completed_raw`,
`journal_checkin`.`Date_completed_raw` AS `journal_checkin___Date_completed_raw_raw`,
`journal_checkin`.`JAI_raw` AS `journal_checkin___JAI_raw`,
`journal_checkin`.`JAI_raw` AS `journal_checkin___JAI_raw_raw`,
`journal_checkin`.`Indexed_by_raw` AS `journal_checkin___Indexed_by_raw`,
`journal_checkin`.`Indexed_by_raw` AS `journal_checkin___Indexed_by_raw_raw`,
`journal_checkin`.`No_of_Articles_raw` AS `journal_checkin___No_of_Articles_raw`,
`journal_checkin`.`No_of_Articles_raw` AS `journal_checkin___No_of_Articles_raw_raw`,
`journal_checkin`.`id_raw` AS slug
, `journal_checkin`.`id_raw` AS `__pk_val`
FROM `journal_checkin`
WHERE ( (`journal_checkin`.`JAI` = '1' OR `journal_checkin`.`JAI` LIKE '[\"1\"%' OR `journal_checkin`.`JAI` LIKE '%\"1\"%' OR `journal_checkin`.`JAI` LIKE '%\"1\"]') ) LIMIT 0, 50
URL: library2015.ocom.edu/journal-tracking
Joomla 3.4.1
Fabrik latest from Git.