[RadiusNT] Index or primary key can't contain a Null value.

Sean Herr ( Sean@YNC.NET )
Sat, 20 Feb 1999 09:24:43 -0600

Big problem, Radius crashed today because of the below issue. Is there a
work around for this? My Access database was 13 Meg last night, it is now
280 Meg we did not catch what was going on until customers started called
in.

Any ideas?

[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator)
in query expression '(sa.Login=''`l3j$h^BuC&D?f)`' or
sa.Shell=''`l3j$h^BuC&D?f)`') AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 and ma.Active<>0'.

I have a 35M logfile with this in it.

Sat Feb 20 09:11:14 1999: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain a Null value.
Sat Feb 20 09:11:14 1999: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain a Null value.
Sat Feb 20 09:11:14 1999: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain a Null value.
Sat Feb 20 09:11:14 1999: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain a Null value.
Sat Feb 20 09:11:14 1999: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain a Null value.
Sat Feb 20 09:11:14 1999: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain a Null value.
Sat Feb 20 09:11:14 1999: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain

Sean Herr
Director of Technical Operations
@YourNET Connection, Inc.
847-524-3910
http://www.ync.net

For more information about this list, including removal, please
see this URL: http://www.iea-software.com/maillist.html