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

Magnity’s picture

Component: Code » Storm Teammember
Status: Active » Postponed (maintainer needs more info)

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,

Magnity’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

Please reopen if this is still an issue.

Magnity’s picture

Status: Closed (fixed) » Active
hobo’s picture

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.

hobo’s picture

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.?

Magnity’s picture

Title: team member assign bug (i18?) » SQL warning when combined with I18N module
Priority: Minor » Normal

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)

Magnity’s picture

Status: Active » Needs review

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.

homoludens’s picture

Version: 6.x-1.20 » 6.x-1.x-dev
Status: Needs review » Fixed

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?

Magnity’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.