Closed (fixed)
Project:
User Activity
Version:
5.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
24 Jul 2007 at 09:39 UTC
Updated:
8 Aug 2007 at 09:48 UTC
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
Comment #1
sanduhrsFixed that in CVS.
Thanks.
Comment #2
(not verified) commented