Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsUsers OnlineUsers OnlineOnline Now section duplicating entries?Online Now section duplicating entries?
Previous
 
Next
New Post
11/24/2008 10:49 AM
 

We are using DNN 04.03.05 and UsersOnline 03.01.00

We changed our site to use active directory, integrated access authentication. We are no longer required to log in, we are automatically logged in via our active directory credentials.

In the users online section, it looks likes this, everyone except for me is duplicated. I am a superuser - not sure if that makes a difference. I modified the names for confidentiality, but you can still see the duplication. Do you know why this is happening? Do I need to modify a setting?

Online Now Online Now:
01: ES\poz
02: ES\poz
03: ES\gra
04: ES\gra
05: ES\Rig
06: ES\Rig
07: ES\Grie
08: ES\Grie
09: ES\Scha

 
New Post
11/26/2008 5:23 AM
Accepted Answer 

Dawn, please log the error into the public issue tracker at support.dotnetnuke.com. ATM I am not aware, what causes this issue, there seems to be a glitch in the underlying sproc "getOnlineUsers". If you are firm in SQL, try to execute it manually from a database management tool and check out the statements.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/2/2008 2:09 PM
 

Thank you, I posted to the issue tracker and I tested out the SQL. This is what I found:

The stored procedure getting the users GetOnlineUsers had a select like this:

SELECT * FROM UsersOnline UO

            INNER JOIN vw_Users U ON UO.UserID = U.UserID

            INNER JOIN UserPortals UP ON U.UserID = UP.UserId

      WHERE  UP.PortalID = @PortalID

Which looks fine, but what was happening was that the view was pulling the users’ instance in more than one portal. It was getting the user from portal 0 and 2, even though the passed in parameter for the portal id was 2. That was why duplicates appeared. I modifed it to be (notice the second condition added in the where clause):

SELECT *  FROM UsersOnline UO

            INNER JOIN vw_Users U ON UO.UserID = U.UserID

            INNER JOIN UserPortals UP ON U.UserID = UP.UserId

      WHERE  UP.PortalID = @PortalID AND U.portalid = @PortalID

And now duplicates no longer appear.

 
New Post
12/2/2008 3:20 PM
 

Please log this issue and fix into the public issue tracker (2nd from top) at support.dotnetnuke.com, Thank you!


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsUsers OnlineUsers OnlineOnline Now section duplicating entries?Online Now section duplicating entries?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out