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
Comment #1
iohannis commentedI have the same problem. Would be good to get the storm queries updated, or get another fix to the problem.
Comment #2
Roberto Gerola commentedThis should be fixed on dev.
If someone could test it and help me to debug it, I'd really appreciate it.
Thanks.
Comment #3
gianfrasoft commentedYes, it seems to go.
Thanks a lot, Roberto. Buon lavoro.
Gianfranco.