Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

The best choice for your web site host, email hosting, and domain registration.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Users Online Mo...  UsersOnline Not Populating
Previous Previous
 
Next Next
New Post 3/29/2008 4:18 AM
User is offline Sebastian Leupold
14295 posts
www.deutschnetnuke.de
1st Ranked












Re: UsersOnline Not Populating 

it looks like you are using a non-empty ObjectQualfier and I assume, that the installation procedure for the 3rd party module lacks of OQ support, Check your database for a stored procedure dbo.GetOnlineUserStatistics or dbo.UOR_GetOnlineUserStatistics and rename it to dbo.DS_UOR_GetOnlineUserStatistics


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 3/29/2008 8:12 AM
User is offline AngelesCityPortal
28 posts
www.angelescityportal.com
10th Ranked


Re: UsersOnline Not Populating 

Hi Sebastian

I looked in the stored procedures and I have two entries and the owner on both are dbo

  • DS_UOR_GetOnlineUserStatistics
  • GetOnlineUserStatistics

The first one I assume is for the DNNspired module and the second one is the core module. Is there a conflict? Is that the problem? I am happy to use the core usersonline module, but have beenreading all of these posts trying to finid and answer to why it has stopped working and thought I would try the DNNspired module to see if it made any difference. Any ideas what I can, or should be doing?

 
New Post 3/29/2008 1:07 PM
User is offline Dave Dyer
69 posts
www.DNNSpired.com
10th Ranked






Re: UsersOnline Not Populating 

Sebastian,

I will post the solution on gemini, its been on my todo list for too long now :)

Angeles,

I am not sure what is going wrong. You are correct the stored procedure "DS_UOR_GetOnlineUserStatistics" is for the DNNSpired module, and GetOnlineUserStatics is for core module.   Both can exist without conflict.  It is odd that the error you recieved read that the stored procedure did not exist, but you have the stored produce in your list.   May I suggest you try to execute the store procudure through the managment studio. 


 
New Post 3/30/2008 12:07 AM
User is offline AngelesCityPortal
28 posts
www.angelescityportal.com
10th Ranked


Re: UsersOnline Not Populating 

I have shrank my DB, cleared all logs, and tried everything people have suggested but still no luck. The UsersOnline table does contain users so it is populating the table, but cannot get the core module to display the data or the DNNspired module to work at all. The core module is stuck at the number of users since it stopped working even though many have joined, and the latest user stuck, and everything else is zero now

Not sure how to execute it from the management studio. SQL command?

 
New Post 3/30/2008 10:56 AM
User is offline AngelesCityPortal
28 posts
www.angelescityportal.com
10th Ranked


Re: UsersOnline Not Populating 

When I try to execute the stored procedure by clicking on the Generate SQL button in the MSSQL Manager I get the following error.

Error 424
 

Object required

SQLDMO must be installed on your server so that this option is available.

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Users Online Mo...  UsersOnline Not Populating
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Overlook Technology
Website Development, DotNetNuke Consulting, Module Development, Portal Management
OverlookTechnology.com
DeutschNetNuke = DotNetNuke in German
DeutschNetNuke provides all DotNetNuke related services in German (and English).
www.DeutschNetNuke.de
The Standard in Senior Housing Information
SNAPforSeniors provides consumers with free online resources to assist them with their search for senior housing
www.snapforseniors.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP