(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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020613/ced1f605/attachment.html>