Project:Multiple Domains
Version:5.x-1.x-dev
Component:code
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed (fixed)
Issue tags:Newbie

Issue Summary

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

#1

Nobody knows something?

#2

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?

#3

Hey

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

#4

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.

#5

Status:closed (duplicate)» fixed

#6

Status:fixed» closed (fixed)

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

nobody click here