Closed (fixed)
Project:
Multiple Domains
Version:
5.x-1.x-dev
Component:
code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
21 Jul 2007 at 16:13 UTC
Updated:
18 Nov 2008 at 06:21 UTC
Jump to comment: Most recent file
Comments
Comment #1
Gábor Mayer commented... with multiple domains module
Comment #2
wvlgen commentedI have this problem when I want to display "newsletters".
* user warning: Not unique table/alias: 'tn' query: SELECT COUNT(DISTINCT(n.nid)) FROM ----node n INNER JOIN ----term_node tn ON n.nid = tn.nid INNER JOIN ----term_node tn ON tn.nid = n.nid WHERE (tn.tid = 84) AND ( tn.tid IN (69,75,71,74,72,68,73) AND n.status = 1) in /usr/home/---t/public_html/includes/database.mysql.inc on line 172.
* user warning: Not unique table/alias: 'tn' query: SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM ----node n INNER JOIN ----term_node tn ON n.nid = tn.nid INNER JOIN ----term_node tn ON tn.nid = n.nid WHERE (tn.tid = 84) AND ( tn.tid IN (69,75,71,74,72,68,73) AND n.status = 1 ) ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 5 in /usr/home/----/public_html/includes/database.mysql.inc on line 172.
(prefix replaced by ----).
Comment #3
swe3tdave commentedFrom dimanjy23 in http://drupal.org/node/166610:
Works perfectly, changing every reference of tn to txn in multipledomain.module corrected the problem for me..
Comment #4
wayland76 commentedOk, but why should we have to. Here's a patch against the DRUPAL-5 branch that does that (except it's multidomain_tn, not txn; that way, it's unlikely to ever conflict with anything ever again).
Comment #5
wayland76 commentedI should've marked this "Ready to be committed"
Comment #6
summit commentedHi,
Is this module still maintained?
If so please commit this patch.
greetings,
Martijn
Comment #7
betz commentedPatch committed to the development snapshot.