MyBB Community Forums

Full Version: ERROR: BIGINT UNSIGNED value is out of range
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi guys, i have looked for solution during all day, but i cant solve it Sad

when i log in as admin my forum say this:


Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1690 - BIGINT UNSIGNED value is out of range in '(u281987375_apeje.yykp_users.timeonline + -(2860577093))'Query:UPDATE yykp_users SET lastactive='1434390202', timeonline=timeonline+-2860577093, lastip=X'3e531a5b' WHERE uid='1'

my programming skills are zero  Huh Sad Sad Sad Sad Sad Sad

Help me please
please... I'm totally frustrated Sad
Can you go to your phpMyAdmin and look in the user databasetable what the column lastactive contains for your account?
The negative value you see is the query of this value calculated at line 182 of inc/class_session.php:

$timespent = TIME_NOW - $mybb->user['lastactive'];

so the problem must lie in $mybb->user['lastactive'] having a too high value (higher than TIME_NOW).
oh! thanks!

SOLVED i change the value "4928839192938472" for 35 (for example... really I do not know what I've done, but works )

thanks mate