in the d5 1.3 version I get a warning when viewing "tasks"

"user warning: Not unique table/alias: 'na' query" and then a huge select query.
The part before the WHERE statement is:
SELECT COUNT(*) FROM ct_node AS n INNER JOIN ct_stormtask AS sta ON n.vid=sta.vid INNER JOIN ct_node_access na ON na.nid = n.nid INNER JOIN ct_node_access na ON na.nid = stormtask.nid

(ct_ is my prefix). It has 2 "na" aliases.

I do have OG installed, it might be related to that.

It is not possible to add a task.

Comments

Roberto Gerola’s picture

Category: bug » support

> ct_node_access na
This is due to node_access module, not storm.
nod_access adds itself to the sql two times.

P.S. : in my experience content_access works a little better (IMHO of course)

catorghans’s picture

oops, node access is not on my site anymore since a long time. Think I need some cleaning up (maybe a port to D6 might help, or break everything :) )

I'll test further with some clean installs.

Roberto Gerola’s picture

Status: Active » Closed (fixed)