(RADIATOR) Invalid object name 'inerted'

[Michel Bant]

Hello all,   We try to write back some accounting to our SQL database.   We receive the following error message: Fri Jun 13 16:16:46 2003: DEBUG: do query is: 'insert into ACCOUNTING (USERNAME)  values ('qwerty')':   DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1) at c:/P erl/site/lib/Radius/SqlDb.pm line 219. Fri Jun 13 16:16:46 2003: ERR: do failed for 'insert into ACCOUNTING (USERNAME) values ('qwerty')': [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid objec t name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1) DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1) at c:/P erl/site/lib/Radius/SqlDb.pm line 219. Fri Jun 13 16:16:46 2003: ERR: do failed for 'insert into ACCOUNTING (USERNAME) values ('qwerty')': [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid objec t name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1) Fri Jun 13 16:16:46 2003: DEBUG: Accounting accepted   Part of the script that we use to take care of the accounting is:   <Realm DEFAULT>               <AuthBy SQL>                                     AuthSelect        select e.password, e.timeleft, e.timelimit, e.defaultroute from users e where e.username = %0 and dialaccess=1                         DBSource         dbi:ODBC: ***                         DBUsername    ***                        DBAuth            ***                                                   AuthColumnDef 0, Password, check                                     AccountingTable            ACCOUNTING                         AcctColumnDef  USERNAME,User-Name                         AcctColumnDef  ACCTSTATUSTYPE,Acct-Status-Type                         AcctColumnDef  ACCTDELAYTIME,Acct-Delay-Time,integer                         AcctColumnDef  ACCTINPUTOCTETS,Acct-Input-Octets,integer                         AcctColumnDef  ACCTOUTPUTOCTETS,Acct-Output-Octets,integer                         AcctColumnDef  ACCTSESSIONID,Acct-Session-Id                         AcctColumnDef  ACCTSESSIONTIME,Acct-Session-Time,integer                         AcctColumnDef  ACCTTERMINATECAUSE,Acct-Terminate-Cause                         AcctColumnDef  NASIDENTIFIER,NAS-Identifier                         AcctColumnDef  NASPORT,NAS-Port,integer                         AcctColumnDef  NASPORTTYPE,NAS-Port-Type                         AcctColumnDef  MULTILINKID,Ascend-Multilink-ID                         AcctColumnDef  FRAMEDIPADDRESS,Framed-IP-Address                         AcctColumnDef  CALLINGID,Calling-Station-Id                         AcctColumnDef  Calledstation_ID,Called-Station-Id                                     </AuthBy> </Realm>   Does anyone know what we did wrong?   Kind regards, Michel Bant