active users page

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...

Edited by eaglesexec

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.

Edited by Trevni

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!

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.