Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Paul.
    Member
    • Feb 2007
    • 98
    • 5.1.x

    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 code
    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
    Last edited by Wayne Luke; Mon 28 Mar '16, 12:17pm.
    Welcome, Paul..
    You last visited: Sat 21st Jul '07 at 2:37am
  • In Omnibus
    Senior Member
    • Apr 2010
    • 2310

    #2
    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.

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73981

      #3
      Please upgrade to 5.2.0 and let us know if the error continues.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      Related Topics

      Collapse

      Working...