Database error in vBulletin 5.1.4:
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 >= 1414368000 AND nv.dateline < (1414368000 + 86400)
GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/;
MySQL Error : BIGINT UNSIGNED value is out of range in '(`<database>`.`nv`.`totalcount` - ifnull(`<database>`.`existing`.`replies`,0))'
Error Number : 1690
Request Date : Wednesday, December 24th 2014 @ 07:03:14 AM
Error Date : Wednesday, December 24th 2014 @ 07:03:14 AM
Script : http:///ajax/api/cron/run
Referrer : http://www.gawdscape.com/forum/player/apply
IP Address : <removed>
Username : <removed>
Classname : vB_Database_MySQLi
MySQL Version : 5.5.38-MariaDB-cll-lve
I have get at least 1 of these per day and have been for the past 2 months or so now.
I thought it was just in that version but I am have been running the latest version since it was released and still receive this message.
The referring script often varies but the message usually is generally the same.
The <database> takes place of the MySQL database, removed for security reasons.
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 >= 1414368000 AND nv.dateline < (1414368000 + 86400)
GROUP BY node.parentid, existing.replies; /**vBForum:calculateStats called from cron **/;
MySQL Error : BIGINT UNSIGNED value is out of range in '(`<database>`.`nv`.`totalcount` - ifnull(`<database>`.`existing`.`replies`,0))'
Error Number : 1690
Request Date : Wednesday, December 24th 2014 @ 07:03:14 AM
Error Date : Wednesday, December 24th 2014 @ 07:03:14 AM
Script : http:///ajax/api/cron/run
Referrer : http://www.gawdscape.com/forum/player/apply
IP Address : <removed>
Username : <removed>
Classname : vB_Database_MySQLi
MySQL Version : 5.5.38-MariaDB-cll-lve
I have get at least 1 of these per day and have been for the past 2 months or so now.
I thought it was just in that version but I am have been running the latest version since it was released and still receive this message.
The referring script often varies but the message usually is generally the same.
The <database> takes place of the MySQL database, removed for security reasons.
Comment