Print Page | Close Window

active_users.inc problem

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=1915
Printed Date: 31 March 2026 at 3:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: active_users.inc problem
Posted By: USSeR
Subject: active_users.inc problem
Date Posted: 19 April 2003 at 9:54am

Hi.

I think I messed up the database a little. Can't figure what's wrong there.

Here's my problem. When the script gets to this query (in active_users.inc file):

'Clean up old users
'Initilse sql statement
If strDatabaseType = "SQLServer" Then
 strSQL = "EXECUTE wwfSpDeleteActiveUser"
Else
 strSQL = "DELETE FROM tblActiveUser WHERE tblActiveUser.Active < Now() - 0.0070;"
End If

'Detlete from database
adoCon.Execute(strSQL)

When the query is executed I'm getting this:

Microsoft JET Database Engine error '80004005'

The search key was not found in any record.

/forum/active_users.inc, line 196

 

So I temporarily commented the Execute statement out.

What's could be wrong? Please help.




Replies:
Posted By: USSeR
Date Posted: 19 April 2003 at 10:17am

I think that the DB has become corrupted.

I ran the Compact and repair and it fixed it.

Can you tell me why this had happened?

It's Access with about 950 members.



Posted By: WebWiz-Bruce
Date Posted: 19 April 2003 at 10:45am

Access sometimes has problems with the amount of updates needed for the active users feature.

If you are running version 7 then you can disable the active users feature from the admin area, if you are running version 6.x then it will probally be worth upgrading in a few weeks when the full version of version 7 is released and disabling the active users feature to prevent this form happening again.



-------------
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: USSeR
Date Posted: 20 April 2003 at 9:55am
Thanks 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