(RADIATOR) Update not working

[Jaskaran Singh]

Hello If anyone can help me out with this question, I have a an Update Query which was working till 2 days back, but now has stopped working. This is the query <AuthBy SQL>                 Identifier  Block-Time-SQL         DBSource     dbi:mysql:test2:localhost         DBUsername   xxxxx         DBAuth       xxxxxx         DefaultSimultaneousUse 1           AuthSelect Select Time_Left from RADUSERS where User_Name='%n'         AuthColumnDef 0,Session-Timeout=Time_Left,reply                 AccountingTable RADUSERS         AcctSQLStatement Update RADUSERS set Time_Left=Time_Left -'%{Acct-Session-Time}' \                                          where User_Name='%n';     </AuthBy>   <Handler Request-Type = Accounting-Request>         Description Handler for Handling Accounting Requests from Students         AuthBy Block-Time-SQL </Handler>   but it doesn’t execute. I am also attaching a trace 4 along with it. Thu Jun 13 15:07:22 2002: DEBUG: Handling with Radius::AuthSQL Thu Jun 13 15:07:22 2002: DEBUG: Handling accounting with Radius::AuthSQL Thu Jun 13 15:07:22 2002: DEBUG: do query is: Update RADUSERS set Time_Left=Time_Left -'' where User_Name='';   Thu Jun 13 15:07:22 2002: DEBUG: Accounting accepted Thu Jun 13 15:07:22 2002: DEBUG: Packet dump:     Any Ideas what I am doing wrong ?????? Thanks   Jaskaran Singh University Systems & Security Fairleigh Dickinson University Teaneck, NJ 07666