$search = @da_sql_query($link,$config, "SELECT DISTINCT UserName,AcctStartTime,FramedIPAddress,CallingStationId FROM $config[sql_accounting_table] WHERE AcctStopTime IS NULL AND NASIPAddress = '$name_data' $extra GROUP BY UserName ORDER BY AcctStartTime;");
I test in psql of postgresql (command line) and this is error: radiusdb=# select distinct username,acctstarttime,acctstoptime,nasipaddress radiusdb-# from radacct radiusdb-# where acctstoptime is null radiusdb-# group by username order by acctstarttime; ERROR: Attribute radacct.acctstarttime must be GROUPed or used in an aggregate function help me to solve this error. Thanks a lot. Manh Cuong. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
