MyBB Community Forums

This is the error message that I get. Any help?

Fatal error: Uncaught mysqli_sql_exception: BIGINT UNSIGNED value is out of range in '(vfroot_forums.mybbhm_users.timeonline + -(3521))' in /home/vfroot/public_html/forums/inc/db_mysqli.php:335 Stack trace: #0 /home/vfroot/public_html/forums/inc/db_mysqli.php(335): mysqli_query(Object(mysqli), 'UPDATE mybbhm_u...') #1 /home/vfroot/public_html/forums/inc/db_mysqli.php(378): DB_MySQLi->query('UPDATE mybbhm_u...', 0, 1) #2 /home/vfroot/public_html/forums/inc/functions.php(234): DB_MySQLi->write_query('UPDATE mybbhm_u...') #3 /home/vfroot/public_html/forums/inc/class_core.php(616): run_shutdown() #4 [internal function]: MyBB->__destruct() #5 {main} thrown in /home/vfroot/public_html/forums/inc/db_mysqli.php on line 335

Duplicate content:

https://community.mybb.com/thread-240689.html

Wrong forum too, I'd say.

What exactly are you doing that this error appears?

(2024-04-07, 04:07 PM)Tomik Wrote: [ -> ]What exactly are you doing that this error appears?

Pretty much any page load. Even see it on login. 

I think it has something to do with timeonline field being set to 0

---

(2024-04-07, 08:48 AM)nixer55 Wrote: [ -> ]Duplicate content:

https://community.mybb.com/thread-240689.html

Wrong forum too, I'd say.

Well, which forum would you say it should be posted in. Also the post you linked to is a completely different issue.

(2024-04-07, 05:24 PM)moda253 Wrote: [ -> ]I think it has something to do with timeonline field being set to 0

It looks the added value computed at https://github.com/mybb/mybb/blob/mybb_1...n.php#L203 is negative, which may happen if the timestamp mybb_users.lastactive is in the future.

You can see if this is the case with a SQL query:

SELECT lastactive FROM mybbhm_users WHERE lastactive > UNIX_TIMESTAMP();

Clearing cookies (mybb[lastactive] in particular) may help.