SQL error

Thanks for the good catch on THE. With Storm enabled and CCK Content Permissions disabled, I still get the error. My only other node permissions module is Taxonomy Lite, but there is no vocabulary for Storm nodes. So I'm puzzled.

Disabled tac_lite and rebuilt permissions. Error msg now is:

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 stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormproject' THE' at line 1 query: SELECT DISTINCT(n.nid) FROM node n INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND (( CASE n.type WHEN 'stormorganization' THEN (SELECT IF(n.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN (SELECT IF( n.uid=11 OR sta1.organization_nid=,1,0) FROM stormtask sta1 WHERE sta1.vid=n.vid) WHEN 'stormticket' THEN (SELECT IF( n.uid=11 OR sti1.organization_nid=,1,0) FROM stormticket sti1 WHERE sti1.vid=n.vid) WHEN 'stormtimetracking' THEN (SELECT IF(n.uid=11 OR stt1.organization_nid=,1,0) FROM stormtimetracking stt1 WHERE stt1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.status = 1 AND n.nid IN (64)) in /home/folio/public_html/cydeck.com/includes/menu.inc on line 1006.

I note that the THE[N] error is well before tac_lite. It does seem to be involved with either na.xxx, which I assume is node access, or the prior section, which is Storm. I'm no SQL expert, but it almost looks like a chunk of the query got dropped between "THE" and " ' at line". That would seem to mean that the Storm query that begins the error msg: ... FROM ... WHERE ... WHEN ... THE[N] got truncated somehow. Invalid elements? I don't know, but that tends to make me think the problem is in Storm somewhere.

pretty much every page. The error msg I quoted appears after login. The user logs in and a rule redirects them. The redirect rule is acting weird right now, and I'm working on that, but it doesn't seem to be the source of the problem. Having logged in, if the user navigates to the home page, a gigantic error msg appears (note that I have reinstalled tac_lite)

* 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 stormorganization sor1 WHERE sor1.vid=node.vid) WHEN 'stormproject' ' at line 10 query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_data_field_overview.field_overview_value AS node_data_field_overview_field_overview_value, node_data_field_overview.field_overview_format AS node_data_field_overview_field_overview_format, node.type AS node_type, node.vid AS node_vid, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -14400 SECOND), '%Y%m%d') AS node_created_day FROM node node LEFT JOIN content_type_requests node_data_field_overview ON node.vid = node_data_field_overview.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'tac_lite') OR (na.gid = 9 AND na.realm = 'tac_lite'))) AND (( CASE node.type WHEN 'stormorganization' THEN (SELECT IF(node.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=node.vid) WHEN 'stormproject' THEN 0 ELSE 1 END )=1 ) AND ( (node.type in ('requests')) AND (node.created > 1243808342-5184000) )ORDER BY node_created_day DESC LIMIT 0, 10 in /home/folio/public_html/cydeck.com/sites/all/modules/views/includes/view.inc on line 731.
* 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 stormorganization sor1 WHERE sor1.vid=node.vid) WHEN 'stormproject' ' at line 8 query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -14400 SECOND), '%Y%m%d') AS node_created_day FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'tac_lite') OR (na.gid = 9 AND na.realm = 'tac_lite'))) AND (( CASE node.type WHEN 'stormorganization' THEN (SELECT IF(node.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=node.vid) WHEN 'stormproject' THEN 0 ELSE 1 END )=1 ) AND ( (node.type in ('offers')) AND (node.created > 1243808342-5184000) )ORDER BY node_created_day DESC LIMIT 0, 10 in /home/folio/public_html/cydeck.com/sites/all/modules/views/includes/view.inc on line 731.
* 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 stormorganization sor1 WHERE sor1.vid=node.vid) WHEN 'stormproject' ' at line 8 query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -14400 SECOND), '%Y%m%d') AS node_created_day FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'tac_lite') OR (na.gid = 9 AND na.realm = 'tac_lite'))) AND (( CASE node.type WHEN 'stormorganization' THEN (SELECT IF(node.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=node.vid) WHEN 'stormproject' THEN 0 ELSE 1 END )=1 ) AND ( (node.type in ('information')) AND (node.created > 1243808342-5184000) )ORDER BY node_created_day DESC LIMIT 0, 10 in /home/folio/public_html/cydeck.com/sites/all/modules/views/includes/view.inc on line 731.
* 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 stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormproject' THE' at line 1 query: SELECT DISTINCT(n.nid) FROM node n INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 0 AND na.realm = 'tac_lite') OR (na.gid = 9 AND na.realm = 'tac_lite'))) AND (( CASE n.type WHEN 'stormorganization' THEN (SELECT IF(n.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) WHEN 'stormproject' THEN 0 ELSE 1 END )=1 ) AND ( n.status = 1 AND n.nid IN (64)) in /home/folio/public_html/cydeck.com/includes/menu.inc on line 1006.

My permissions modules are node access and tac_lite. Other access-type modules are organic groups (projects are not an og node or content type) and IMCE (files, not nodes).

I really appreciate your help on this. I'm going to whack the rules again and see if anything happens.

Disabled all rules. No change. It may haveto do with permissions (since user 1 is unaffected), but it really seems to be somewhere inside Storm. But to be fair, it could be a confllict between Storm and another module, not an inadequacy in Storm. I will fiddle with disabling every module one-by-one, but probably tomorrow. It's getting late here.

Disabled tac_lite, content_access, and og_access.

Disabled all Storm modules. Removed all Storm modules. Re-uploaded and installed Storm.

Enabled core Storm module. No error msg.

Enabled Storm attributes module. No error msg.

Enabled Storm Organizations module. This error msg (note that there is no THE[N] 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 stormorganization sor1 WHERE sor1.vid=n.vid) ELSE 1 END )=1 ) AND (' at line 1 query: SELECT n.nid FROM node n WHERE (( CASE n.type WHEN 'stormorganization' THEN (SELECT IF(n.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.status = 1 AND n.nid IN (64)) in /home/folio/public_html/cydeck.com/includes/menu.inc on line 1006.

Also please note that I'm not using a node access module--only the core Drupal permissions, tac_lite, and cck content_access (field-specific permissions). I also use Organic Groups, and have disabled OG_access before running the test above.

Thanks for your help.

Yikes! Installed the patch, disabled storm org, enabled storm org, now the error msg is:

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 stormorganization sor1 WHERE sor1.vid=n.vid) ELSE 1 END )=1 ) AND (' at line 1 query: SELECT DISTINCT(n.nid) FROM node n INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'tac_lite') OR (na.gid = 15 AND na.realm = 'tac_lite') OR (na.gid = 15 AND na.realm = 'tac_lite') OR (na.gid = 14 AND na.realm = 'tac_lite') OR (na.gid = 17 AND na.realm = 'tac_lite') OR (na.gid = 18 AND na.realm = 'tac_lite') OR (na.gid = 15 AND na.realm = 'tac_lite') OR (na.gid = 14 AND na.realm = 'tac_lite') OR (na.gid = 17 AND na.realm = 'tac_lite') OR (na.gid = 18 AND na.realm = 'tac_lite') OR (na.gid = 15 AND na.realm = 'tac_lite') OR (na.gid = 14 AND na.realm = 'tac_lite') OR (na.gid = 17 AND na.realm = 'tac_lite') OR (na.gid = 18 AND na.realm = 'tac_lite'))) AND (( CASE n.type WHEN 'stormorganization' THEN (SELECT IF(n.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.status = 1 AND n.nid IN (64)) in /home/folio/public_html/cydeck.com/includes/menu.inc on line 1006.

Sorry--I had re-enabled tac_lite in the meantime. I'll go back and disable it and see what happens.

Without tac_lite, it looks like this:

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 stormorganization sor1 WHERE sor1.vid=n.vid) ELSE 1 END )=1 ) AND (' at line 1 query: SELECT n.nid FROM node n WHERE (( CASE n.type WHEN 'stormorganization' THEN (SELECT IF(n.uid=11 OR sor1.nid=,1,0) FROM stormorganization sor1 WHERE sor1.vid=n.vid) ELSE 1 END )=1 ) AND ( n.status = 1 AND n.nid IN (64)) in /home/folio/public_html/cydeck.com/includes/menu.inc on line 1006.

The storm permissions are:

Storm access
Storm attribute access
Storm organization access
Storm organization view belonged
Storm organization view own

This user actually has three roles. One has all five listed permissions, the other two only have the first three permissions. The user has many other permissions for other modules.

By the way, I tried deactivating a few other suspicious modules without any result. I have not disabled all modules except storm, because it would make me crazy. But if you have any ideas about potential inter-module conflict, please let me know.

I do remember a module throwing SQL errors off of menu.inc, and I remember that it was easy to fix, but I'm not at all sure it was Storm (I've been building this site for 60 days), and I can't recall what the fix was. I've tried all the obvious stuff, and the prior experience may be entirely unrelated.

Please let me know what else I can do to assist.

I have forwarded access info to you by PM. You will find that the site has several tricky modules, and being 6.x, some of those are in dev. So it is entirely possible that the problem is not within Storm itself, but I just can't figure that out without the in-depth knowledge of Storm that you have. As mentioned in the PM, I look forward to making a contribution to the Storm Project.

Thanks for all your help.