Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [Error Message] MySQL
#1
Not Solved
I've got a error message with MySQL i tried Deactivating & activating plugins and make log out and log in but still


Please help Sad

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1690 - BIGINT UNSIGNED value is out of range in '(`u633825158_xeno`.`mybb_users`.`timeonline` + -(481219))'
Query:
UPDATE mybb_users SET lastactive='1480092254', timeonline=timeonline+-481219, lastip=X'4f9788c9' WHERE uid='1'
Reply
#2
Not Solved
is it for a fresh forum ? have you used automatic installer for setting up your forum ? can we have your forum url ..
Reply
#3
Not Solved
i used the steps when i downloaded mybb i dont know what means with automatic installer

forum url: xe-mta.pe.hu/forum
Reply
#4
Not Solved
Quote:automatic installer
Something like Softaculous, Installatron, etc.--"one-click installers".


Anyways, what's happening is something is making MyBB subtract 481219 from a user's timeonline value (number of seconds(?) that a user has been online on your forum). This is somehow making the value go negative, which isn't allowed with unsigned integers.

Another thing that surprises me is that the column supposedly holds a bigint value, when the column types shown in the installer files suggest it should be regular unsigned integers. Do you have any plugins installed?
PGP Key (Fingerprint: 23B6 F4C0 FE2D 45AA 61A0 1E86 DB87 09DC DD87 6E40)
Reply
#5
Not Solved
there is any fix? i didint edited nothing it happened today yesterday it was good
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)