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 : http://blackberryempire.com/forum/an...urchasing-apps
IP Address : 117.102.50.83
Username : Guest
Classname : vB_Database_MySQLi
Any idea?
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 : http://blackberryempire.com/forum/an...urchasing-apps
IP Address : 117.102.50.83
Username : Guest
Classname : vB_Database_MySQLi
Any idea?
Comment