SQL Errors revisited

Kurt Schafer ( (no email) )
Mon, 7 Jul 1997 16:08:37 -0400

I could use some help debugging the following SQL errors that are happening
to us over here.

<snip>
=============================================================
Checking for duplicate logins.

SQL Statement: Select Domain From RadRoams Where (UserName='patm' or
UserName='') and AcctStatusType=1

LOG: ODBC: SQLFetch Error: (S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'UserName'.

ODBC: SQLFetch Error: (S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'UserName'.
ODBC: SQLFetch Error: (S0022)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'UserName'.

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
RadConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID
AND rc.AccountID=3173

Loading radius defaults for this type...
=============================================================
This appears to be a result of the Roaming Servers options of Emerald
2.2.31. Is it safe to ignore these errors or should I look to update my
Emerald DB with the new tables ?

Also, authentication requests are yielding these:

=============================================================
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constra
int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
ODBC: SQLExecDirect Error 2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constra
int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
=============================================================

Ideas ??