The following error shows up when I try to assign a team member to a project
user warning: Unknown column 'n.language' in 'where clause' query: SELECT COUNT(*) FROM stormteammember stm WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( ('storm_access'='storm_access') ) in (...)/sites/all/modules/storm/stormteammember/stormteammember.admin.inc on line 100.
Comments
Comment #1
Magnity commentedI don't use i18n - can you confirm that this error, a) still happens on the latest version and b) whether it happens with i18n disabled?
Thanks,
Comment #2
Magnity commentedPlease reopen if this is still an issue.
Comment #3
Magnity commentedReopening as per #470134: Teammembers page produces error on multilingual sites
Comment #4
hobo commentedI'm seeing the same problem. I have I18n enabled.
If i browse to eng/storm/teammembers
I get this warning:
* user warning: Unknown column 'n.language' in 'where clause' query: SELECT COUNT(*) FROM stormteammember stm WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( ('storm_access'='storm_access') ) in /home/dm6/sites/all/modules/storm/stormteammember/stormteammember.admin.inc on line 100.
* user warning: Unknown column 'n.language' in 'where clause' query: SELECT stm.* FROM stormteammember stm WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( ('storm_access'='storm_access') ) ORDER BY stm.organization_title ASC LIMIT 0, 10 in /home/dm6/sites/all/modules/storm/stormteammember/stormteammember.admin.inc on line 100.
Comment #5
hobo commentedI did a little research and found
http://drupal.org/node/78699
it seems this might be an error due to the use of mysql 5.?
Comment #6
Magnity commentedTitle change
Can you confirm this is in the latest version too? (Currently version is listed as 6.x-1.20 - most recent is 1.22)
Comment #7
Magnity commentedDoes the error persist if line 97 of stormteammember.admin.inc (
$s = db_rewrite_sql($s);) is commented out?I suspect that the error is due to calling the node access routines without the node table present - so this line may not be needed.
Comment #8
homoludens commentedi have tried i18n with latest -dev, same error.
with line $s = db_rewrite_sql($s); commented out error goes away.
i guess it is fixed?
Comment #9
Magnity commentedCommitted
http://drupal.org/cvs?commit=232160