MyBB Community Forums
ERROR: BIGINT UNSIGNED value is out of range - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: ERROR: BIGINT UNSIGNED value is out of range (/thread-171969.html)



ERROR: BIGINT UNSIGNED value is out of range - kino32al - 2015-06-15

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


RE: ERROR: BIGINT UNSIGNED value is out of range - kino32al - 2015-06-17

please... I'm totally frustrated Sad


RE: ERROR: BIGINT UNSIGNED value is out of range - Ad Bakker - 2015-06-17

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


RE: ERROR: BIGINT UNSIGNED value is out of range - kino32al - 2015-06-19

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