MyBB Community Forums

Full Version: Reset/Rebuild - "Time spent online" ?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello you reading this,

I do now own a forum but the previous owner had a corrupted dedicated server. Therefor the time spent online somehow got messed up.

Now my question is "How do i reset/rebuild the Time Spent Online"
I think the best way to do this is to run a query on the database but I wouldn't really know how to do that without messing it up.

This is how it looks like in PhpMyAdmin -> http://i.imgur.com/hYGrR.png

Thank you for your time.

Regards,

Senethic
Please login to your admin control panel click on tools and maintance

Now look for recount and rebuild

Do the following

Recount Statistics
This will recount and update your forum statistics on the forum index and statistics pages.
N/A
(2012-10-21, 11:22 AM)david-w Wrote: [ -> ]Please login to your admin control panel click on tools and maintance

Now look for recount and rebuild

Do the following

Recount Statistics
This will recount and update your forum statistics on the forum index and statistics pages.
N/A

I tried what you did and it did not work.
The problem is that my Time Online Spent is corrupted.
Time spent online is updated frequently when a user visits a page. You'd need to reset the value to 0.

First, take a database backup. Then run this query on the database:

update mybb_users set timeonline='0';
(2012-10-21, 04:01 PM)Nathan Malcolm Wrote: [ -> ]Time spent online is updated frequently when a user visits a page. You'd need to reset the value to 0.

First, take a database backup. Then run this query on the database:

update mybb_users set timeonline='0';

Thank you so much!!!