Database Error

[Wayne Luke]

Please upgrade to 5.2.0 and let us know if the error continues.

[In Omnibus]

Try disabling cron. It looks like one of your cron jobs is from a disabled or uninstalled third party add on or modification.

Also, warn people when the links go to an adult content site.

[Paul.]

Hi,

Literally no idea why we're getting problem after problem since upgrading to vB5.
Can anyone let me know what happens here? I am not sure if I'm pasting sensitive information. Mods, please edit in this case?
100s of emails like this a day.

Database error in vBulletin 5.1.8:

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

MySQL Error : BIGINT UNSIGNED value is out of range in '(`sexch321_forum`.`nv`.` totalcount` - ifnull(`sexch321_forum`.`existing`.`replies`,0))'
Error Number : 1690
Request Date : Monday, March 28th 2016 @ 03:19:17 PM
Error Date : Monday, March 28th 2016 @ 03:19:17 PM
IP Address : 66.249.65.183
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#line vB_Database->halt() called in [path]/vb/database/mysqli.php on line 176
#line vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 504
#line vB_Database->query_write() called in [path]/packages/vbforum/db/mysql/querydefs.php on line 7806
#line vBForum_dB_MYSQL_QueryDefs->calculateStats() called in [path]/vb/db/query/method.php on line 175
#line vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 283
#line vB_dB_Assertor->assertQuery() called in [path]/includes/cron/node_dailycleanup.php on line 25
#line include_once([path]/includes/cron/node_dailycleanup.php) called in [path]/includes/functions_cron.php on line 250
#line exec_cron() called in [path]/vb/api/cron.php on line 69
#line vB_Api_Cron->run() called in on line
#line ReflectionMethod->invokeArgs() called in [path]/vb/api.php on line 245
#line vB_Api->callNamed() called in on line
#line call_user_func_array() called in [path]/vb/api/wrapper.php on line 121
#line vB_Api_Wrapper->__call() called in /home/sexch321/public_html/forum/includes/api/interface/collapsed.php on line 185
#line vB_Api_Wrapper->callNamed() called in /home/sexch321/public_html/forum/includes/api/interface/collapsed.php on line 185
#line Api_Interface_Collapsed->callApi() called in /home/sexch321/public_html/forum/includes/vb5/frontend/applicationlight.php on line 329
#line vB5_Frontend_ApplicationLight->handleAjaxApiDetached() called in on line
#line call_user_func() called in /home/sexch321/public_html/forum/includes/vb5/frontend/applicationlight.php on line 175
#line vB5_Frontend_ApplicationLight->execute() called in /home/sexch321/public_html/forum/index.php on line 48