Re: [Emerald] Problem on displaying logged in users. (fwd)
Dale E. Reed Jr. ( (no email) )
Fri, 25 Jun 1999 12:42:14 -0700
"Michael Vincent K. Pozon - CompE" wrote:
> but still there are some users that are invisible in the ONLINE tab ... i
> think they are not billed for their usage ...
> for your info , I'm using :
> U.S. Robotics
> Total Control (tm) NETServer Card V.34 V3.3.3
> Build date: Nov 27 1996
> Build time: 17:06:59
> Network Interface Card: Ethernet (24)
> Packet Bus Circuit : Standard
> Licensed for 60 ports.
> my emerald version is 2.5.261
> SQL version is 6.5
> what gives ?
You might be running into a problem with duplicate accounting records,
are not really duplicate records. USR seems to re-use thier
values too frequently, which can cause duplicate checking problems.
One way to patch this is to modify your Primary key on your Calls table,
and Add the username field to it. This gives a less probably duplicate
and will usually correct the problem.