Getting `Unknown column 'n.uid' in 'field list'` Error After Installing Storm

Looking further I noticed that the Blocks were looking odd, many of the sections for Amity Island theme were no longer available after installing Storm. I reverted the DB to the version before installing Storm, the SQL errors are gone and the sections for Amity Island are back.

The error continued with Storm .19. Playing around it seems by giving Authenticated User "View All" to all Storm modules causes the SQL errors to go away. Amity Island still loses its blocks after installing Storm. The modules I have are (sites/all/modules none in default):

adminrole/adminrole.info:version = "6.x-1.0-beta2"
advanced_help/advanced_help.info:version = "6.x-1.1"
calendar/calendar.info:version = "6.x-2.0-rc6"
cck/content.info:version = "6.x-2.1"
ctm/ctm.info:version = "6.x-1.0"
date/date_api.info:version = "6.x-2.0-rc6"
event/event.info:version = "6.x-2.x-dev"
minutes/minutes.info:version = "6.x-1.0-beta1"
minutes/minutesattendees.info:version = "6.x-1.0-beta1"
nice_menus/nice_menus.info:version = "6.x-1.3"
nodeaccess/nodeaccess.info:version = "6.x-1.x-dev"
nodeaccess/nodeaccess.info:version = "6.x-1.2"
og/og.info:version = "6.x-1.1"
og_forum/og_forum.info:version = "6.x-1.0-beta1"
og_minutes/og_minutes.info:version = "6.x-1.0-beta1"
simplemenu/simplemenu.info:version = "6.x-1.2"
storm/storm.info:version = "6.x-1.19"
submenutree/submenutree.info:version = "6.x-1.3"
userplus/userplus.info:version = "6.x-2.1"
views/views.info:version = "6.x-2.2"
views/views_ui.info:version = "6.x-2.2"
advanced_help/help_example/help_example.info:version = "6.x-1.1"
calendar/calendar_ical/calendar_ical.info:version = "6.x-2.0-rc6"
calendar/jcalendar/jcalendar.info:version = "6.x-2.0-rc6"
date/date/date.info:version = "6.x-2.0-rc6"
date/date_copy/date_copy.info:version = "6.x-2.0-rc6"
date/date_php4/date_php4.info:version = "6.x-2.0-rc6"
date/date_popup/date_popup.info:version = "6.x-2.0-rc6"
date/date_repeat/date_repeat.info:version = "6.x-2.0-rc6"
date/date_timezone/date_timezone.info:version = "6.x-2.0-rc6"
storm/stormattribute/stormattribute.info:version = "6.x-1.19"
storm/stormexpense/stormexpense.info:version = "6.x-1.19"
storm/storminvoice/storminvoice.info:version = "6.x-1.19"
storm/storminvoiceitem/storminvoiceitem.info:version = "6.x-1.19"
storm/stormknowledgebase/stormknowledgebase.info:version = "6.x-1.19"
storm/stormnote/stormnote.info:version = "6.x-1.19"
storm/stormorganization/stormorganization.info:version = "6.x-1.19"
storm/stormperson/stormperson.info:version = "6.x-1.19"
storm/stormproject/stormproject.info:version = "6.x-1.19"
storm/stormtask/stormtask.info:version = "6.x-1.19"
storm/stormteammember/stormteammember.info:version = "6.x-1.19"
storm/stormticket/stormticket.info:version = "6.x-1.19"
storm/stormtimetracking/stormtimetracking.info:version = "6.x-1.19"
views/views_export/views_export.info:version = "6.x-2.2"

Roberto

I am not sure how I can tell if I am not using something other than 6.x-1.19. In storm.info I see:
; $Id: storm.info,v 1.3 2008/06/23 16:46:34 robertogerola Exp $
; Information added by drupal.org packaging script on 2008-12-22
version = "6.x-1.19"

I assume the package is 1.19.

I could not find method stormexpense_storm_rewrite_sql, did find stormexpense_storm_rewrite_where_sql, pasted below. The echo prints out:

nodenodenodenodennodenodenodenoden

