Announcement
Collapse
No announcement yet.
Database Error
Collapse
X
-
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.
- 1 like
Leave a comment:
-
Database Error
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.
Originally posted by codeDatabase 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 48Last edited by Wayne Luke; Mon 28 Mar '16, 12:17pm.Tags: None
Related Topics
Collapse
-
by catsma_97504Tonight I was attempting to help one of my forum members log in. At first he was unable to log in at all. Reset his password and could log in, but the forum would kick him out after attempting to navigate....
-
Channel: Support Issues & Questions
Mon 7 Apr '14, 7:17pm -
-
by vb_nilsHello,
Since a long time I get sporadic errors emails indicating "Database Error".
I finally have time to investigate, and it seems to happen when a user is writting an answer...-
Channel: Support Issues & Questions
Sun 25 Oct '15, 12:06am -
-
by holymannnHi, I am having the database error quite often after i upgraded my vb from 5.6.0 to 5.6.3 and also the vb5 database tools. The database error always on activity-stream-tab. Anyone can help?
...-
Channel: Support Issues & Questions
Sun 27 Sep '20, 6:05am -
-
by ringnews24I recently moved server and keep getting a huge amount of error codes - can someone tell me how to fix them? Thanks
Code:Database error in vBulletin 5.6.3:
-
Channel: Support Issues & Questions
Wed 28 Oct '20, 1:54am -
-
by coshotgunDatabase error in vBulletin 5.5.4:
Invalid SQL:
SELECT routenew.*
FROM forum2routenew AS routenew
...-
Channel: Support Issues & Questions
Sun 29 Sep '19, 12:22pm -
Leave a comment: