MySQL Error: BIGINT UNSIGNED value is out of range

[RoelVB]

Since a day or two I'm constantly getting this error (every hour):

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        : [URL="http://ajax/api/cron/run"]http:///ajax/api/cron/run[/URL]

This must be a very large number to be out of range for a unsigned bigint.

[Wayne Luke]

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