No announcement yet.

BIGINT UNSIGNED value is out of range

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 :
    IP Address :
    Username : Guest
    Classname : vB_Database_MySQLi

    Any idea?
    BlackBerry Empire #1 BlackBerry news site and BlackBerry forum.

  • #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


    Related Topics