I added the module and when I go to my forum, I get this message :

user warning: Not unique table/alias: 'tn' query: SELECT ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM node n INNER JOIN users u1 ON n.uid = u1.uid INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u2 ON ncs.last_comment_uid=u2.uid INNER JOIN term_node tn ON tn.nid = n.nid WHERE (tn.tid = 1) AND ( n.status = 1 AND n.type='forum' AND tn.tid = 3 ) ORDER BY ncs.last_comment_timestamp DESC LIMIT 0, 1 in /home/.../includes/database.mysql.inc on line 174.

It was not there prior to the install.

I had advanced forums enabled so I tried disabling it, same message. I have tried disabling this module and still see the same error message. I even tried deleting the module through ftp and still see the same thing.

Any ideas?

Thanks -
Janet

Comments

jbrauer’s picture

jbrauer commented
Status: Active » Closed (duplicate)

There is no table alias in the Forum Thread code so it must be coming from another module. This is also confirmed by the information that removing the module doesn't resolve this problem. http://drupal.org/node/161087 may be the solution to this issue.