After installing urllist.module on drupal 4.7.1 I get a MySQL error report every time the urllist page is requested. Message reads:
user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(node.nid), n.type, n.status, n.promote, n.changed, u.dst FROM query: SELECT n.DISTINCT(node.nid), n.type, n.status, n.promote, n.changed, u.dst FROM node n LEFT JOIN url_alias u ON u.src=CONCAT('node/',n.nid) in .... /database.mysql.inc on line 120
Perhap the security fix in 4.7.1 is causing the urllist.module to break?
Comments
Comment #1
deekayen CreditAttribution: deekayen commentedI'm unable to reproduce this, but I tweaked the query line you're getting the error message from. Please try http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/ur...
Comment #2
deekayen CreditAttribution: deekayen commentedClosing for non-response.