After installing Storm and Views modules and after configuring a user role called "cliente" which can "view own Storm note" I obtain the message:

user warning: Unknown column 'n.uid' in 'field list' query: SELECT node.nid AS nid, node.title AS node_title, node.created AS node_created, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 3600 SECOND), '%Y%m%d%H%i') AS node_created_minute, node.type AS node_type FROM node node WHERE (( CASE node.type WHEN 'storminvoice' THEN 0 WHEN 'storminvoiceitem' THEN 0 WHEN 'stormnote' THEN (SELECT IF(n.uid=3,1,0) FROM stormnote sno1 WHERE sno1.vid=n.vid) WHEN 'stormorganization' THEN 0 WHEN 'stormperson' THEN 0 WHEN 'stormproject' THEN 0 WHEN 'stormtask' THEN 0 ELSE 1 END )=1 ) AND ( (node.status <> 0) AND (node.type in ('story')) )ORDER BY node_created_minute ASC, node_type ASC LIMIT 0, 3 in /var/www/html/notespress6/modules/views/includes/view.inc on line 731.

but only when I log on site using the "cliente" role.

In Storm's sub-modules like stormganization, to functions called [...]_rewrite_where_sql sometimes receive n as $primary_table parameter: and it is correct in the way the $query parameter contains a sql string with n alias for table node.

I made a long debug and now I think that all the queries in Storm's sub-modules have to be changed, they should more use the n alias for node table.

Any suggestions?

Thanks a lot.

Comments

iohannis’s picture

I have the same problem. Would be good to get the storm queries updated, or get another fix to the problem.

Roberto Gerola’s picture

This should be fixed on dev.
If someone could test it and help me to debug it, I'd really appreciate it.

Thanks.

gianfrasoft’s picture

Status: Active » Fixed

Yes, it seems to go.

Thanks a lot, Roberto. Buon lavoro.

Gianfranco.

Status: Fixed » Closed (fixed)

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