SQL warning when combined with I18N module
hamsterbacke82 - February 20, 2009 - 10:43
| Project: | Storm |
| Version: | 6.x-1.x-dev |
| Component: | Storm Teammember |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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.

#1
I 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,
#2
Please reopen if this is still an issue.
#3
Reopening as per #470134: Teammembers page produces error on multilingual sites
#4
I'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.
#5
I 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.?
#6
Title 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)
#7
Does 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.
#8
i 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?
#9
Committed
http://drupal.org/cvs?commit=232160
#10
Automatically closed -- issue fixed for 2 weeks with no activity.