Hello,

I installed Drupal, installed OG and installed localizer.

After surfing around the Drupal.org page I wanted to try out uieforum. Installed it but did not get satisfied so I uninstalled it and switched back to the original Forum.

I created containers and Forums and now when I enter the forum it appears but right above it I can see around 10 times 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 = 154 ) ORDER BY ncs.last_comment_timestamp DESC LIMIT 0, 1 in /var/www/xxxxxxxxxxxxxxxxxx/includes/database.mysql.inc on line 172.

Questions (since I want to learn about these things I haven't got only one)
1. What is this error
2. How did I cause it
3. What can I do about it?

Thank you for your support in advance.

By the way. A clean reinstall of Drupal is not possible since the site is already live and users have signed up.

Comments

Kirishita’s picture

Kirishita commented

Nobody knows something?

liam mcdermott’s picture

liam mcdermott commented

I don't know what the problem is, searching around there seems to be some problem with the multiple domain module. Are you using that?

Kirishita’s picture

Kirishita commented

Hey

Yes I'm using this module since it promied an easy way out for a multible Domian page

keith.smith’s picture

keith.smith commented
Project: Drupal core » Multiple Domains
Version: 5.5 » 5.x-1.x-dev
Component: forum.module » code
Priority: Critical » Normal
Status: Active » Closed (duplicate)

It isn't your fault -- apparently there's an issue with multidomain where one of the table aliases it used conflicts with some other aliases. There is a patch for this here: http://drupal.org/node/161087.

This handbook page (http://drupal.org/patch/apply) should have more information on applying a patch.

I'm going to move this out of the Drupal criticals queue and into the Multidomain queue and mark it as a duplicate. http://drupal.org/node/161087 is probably where you need to followup.

betz’s picture

betz commented
Status: Closed (duplicate) » Fixed

Status: Fixed » Closed (fixed)

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