Solved: 5 Years, 9 Months, 3 Weeks ago ERROR: BIGINT UNSIGNED value is out of range
#1
Solved: 5 Years, 9 Months, 3 Weeks ago
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
Reply
#2
Solved: 5 Years, 9 Months, 3 Weeks ago
please... I'm totally frustrated Sad
Reply
#3
Solved: 5 Years, 9 Months, 3 Weeks ago
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).
Regards, Ad Bakker (NL)
Reply
#4
Solved: 5 Years, 9 Months, 3 Weeks ago
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)