function stormexpense_storm_rewrite_where_sql($query, $primary_table, $account) {
static $conds = array();

echo $primary_table;

if ($conds[$account->uid]) {
return $conds[$account->uid];
}

if (preg_match("/'storm_access'='storm_access'/", $query)) {
$cond = '';
}
else {
if (user_access('Storm expense: view all', $account)) {
return '';
}

$cond = '';
if (user_access('Storm expense: view own', $account)) {
$cond .= "${primary_table}.uid=". $account->uid;
}
if (user_access('Storm expense view of user organization', $account)) {
if ($cond) $cond .= ' OR ';
$cond .= ' sex1.organization_nid='. $account->stormorganization_nid;
}
if ($cond) {
$cond = " WHEN 'stormexpense' THEN (SELECT IF($cond,1,0) FROM {stormexpense} sex1 WHERE sex1.vid=${primary_table}.vid) ";
}
else {
$cond = " WHEN 'stormexpense' THEN 0 ";
}
}

$conds[$account->uid] = $cond;
return $cond;
}

Ismat

The echo also prints out similar to below (extra n's) depending on how I navigate. Going to a Group prints

nodenodennnodenodenodenodenodenodenodenoden

Home Page:
-node -node -node -node -n -node -node -node -node -n

Group Home Page:
-node -node -n -n -node -node -node -node -node -node -node -node -n

after previous post, changed to print $query versus $sql:

function stormexpense_storm_rewrite_where_sql($query, $primary_table, $account) {
static $conds = array();

#echo $sql .'-'. $primary_table ."\n";
echo $query .'-'. $primary_table ."\n";

Home Page:
SELECT node.nid AS nid, node.changed AS node_changed, node.title AS node_title, node.type AS node_type FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) ORDER BY node_changed ASC -node SELECT node.nid AS nid FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) -node SELECT node.nid AS nid, node.changed AS node_changed, node.title AS node_title, node.type AS node_type FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) ORDER BY node_changed ASC -node SELECT node.nid AS nid FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) -node SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d, %d, %d)-n SELECT node.nid AS nid, node.title AS node_title, users.name AS users_name, users.uid AS users_uid FROM {node} node LEFT JOIN {og_uid} og_uid ON node.nid = og_uid.nid INNER JOIN {users} users ON node.uid = users.uid WHERE (node.status <> 0) AND (node.type IN ('%s')) AND (og_uid.uid = ***CURRENT_USER***) ORDER BY node_title ASC -node SELECT node.nid AS nid FROM {node} node LEFT JOIN {og_uid} og_uid ON node.nid = og_uid.nid INNER JOIN {users} users ON node.uid = users.uid WHERE (node.status <> 0) AND (node.type IN ('%s')) AND (og_uid.uid = ***CURRENT_USER***) -node SELECT node.nid AS nid, node.type AS node_type, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, og_ancestry.nid AS og_ancestry_nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, history_user.timestamp AS history_user_timestamp, history_user.nid AS history_user_nid, node.created AS node_created, node.changed AS node_changed FROM {node} node LEFT JOIN {og_ancestry} og_ancestry ON node.nid = og_ancestry.nid INNER JOIN {node} node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN {og_uid} node_og_ancestry__og_uid ON node_og_ancestry.nid = node_og_ancestry__og_uid.nid INNER JOIN {users} users ON node.uid = users.uid LEFT JOIN {node_comment_statistics} node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN {history} history_user ON node.nid = history_user.nid AND history_user.uid = ***CURRENT_USER*** WHERE (node.status <> 0) AND (node_og_ancestry__og_uid.uid = ***CURRENT_USER***) ORDER BY node_comment_statistics_last_comment_timestamp DESC -node SELECT node.nid AS nid FROM {node} node LEFT JOIN {og_ancestry} og_ancestry ON node.nid = og_ancestry.nid INNER JOIN {node} node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN {og_uid} node_og_ancestry__og_uid ON node_og_ancestry.nid = node_og_ancestry__og_uid.nid INNER JOIN {users} users ON node.uid = users.uid LEFT JOIN {node_comment_statistics} node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN {history} history_user ON node.nid = history_user.nid AND history_user.uid = ***CURRENT_USER*** WHERE (node.status <> 0) AND (node_og_ancestry__og_uid.uid = ***CURRENT_USER***) -node SELECT n.nid, n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_site, tz.name as timezone_name FROM {node} n INNER JOIN {event} e ON n.nid = e.nid INNER JOIN {event_timezones} tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '%s' AND e.event_start <= '%s') OR (e.event_end >= '%s' AND e.event_end <= '%s') OR (e.event_start <= '%s' AND e.event_end >= '%s')) GROUP BY n.nid HAVING (event_start >= '%s' AND event_start <= '%s') OR (event_end >= '%s' AND event_end <= '%s') OR (event_start <= '%s' AND event_end >= '%s') ORDER BY event_start ASC-n

