MyBB Community Forums

One of my member just got this error...

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

SQL Error:
1690 - BIGINT UNSIGNED value is out of range in '(hqforumx_hqforum.mybb_users.timeonline + -(9778))'
Query:
UPDATE mybb_users SET lastactive='1436258873', timeonline=timeonline+-9778 WHERE uid='20'
Please contact the MyBB Group for technical support.

How to fix this? I'm confused :s

Have you used an automated installer like Installatron?

A similar issue was reported and caused by it: http://community.mybb.com/thread-160813-...pid1145005

I dont understand what your saying im confused?

Can you see in the database table users what the timeonline for user 20 is?
This is the online time in seconds. Is this a normal value?
If so, what happens when this users logs in and out again?

It looks like a script such as Installatron or Softaculous botched the upgrade, and set register dates to something strange. Then when you're browsing, your last time online is stored in the database. Your account's register timestamp is greater than the current UNIX timestamp now, from what I gather, which means that you've been online for a total of -9778 seconds (about 2.5-3 hours).

A negative value is SIGNED (because there's a negative *sign*), and is (attempting) to be inserted to an UNSIGNED column (>=0; no negative signs allowed). Therefore, -9778 is out of the range of the column.

As said above, check in phpMyAdmin to see if what I suspect is true. If so, use something like http://www.timestampgenerator.com/ to set the regdate to something sane and less than the current timestamp.