Announcement

Collapse
No announcement yet.

MySQL Error: BIGINT UNSIGNED value is out of range

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Error: BIGINT UNSIGNED value is out of range

    Since a day or two I'm constantly getting this error (every hour):
    Code:
    Database error in vBulletin 5.1.1:
     
                                Invalid SQL:
    CREATE TABLE tmp_nodestats AS SELECT node.parentid AS nodeid, count(nv.nodeid) AS tmpvisitors,
                                          nv.totalcount - IFNULL(existing.replies, 0) AS tmpreplies FROM nodevisits AS nv
                                          INNER JOIN node AS node ON node.nodeid = nv.nodeid
                                          LEFT JOIN nodestatreplies AS existing ON existing.nodeid = node.parentid
                                          WHERE nv.dateline >= 1404864000 AND nv.dateline < (1404864000 + 86400)
                                          GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/;
     
                                MySQL Error   : BIGINT UNSIGNED value is out of range in '(`deb15487_vb`.`nv`.`totalcount` - ifnull(`deb15487_vb`.`existing`.`replies`,0))'
                                Error Number  : 1690
                                Request Date  : Friday, July 11th 2014 @ 12:07:09 PM
                                Error Date    : Friday, July 11th 2014 @ 12:07:09 PM
                                                   Script        : http:///ajax/api/cron/run
    This must be a very large number to be out of range for a unsigned bigint.

  • #2
    You'll need to open a support ticket. I can't think of any reason why you're value is over 18,446,744,073,709,551,615
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment

    Related Topics

    Collapse

    Working...
    X