Group Home Page:
SELECT node.nid AS nid, node.sticky AS node_sticky, node.created AS node_created FROM {node} node LEFT JOIN {og_ancestry} og_ancestry ON node.nid = og_ancestry.nid WHERE (node.status <> 0) AND (og_ancestry.group_nid = %d) ORDER BY node_sticky DESC, node_created DESC -node SELECT node.nid AS nid FROM {node} node LEFT JOIN {og_ancestry} og_ancestry ON node.nid = og_ancestry.nid WHERE (node.status <> 0) AND (og_ancestry.group_nid = %d) -node SELECT n.nid FROM {node} n WHERE n.nid IN (%d)-n SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (%d, %d, %d)-n SELECT node.nid AS nid, node.changed AS node_changed, node.title AS node_title, node.type AS node_type FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) ORDER BY node_changed ASC -node SELECT node.nid AS nid FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) -node SELECT node.nid AS nid, node.changed AS node_changed, node.title AS node_title, node.type AS node_type FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) ORDER BY node_changed ASC -node SELECT node.nid AS nid FROM {node} node WHERE (node.status <> 0) AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') <= '2009-01' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.changed), SEC_TO_TIME(-21600)), '%Y-%m') >= '2009-01')) -node SELECT node.nid AS nid, node.title AS node_title, users.name AS users_name, users.uid AS users_uid FROM {node} node LEFT JOIN {og_uid} og_uid ON node.nid = og_uid.nid INNER JOIN {users} users ON node.uid = users.uid WHERE (node.status <> 0) AND (node.type IN ('%s')) AND (og_uid.uid = ***CURRENT_USER***) ORDER BY node_title ASC -node SELECT node.nid AS nid FROM {node} node LEFT JOIN {og_uid} og_uid ON node.nid = og_uid.nid INNER JOIN {users} users ON node.uid = users.uid WHERE (node.status <> 0) AND (node.type IN ('%s')) AND (og_uid.uid = ***CURRENT_USER***) -node SELECT node.nid AS nid, node.type AS node_type, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, og_ancestry.nid AS og_ancestry_nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, history_user.timestamp AS history_user_timestamp, history_user.nid AS history_user_nid, node.created AS node_created, node.changed AS node_changed FROM {node} node LEFT JOIN {og_ancestry} og_ancestry ON node.nid = og_ancestry.nid INNER JOIN {node} node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN {og_uid} node_og_ancestry__og_uid ON node_og_ancestry.nid = node_og_ancestry__og_uid.nid INNER JOIN {users} users ON node.uid = users.uid LEFT JOIN {node_comment_statistics} node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN {history} history_user ON node.nid = history_user.nid AND history_user.uid = ***CURRENT_USER*** WHERE (node.status <> 0) AND (node_og_ancestry__og_uid.uid = ***CURRENT_USER***) ORDER BY node_comment_statistics_last_comment_timestamp DESC -node SELECT node.nid AS nid FROM {node} node LEFT JOIN {og_ancestry} og_ancestry ON node.nid = og_ancestry.nid INNER JOIN {node} node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN {og_uid} node_og_ancestry__og_uid ON node_og_ancestry.nid = node_og_ancestry__og_uid.nid INNER JOIN {users} users ON node.uid = users.uid LEFT JOIN {node_comment_statistics} node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN {history} history_user ON node.nid = history_user.nid AND history_user.uid = ***CURRENT_USER*** WHERE (node.status <> 0) AND (node_og_ancestry__og_uid.uid = ***CURRENT_USER***) -node SELECT n.nid, n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL %d SECOND AS event_end_site, tz.name as timezone_name FROM {node} n INNER JOIN {event} e ON n.nid = e.nid INNER JOIN {event_timezones} tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '%s' AND e.event_start <= '%s') OR (e.event_end >= '%s' AND e.event_end <= '%s') OR (e.event_start <= '%s' AND e.event_end >= '%s')) GROUP BY n.nid HAVING (event_start >= '%s' AND event_start <= '%s') OR (event_end >= '%s' AND event_end <= '%s') OR (event_start <= '%s' AND event_end >= '%s') ORDER BY event_start ASC-n

Roberto, thank you very much for your help and also showing me some ways in which I can find the offending module. Also, I would like to very much thank you for the Storm modules, they are excellent.