* 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 = 6) AND ( tn.tid IN (2) AND n.status = 1) in /home/www/drupal/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 = 6) AND ( tn.tid IN (2) AND n.status = 1 ) ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /home/www/drupal/includes/database.mysql.inc on line 172.
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | multidomain_fix_query.txt | 935 bytes | wayland76 |
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.