I created a new user which does not have any access to Storm. When viewing the home page i get the following error:

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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT COUNT(*) FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 ) in /home/crm2/public_html/collaboration/modules/node/node.module on line 1732. 
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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT n.nid, n.sticky, n.created FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /home/crm2/public_html/collaboration/modules/node/node.module on line 1732. 

This happens are the [root]/node level.

At the [root]/ level i get the following error.

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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT n.nid, n.created FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.created DESC LIMIT 0, 10 in /home/crm2/public_html/collaboration/modules/node/node.module on line 1651. 
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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT n.nid, n.created FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.created DESC LIMIT 0, 10 in /home/crm2/public_html/collaboration/modules/node/node.module on line 1651. 
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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT n.nid, n.created FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.created DESC LIMIT 0, 10 in /home/crm2/public_html/collaboration/modules/node/node.module on line 1651. 
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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT n.nid, n.created FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.created DESC LIMIT 0, 10 in /home/crm2/public_html/collaboration/modules/node/node.module on line 1651. 
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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT COUNT(*) FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 ) in /home/crm2/public_html/collaboration/modules/node/node.module on line 1732. 
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 '1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.pr' at line 1 query: SELECT n.nid, n.sticky, n.created FROM node n WHERE (( CASE n.type WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN 0 WHEN 'stormorganization' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 WHEN 'stormticket' THEN (SELECT IF( sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /home/crm2/public_html/collaboration/modules/node/node.module on line 1732. 

Once i give the user read access to storm the error goes away.

Comments

Magnity’s picture

Version: 6.x-1.9 » 6.x-1.21
Status: Active » Postponed (maintainer needs more info)

I've just tested this on the latest version and cannot reproduce the error. Is this still an issue?

Magnity’s picture

Status: Postponed (maintainer needs more info) » Fixed

Assuming fixed - please reopen if this is still an issue.

Status: Fixed » Closed (fixed)

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