MyBB Community Forums

Hello! I am getting this error at the bottom of the page: MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1690 - BIGINT UNSIGNED value is out of range in '(galaxyf1_mbb1.mbb_users.timeonline + -(2882509139))'
Query:
UPDATE mbb_users SET lastactive='1412458156', timeonline=timeonline+-2882509139, lastip=X'adf53843' WHERE uid='1'
Please contact the MyBB Group for technical support.



Only staff members can see that. Please help.

You have to contact your host.

Did you modify any files? ACP->Tools->File Verification.

(2014-10-06, 05:11 PM)dragonexpert Wrote: [ -> ]Did you modify any files?  ACP->Tools->File Verification.

No.

What I'm guessing is the value of timeonline would be negative, but since the field timeonline is unsigned, it only allows a positive number.

Are you using any plugins? If so, please list them.

Any news on this one? I have a brand new install doing this.
No mods, no themes. ver 1804., PHP is uptodate, nginx/cpanel versions fine.. nothing else i can think of.

Line 182 inc/class_session.php

It seems Installatron incorrectly installs MyBB, inserting absurdly hight values into the uid 1 account's regdate, lastactive and lastvisit fields.

Easy way to fix is to jump into phpMyAdmin and insert sane values.

I've lodged a ticket upstream, hopefully they fix that issue.