On Tue, 6 Jul 2004, apellido jr., wilfredo p. wrote:
> Hello guys, got this error under Online Users (user_finger.php3)
>
> Jul 6 13:22:46 diameter postgres[496]: [2-1] ERROR: column
> "radacct.acctstarttime" must appear in the GROUP BY clause or be used in an
> aggregate function
>
>
> FreeRADIUS Version 1.0.0-pre3, for host , built on Jul 6 2004 at 01:54:36
> Freebsd 4.18
> psql (PostgreSQL) 7.4.3
>
>
> Any suggestion is highly appreciated... Thanks
Try this simple patch. Please report results.
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
Index: user_finger.php3
===================================================================
RCS file: /source/radiusd/dialup_admin/htdocs/user_finger.php3,v
retrieving revision 1.21
diff -u -r1.21 user_finger.php3
--- user_finger.php3 18 Jun 2004 13:01:57 -0000 1.21
+++ user_finger.php3 6 Jul 2004 13:55:25 -0000
@@ -86,7 +86,8 @@
"SELECT DISTINCT
username,acctstarttime,framedipaddress,callingstationid
FROM $config[sql_accounting_table] WHERE
acctstoptime IS NULL AND nasipaddress = '$name_data' $extra
$sql_extra_query
- GROUP BY username ORDER BY acctstarttime;");
+ GROUP BY username,acctstarttime,framedipaddress,callingstationid
+ ORDER BY acctstarttime;");
if ($search){
$now = time();
while($row = @da_sql_fetch_array($search,$config)){
