Re: [GENERAL] freeradius postgresql sql query glitch

2009-12-07 Thread Josip Rodin
On Mon, Dec 07, 2009 at 10:02:39PM +, Adrian Klaver wrote: > > Mon Dec 7 13:19:01 2009 : Error: [ourlittle_sql] Couldn't update SQL > > accounting STOP record - ERROR: invalid input syntax for integer: "" > > > > accounting_stop_query = "UPDATE ${acct_table2} \ > > SET > > AcctSessionTim

Re: [GENERAL] freeradius postgresql sql query glitch

2009-12-07 Thread Adrian Klaver
- "Josip Rodin" wrote: > Hi, > > I've observed an SQL logging problem with FreeRADIUS (2.x) and > PostgreSQL > (8.1), on several different installations I occasionally get these > errors: > > Mon Dec 7 13:19:01 2009 : Error: [ourlittle_sql] Couldn't update SQL > accounting STOP record - ER

[GENERAL] freeradius postgresql sql query glitch

2009-12-07 Thread Josip Rodin
Hi, I've observed an SQL logging problem with FreeRADIUS (2.x) and PostgreSQL (8.1), on several different installations I occasionally get these errors: Mon Dec 7 13:19:01 2009 : Error: [ourlittle_sql] Couldn't update SQL accounting STOP record - ERROR: invalid input syntax for integer: "" s