Unfortunately it doesn't work on Drupal 4.6.2: You have an error in your SQL syntax near 'ON n.nid = c.nid WHERE c.status = 0 GROUP BY c.nid ORDER BY the_time DESC LIMIT' at line 1 query: SELECT c.nid, n.title, COUNT(c.nid) AS comment_count, MAX(c.timestamp) AS the_time FROM comments c JOIN node n ON n.nid = c.nid WHERE c.status = 0 GROUP BY c.nid ORDER BY the_time DESC LIMIT 30 in includes/database.mysql.inc on line 66.

Comments

Prometheus6’s picture

Prometheus6 commented
Status: Active » Closed (duplicate)

http://drupal.org/node/27522

nsk’s picture

nsk commented

FYI: My MySQL is 3.23 and my PHP is 4.3.10.

Prometheus6’s picture

Prometheus6 commented

I still have no way of identifying the conflict. I don't know what other modules you have installed. There's simply not enough information for me to work with.

nsk’s picture

nsk commented

modules: Excerpt, Hall Of Fame, Amazon items, Print. What information do you need?