Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
another not ansi error when calling taxonomy "and" (index.php?and=1,3). even two:
user error: 'n.type' isn't in GROUP BY query: SELECT n.nid, type, count(*) AS c FROM node n LEFT JOIN term_node r ON n.nid = r.nid WHERE tid IN ('1','3') AND status = '1' GROUP BY n.nid HAVING c = 2 ORDER BY static DESC, created DESC LIMIT 0, 10
user error: Unknown column 'c' in 'having clause' query: SELECT COUNT(*) FROM node n LEFT JOIN term_node r ON n.nid = r.nid WHERE tid IN ('1','3') AND status = '1' GROUP BY n.nid HAVING c = 2 ORDER BY static DESC, created DESC
the code in question is node.module, line 1282.
Comments
Comment #1
ax CreditAttribution: ax commentedhttp://list.drupal.org/drupal-devel/2002-November/009245.html
Comment #2
ax CreditAttribution: ax commentedfixed in cvs with moshe's last taxonomy patch.