500 Error Unknown Column

[cchiacchierini]

Getting the following error when initiating a filter of a list:

500 Fabrik has generated an incorrect query for the list.

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.

 

[troester]

Looks totally strange.
Are all your DB columns (=element names) named xxx_raw?

 

[cchiacchierini]

They are. It looks as though they were imported in from an old fabrik install.

 

[cheesegrits]

I don't seem to be able to login with the credentials I have for you.

-- hugh

 

[cchiacchierini]

Hugh. Checking on credentials.

 

[cchiacchierini]

I just added the site with admin credentials to my sites.

 

[cchiacchierini]

I should add that the list in question is using javascript for this element: journal_checkin___journal_title_raw

 

[cheesegrits]

So was the list created from a table with field names that had _raw on the end? Perhaps through a CSV import?

You can't use fields in a table with _raw on the end, as that'll confuse a lot of Fabrik's code. I think we prevent you from creating one via Fabrik's "new element", but I don't think we test for it when creating a list from an existing table, or doing a CSV import.

-- hugh

 

[cchiacchierini]

Thanks. Recreated without raw. Working now.

 

[cheesegrits]

Cool. Thanks for the update.

-- hugh