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

Magnity - May 10, 2009 - 20:06
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,

#2

Magnity - May 16, 2009 - 22:46
Status:postponed (maintainer needs more info)» closed

Please reopen if this is still an issue.

#3

Magnity - May 24, 2009 - 08:19
Status:closed» active

Reopening as per #470134: Teammembers page produces error on multilingual sites

#4

hobo - June 10, 2009 - 16:49

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

hobo - June 12, 2009 - 19:55

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

Magnity - June 20, 2009 - 15:57
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)

#7

Magnity - June 30, 2009 - 21:08
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.

#8

homoludens - July 1, 2009 - 01:51
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?

#9

Magnity - July 1, 2009 - 10:04

#10

System Message - July 15, 2009 - 10:10
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.