[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: POSTGRESQL ERROR -- please help --- dialup_admin ERROR
From:       "apellido jr., wilfredo p." <apellido () mactan ! ph>
Date:       2004-06-29 10:55:35
Message-ID: 001401c45dc7$ad64b570$8616b1cb () cache
[Download RAW message or body]

Hello guys, those error is from dialup_admin/user_finger.php3 and
dialup_admin/nas_admin.php3.

Jun 29 18:54:44 diameter postgres[298]: [3-1] ERROR:  column
"radacct.acctstarttime" must appear in the GROUP BY clause or be used in an
aggregate function

Jun 29 18:55:16 diameter postgres[303]: [2-1] ERROR:  syntax error at or
near "ORDER" at character 16




----- Original Message ----- 
From: "apellido jr., wilfredo p." <apellido@mactan.ph>
To: <freeradius-users@lists.freeradius.org>
Sent: Tuesday, June 29, 2004 12:33 PM
Subject: POSTGRESQL ERROR -- please help


> Hello guys just posting a day ago, maybe nothing  notice so im post it
again
> bout the error i've encounter running freeradius-1.0.0-pre2 .
>
> Jun 27 20:12:47 radius postgres[10318]: [2-1] ERROR:  column
> "radacct.acctstarttime" must appear in the GROUP BY clause or be used in
an
> aggregate function
>
> Now im trying to setup freeradius again using freeradius-1.0.0-pre3 and
> still i got the same error.
>
> Jun 29 12:16:59 diameter postgres[28662]: [1-1] ERROR:  column
> "radacct.acctstarttime" must appear in the GROUP BY clause or be used in
an
> aggregate function
>
> Although when testing radtest the user can still authenticate. Is their
> anyone encounter this error? Is there anything that im missing? Im newbie
of
> using postgresql just switching from mysql. Any help or comment highly
> appreciated. Thanks
>
>
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]