[Help-gnu-radius] (no subject)

[David Friedman]

I'm a bit confused by these errors:
Feb 20 22:04:34: Acct.error: MYSQL Error (-1): Cannot Query:UPDATE calls SET 
status=,acct_session_time=18,acct_input_octets=6721,acct_output_octets=12153,connect_term_reason=45
 WHERE user_name='michele' AND status = 1 AND 
acct_session_id='BFEF7BFE:000CE862'
Feb 20 22:04:34: Acct.error: MYSQL Error: query UPDATE calls SET 
status=,acct_session_time=18,acct_input_octets=6721,acct_output_octets=12153,connect_term_reason=45
 WHERE user_name='michele' AND status = 1 AND 
acct_session_id='BFEF7BFE:000CE862'

# Query to be used on session end
acct_stop_query      UPDATE calls \
                     SET status=%C{Acct-Status-Type},\
                         acct_session_time=%C{Acct-Session-Time},\
                         acct_input_octets=%C{Acct-Input-Octets},\
                         acct_output_octets=%C{Acct-Output-Octets},\
                         connect_term_reason=%C{Acct-Terminate-Cause} \
                     WHERE user_name='%C{User-Name}' \
                       AND status = 1 \
                       AND acct_session_id='%C{Acct-Session-Id}'

mysql> desc calls;
+---------------------+--------------------+------+-----+---------------------+-------+
| Field               | Type               | Null | Key | Default             | 
Extra |
+---------------------+--------------------+------+-----+---------------------+-------+
| status              | int(5)             |      | MUL | 0                   | 
      |
| user_name           | varchar(32) binary |      | MUL |                     | 
      |
| event_date_time     | datetime           |      |     | 0000-00-00 00:00:00 | 
      |
| nas_ip_address      | varchar(17)        |      |     | 0.0.0.0             | 
      |
| nas_port_id         | int(10)            | YES  |     | NULL                | 
      |
| acct_session_id     | varchar(17)        |      |     |                     | 
      |
| acct_session_time   | int(10)            | YES  |     | NULL                | 
      |
| acct_input_octets   | int(10)            | YES  |     | NULL                | 
      |
| acct_output_octets  | int(10)            | YES  |     | NULL                | 
      |
| connect_term_reason | int(10)            | YES  |     | NULL                | 
      |
| framed_ip_address   | varchar(17)        | YES  |     | NULL                | 
      |
| called_station_id   | varchar(32)        | YES  |     | NULL                | 
      |
| calling_station_id  | varchar(32)        | YES  |     | NULL                | 
      |
+---------------------+--------------------+------+-----+---------------------+-------+
13 rows in set (0.00 sec)

mysql> 

Any idea how to fix this?  Thanks.
-- 
David Friedman (address@hidden)
www.irctoo.net - IRCtoo... because it's not just irc.