I received the following errors upon installing this module. I am running MySQL 4.1.x and was able to get rid of the errors by changing the ORDER BY clause to use the aliased name of 'count' rather than the function COUNT(*).

* user warning: Invalid use of group function query: SELECT COUNT(*) AS count FROM tbj_node GROUP BY uid ORDER BY count(*) DESC LIMIT 1 in /opt/www/drupal-5.1.int.thatsbj.com/includes/database.mysql.inc on line 172.
* user warning: Invalid use of group function query: SELECT COUNT(*) AS count FROM tbj_comments GROUP BY uid ORDER BY count(*) DESC LIMIT 1 in /opt/www/drupal-5.1.int.thatsbj.com/includes/database.mysql.inc on line 172.

Comments

sanduhrs’s picture

Assigned: Unassigned » sanduhrs
Status: Active » Fixed

Fixed that in CVS.
Thanks.

Anonymous’s picture

Status: Fixed » Closed (fixed)