RE: (RADIATOR) Invalid object name 'inerted'

[Dave Kitabjian]

Hmm. Do you mean other than the fact that “inserted” is spelled wrong, presumably in a trigger attached to the ACCOUNTING table?   Dave   -----Original Message----- From: Michel Bant [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:22 AM To: [EMAIL PROTECTED] Subject: (RADIATOR) Invalid object name 'inerted'   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