Re: Error Adding accounts

Dale E. Reed Jr. ( (no email) )
Tue, 02 Jun 1998 00:59:33 -0700

Robert H. Clugston wrote:
>
> The Error Message I'm getting is:
>
> SQL Server Error: 213 Insert Error: column name or number of supplied
> value does not match table defination
> State=4 Severity =16

Is this with Emerald 2.2.42 or a different version?

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
> Sent: Saturday, May 30, 1998 11:16 PM
> To: emerald@iea-software.com
> Subject: Re: Error Adding accounts
>
> 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='208.148.112.193' WHERE
> > NASIdentifier='206.28.213.250' 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. (daler@iea-software.com)
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com