PDA

View Full Version : MySQL Error : BIGINT UNSIGNED value is out of range


heredia21
07-25-2015, 09:49 PM
I keep getting the following database error, any idea?

Database error in vBulletin 5.1.8:

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 >= 1434153600 AND nv.dateline < (1434153600 + 86400)
GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from
cron **/;

MySQL Error : BIGINT UNSIGNED value is out of range in
'(`bbempire_forum`.`nv`.`totalcount` -
ifnull(`forum`.`existing`.`replies`,0))'
Error Number : 1690
Request Date : Saturday, July 25th 2015 @ 06:07:13 PM
Error Date : Saturday, July 25th 2015 @ 06:07:13 PM
Script : http:///forum/ajax/apidetach/cron/run
Referrer :
http://blackberryempire.com/forum/site-related/45465-download-blackberry-empire-forum-app
IP Address : 5.237.202.7
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :

Lynne
07-27-2015, 02:16 PM
This is a bug that is unresolved at this point - http://tracker.vbulletin.com/browse/VBV-14724 (Note, you must first login to the vbulletin.com forums as a Licensed User before you may see the Jira issue.)