Re: Error Adding accounts

Dale E. Reed Jr. ( (no email) )
Sat, 30 May 1998 23:15:48 -0700

Robert Boyle wrote:
> At 11:34 AM 5/30/98 -0700, you wrote:
> >AS I have noted many times, do NOT use 2.2.42 unless you are
> >directed to. 2.2.38 is the latest 2.2. for general use.
> I understood that it fixed billing problems. We have been having problems

Actually, it fixed ONE billing problem, which was applying payments.
If you are not having problems applying payments, don't use 2.2.42.

> for quite a while now where invoices are not generated. We need to delete
> the MBR and recreate it. Nothing else works. I KNOW that the expire and

If you send me your DB Information and an example user who will
not bill, I'll show you why it will not.

> 11) Options: 576

512: Stop Records Only
64: Variable Login Limits

> SQL Statement: UPDATE CallsOnline Set Username='pdi',AcctStatusType=1,
> CallDate=GetDate(), FramedAddress='' WHERE
> NASIdentifier='' and NASPort=20 AND (DateAdd(Second,
> 0-i.AcctDelayTime, i.CallDate) >= CallDate OR CallDate IS NULL)
> ODBC Error:37000:107:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'i' does
> not match with a table name or alias name used in the query.
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> What is this statement's i supposed to refer to? CallsOnline doesn't work
> and the Calls table only gets new additions for the first 30-60 seconds
> that RadiusNT is running. Any ideas? I have dropped and recreated Calls and
> CallsOnline with the scripts included with the final 2.5 distribution. TIA!

This was corrected in 2.5.116 and higher (2.5.120 is the distribution
available right now). If you turn off the Stop records only, it will
work until you update the executable.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |