Re: [Emerald] Time Online

Dale E. Reed Jr. ( (no email) )
Wed, 10 Feb 1999 13:21:16 -0800

Alexander Blauvelt wrote:
>
> Our calls online table seems to be working great, but the individual
> info under each sub account on the time online tab doesn't appear to
> work. Putting emerald in debug mode and then hitting update returns
> the following error.
>
> SQL Server Error: 207 Invalid column name 'AcctTerminateCause'.
> State=2, Severity=16.
>
> Pasting from the clibboard the SQL statement:
>
> Select Start=DateAdd(Second, (0-AcctSessionTime-AcctDelayTime),
> CallDate), (AcctSessionTime/60)+1, (AcctInputOctets/1000)+1,
> (AcctOutputOctets/1000)+1, Location, UserName, AcctTerminateCause,
> Server, NASPort, ConnectInfo From Calls, Servers Where
> (UserName='xxxxxx') and CallDate >= '990131' and CallDate <= '990228'
> and AcctStatusType=2 and NASIdentifier=IPAddress Order by Start
>
> It appears we're missing the column in the table.
>
> This is emerald 2.5.236. Started with a 2.1 database that was upgraded
> with to a 2.5 type database. This isn't crucial, however it would be
> nice to get it working.

Just add the AcctTerminateCause column to your Calls table (type int).
That should correct the problem.

-- 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

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