Getting this in my file gallery since updating to the latest dev version:

user warning: Unknown column 'n.language' in 'where clause' query: SELECT COUNT(DISTINCT(t.tid)) FROM term_data t INNER JOIN term_hierarchy h ON h.tid = t.tid WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( t.vid = 4 AND h.parent = 160 )ORDER BY weight, name in /var/www/html/XXXX/sites/all/modules/fileframework/contrib/gallery/file_gallery.module on line 234.

I looked at the code, and it looks like the INNER JOIN to 'n' is there but being taken out by db_rewrite_sql.

Comments

Anonymous’s picture

Anonymous (not verified) commented
Title: i18n warning in file_gallery » SQL warning in file_gallery
miglius’s picture

miglius commented

Everything works fine on my setup. I don't know why INNER JOIN {n} is taken out of your query. Maybe some other non FileFramework modules are screwing it? Can you disable all other third party modules and test it then? Or trace the db_rewrite_sql() function to see what's going over there?

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)

Ok, this was an issue with the i18n module rewriting the query.