BIGINT UNSIGNED value is out of range

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • heredia21
    Senior Member
    • Oct 2012
    • 208
    • 5.0.X

    BIGINT UNSIGNED value is out of range

    I keep getting the following database error:

    Invalid SQL:
    CREATE TABLE forumtmp_nodestats AS SELECT node.parentid AS nodeid, count(nv.nodeid) AS tmpvisitors,
    nv.totalcount - IFNULL(existing.replies, 0) AS tmpreplies FROM forumnodevisits AS nv
    INNER JOIN forumnode AS node ON node.nodeid = nv.nodeid
    LEFT JOIN forumnodestatreplies AS existing ON existing.nodeid = node.parentid
    WHERE nv.dateline >= 1431216000 AND nv.dateline < (1431216000 + 86400)
    GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/;

    MySQL Error : BIGINT UNSIGNED value is out of range in '(`dbname_forum`.`nv`.`totalcount` - ifnull(`dbname_forum`.`existing`.`replies`,0))'
    Error Number : 1690
    Request Date : Thursday, July 2nd 2015 @ 11:01:29 AM
    Error Date : Thursday, July 2nd 2015 @ 11:01:30 AM
    Script : http:///forum/ajax/apidetach/cron/run
    Referrer : http://blackberryempire.com/forum/an...urchasing-apps
    IP Address : 117.102.50.83
    Username : Guest
    Classname : vB_Database_MySQLi

    Any idea?
    BlackBerry Empire #1 BlackBerry news site and BlackBerry forum.
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    This is a known but uncommon issue and we're working to fix it.

    See these JIRAs:



    As a workaround, you can truncate that table to continue on.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...