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.
Alex Blauvelt
Online Gateway
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html