Print Page | Close Window

active users page

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1095
Printed Date: 30 March 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: active users page
Posted By: eaglesexec
Subject: active users page
Date Posted: 17 March 2003 at 11:04pm

ok i am running the access version and one day i downloaded the DB unto my computer to edit a few things manually in the tblAuthor but i never touched tblActiveUsers.

first i got this error:

 

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.

/forum/includes/active_users_inc.asp, line 130

 

and i commented out line 130.. rookie solution obviously.

and anyway now the active users table is not cleared when users leave the board.  basically now the number of users keeps increasing which is fake and they have sessions as long as 4000 minutes... anyway got any idea how to fix this? used to work fine before...




Replies:
Posted By: eaglesexec
Date Posted: 17 March 2003 at 11:54pm
version 7b3 btw...


Posted By: Trevni
Date Posted: 18 March 2003 at 1:07am
Sounds to me like the active users table was corrupted. I think the corruption accrued when you uploaded the db.

You should turn off the forum delete all the rows in the active users table and upload it. Turn the forum back on.

Hint: Makes you wonder why Borg warns us about using that feature with access database.


Edit: You can turn off the feature itself, and you don't have to turn the whole forum off then turn it back on when you have fixed the database.


Posted By: eaglesexec
Date Posted: 18 March 2003 at 1:36am
hmm yes i deleted the entries manually... but as long as i dont comment that line out on active_users_inc.asp i will keep getting the error and nothing will load. when i DO comment it out the old entries are still not deleted and a new mess is created... lol.


Posted By: eaglesexec
Date Posted: 18 March 2003 at 1:43am
hmm nvm i fixed it in the weirdest way imaginable. i downloaded a fresh copy of beta 3 and in the brand new database i copied all the tables BUT tblActiveUser and now everything back to normal.  woohoo!


Posted By: WebWiz-Bruce
Date Posted: 18 March 2003 at 6:34am
Compacting and repairing the database in Access also fixes this problem, but keep the active users function turned off in the admin area if you don't want it to happen again as access can't cope with the updates required for an active users list, unless you have a very quite board.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: eaglesexec
Date Posted: 18 March 2003 at 12:58pm
yea it never gets more than 5 users online though i must admit it never gets 0 users online either.... but it isnt giving me any errors so its cool... thanks for the heads up borg.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net