The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
MySQL Error : BIGINT UNSIGNED value is out of range
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/si...pire-forum-app IP Address : 5.237.202.7 Username : Guest Classname : vB_Database_MySQLi MySQL Version : |
#2
|
||||
|
||||
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.)
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|