Unknown column 'sit1.organization_nid'

a shorter one

user warning: Unknown column 'spr.organization_nid' in 'where clause' query: SELECT n.nid, n.title FROM stormorganization so INNER JOIN node n ON so.nid=n.nid WHERE (n.uid=3 OR spr.organization_nid=3 AND 'spr_access'='spr_access' ) AND ( n.status=1 AND n.type='stormorganization' ) ORDER BY n.title in C:\sites\drupal6\sites\all\modules\storm\stormproject\stormproject.module on line 236.

Updated to 1.7 and i get these errors after logging in (cleared cache + session table)

user warning: Unknown column 'sit1.organization_nid' in 'field list' query: SELECT COUNT(*) FROM node n WHERE ((case n.type WHEN 'stormexpense' THEN 0 WHEN 'storminvoice' THEN (SELECT IF(sin1.organization_nid=3,1,0) FROM storminvoice sin1 WHERE sin1.vid=n.vid) WHEN 'storminvoiceitem' THEN (SELECT IF(sit1.organization_nid=3,1,0) FROM storminvoiceitem sit1 WHERE sit1.vid=n.vid) WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN (SELECT IF(sno1.organization_nid=3,1,0) FROM stormnote sno1 WHERE sno1.vid=n.vid) WHEN 'stormorganization' THEN (SELECT IF(n.uid=3 OR sor1.nid=3,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormperson' THEN (SELECT IF(spe1.organization_nid=3,1,0) FROM stormperson sti1 WHERE spe1.vid=n.vid) WHEN 'stormproject' THEN (SELECT IF(spr1.organization_nid=3,1,0) FROM stormproject spr1 WHERE spr1.vid=n.vid) WHEN 'stormtask' THEN (SELECT IF(sta1.organization_nid=3,1,0) FROM stormtask sta1 WHERE sta1.vid=n.vid) WHEN 'stormticket' THEN (SELECT IF(sti1.organization_nid=3,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) WHEN 'stormtimetracking' THEN 0 else 1 end)=1) AND ( n.promote = 1 AND n.status = 1 ) in C:\sites\drupal6\modules\node\node.module on line 1734. 

user warning: Unknown column 'sit1.organization_nid' in 'field list' query: SELECT n.nid, n.sticky, n.created FROM node n WHERE ((case n.type WHEN 'stormexpense' THEN 0 WHEN 'storminvoice' THEN (SELECT IF(sin1.organization_nid=3,1,0) FROM storminvoice sin1 WHERE sin1.vid=n.vid) WHEN 'storminvoiceitem' THEN (SELECT IF(sit1.organization_nid=3,1,0) FROM storminvoiceitem sit1 WHERE sit1.vid=n.vid) WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN (SELECT IF(sno1.organization_nid=3,1,0) FROM stormnote sno1 WHERE sno1.vid=n.vid) WHEN 'stormorganization' THEN (SELECT IF(n.uid=3 OR sor1.nid=3,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormperson' THEN (SELECT IF(spe1.organization_nid=3,1,0) FROM stormperson sti1 WHERE spe1.vid=n.vid) WHEN 'stormproject' THEN (SELECT IF(spr1.organization_nid=3,1,0) FROM stormproject spr1 WHERE spr1.vid=n.vid) WHEN 'stormtask' THEN (SELECT IF(sta1.organization_nid=3,1,0) FROM stormtask sta1 WHERE sta1.vid=n.vid) WHEN 'stormticket' THEN (SELECT IF(sti1.organization_nid=3,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) WHEN 'stormtimetracking' THEN 0 else 1 end)=1) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in C:\sites\drupal6\modules\node\node.module on line 1734.

Me again, updated to 1.7 and i get these errors after logging in (cleared cache + session table)

user warning: Unknown column 'spe1.organization_nid' in 'field list' query: SELECT COUNT(*) FROM node n WHERE ((case n.type WHEN 'stormexpense' THEN 0 WHEN 'storminvoice' THEN (SELECT IF(sin1.organization_nid=3,1,0) FROM storminvoice sin1 WHERE sin1.vid=n.vid) WHEN 'storminvoiceitem' THEN 0 WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN (SELECT IF(sno1.organization_nid=3,1,0) FROM stormnote sno1 WHERE sno1.vid=n.vid) WHEN 'stormorganization' THEN (SELECT IF(n.uid=3 OR sor1.nid=3,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormperson' THEN (SELECT IF(spe1.organization_nid=3,1,0) FROM stormperson sti1 WHERE spe1.vid=n.vid) WHEN 'stormproject' THEN (SELECT IF(spr1.organization_nid=3,1,0) FROM stormproject spr1 WHERE spr1.vid=n.vid) WHEN 'stormtask' THEN (SELECT IF(sta1.organization_nid=3,1,0) FROM stormtask sta1 WHERE sta1.vid=n.vid) WHEN 'stormticket' THEN (SELECT IF(sti1.organization_nid=3,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) WHEN 'stormtimetracking' THEN 0 else 1 end)=1) AND ( n.promote = 1 AND n.status = 1 ) in C:\sites\drupal6\modules\node\node.module on line 1734. 

user warning: Unknown column 'spe1.organization_nid' in 'field list' query: SELECT n.nid, n.sticky, n.created FROM node n WHERE ((case n.type WHEN 'stormexpense' THEN 0 WHEN 'storminvoice' THEN (SELECT IF(sin1.organization_nid=3,1,0) FROM storminvoice sin1 WHERE sin1.vid=n.vid) WHEN 'storminvoiceitem' THEN 0 WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN (SELECT IF(sno1.organization_nid=3,1,0) FROM stormnote sno1 WHERE sno1.vid=n.vid) WHEN 'stormorganization' THEN (SELECT IF(n.uid=3 OR sor1.nid=3,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormperson' THEN (SELECT IF(spe1.organization_nid=3,1,0) FROM stormperson sti1 WHERE spe1.vid=n.vid) WHEN 'stormproject' THEN (SELECT IF(spr1.organization_nid=3,1,0) FROM stormproject spr1 WHERE spr1.vid=n.vid) WHEN 'stormtask' THEN (SELECT IF(sta1.organization_nid=3,1,0) FROM stormtask sta1 WHERE sta1.vid=n.vid) WHEN 'stormticket' THEN (SELECT IF(sti1.organization_nid=3,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) WHEN 'stormtimetracking' THEN 0 else 1 end)=1) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in C:\sites\drupal6\modules\node\node.module on line 1734. 

Errors at login are gone, but I found at when going to '/storm/projects' again as a regular user

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHEN 'storminvoiceitem' THEN 0 WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnot' at line 1 query: SELECT n.nid, n.title FROM node AS n INNER JOIN stormorganization AS sor ON n.vid=sor.vid WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( ((case n.type WHEN 'stormexpense' THEN 0 WHEN 'storminvoice' THEN (SELECT IF(sin1.organization_nid=3,1,0) FROM storminvoice sin1 WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( sin1.vid=n.vid) WHEN 'storminvoiceitem' THEN 0 WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN (SELECT IF(sno1.organization_nid=3,1,0) FROM stormnote sno1 WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( sno1.vid=n.vid) WHEN 'stormorganization' THEN (SELECT IF(n.uid=3 OR sor1.nid=3,1,0) FROM stormorganization sor1 WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( sor1.vid=n.vid) WHEN 'stormperson' THEN (SELECT IF(spe1.organization_nid=3,1,0) FROM stormperson spe1 WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( spe1.vid=n.vid) WHEN 'stormproject' THEN (SELECT IF(spr1.organization_nid=3,1,0) FROM stormproject spr1 WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( spr1.vid=n.vid) WHEN 'stormtask' THEN (SELECT IF(sta1.organization_nid=3,1,0) FROM stormtask sta1 WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( sta1.vid=n.vid) WHEN 'stormticket' THEN (SELECT IF(sti1.organization_nid=3,1,0) FROM stormticket sti1 WHERE (n.uid=3 OR n.nid=3 AND 'sor_access'='sor_access' ) AND ( sti1.vid=n.vid) WHEN 'stormtimetracking' THEN 0 else 1 end)=1) AND ( n.status=1 AND n.type='stormorganization' )) ORDER BY n.title in C:\sites\drupal6\sites\all\modules\storm\stormproject\stormproject.admin.inc on line 117.

on '/node/add/stormproject?destination=storm%2Fprojects'

user warning: Unknown column 'spr.organization_nid' in 'where clause' query: SELECT n.nid, n.title FROM stormorganization so INNER JOIN node n ON so.nid=n.nid WHERE (spr.organization_nid=3 AND 'spr_access'='spr_access' ) AND ( n.status=1 AND n.type='stormorganization' ) ORDER BY n.title in C:\sites\drupal6\sites\all\modules\storm\stormproject\stormproject.module on line 236.

http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/storm/storm... fixed #8

#7 still occurs

It's fixed in 1.9 :p