Announcement

Collapse
No announcement yet.

Database error in search module

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in search module

    Occurring in 'Recent Discussions' module, in side bar, at soundforums.net. I woke up to the database error is after ~15 hours of traffic on vB 5 live site, after no changes to the search module.

    Error Invalid SQL: SELECT node.nodeid FROM sr_node as node JOIN sr_closure AS closure USE INDEX (child) ON node.nodeid = closure.child WHERE node.contenttypeid = '30' AND closure.parent IN ('18','19','20','25','30','21','26','23','24','27','28') AND node.nodeid <> closure.parent AND node.inlist = 1 AND node.contenttypeid <> '22' ORDER BY node.created DESC,node.nodeid ASC LIMIT 500 /**getSearchResults**/;

    I don't see any issues in mysql/error.log

  • #2
    Now this will show on the home page, site is down with typical users seeing "database error"

    Error :API Error
    Controller: search
    Method: getInitialResults
    Error(s):
    array (
    0 => 'Error Invalid SQL:

    REPLACE INTO sr_searchlog
    (type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,json,resu lts,results_count)
    VALUES
    (\'0\',\'3\',\'162.158.255.239\',\'4951d4e12d3ada164eab0ad75096e353\',\'displayorder\',\'a sc\',\'0.0021591186523438\',\'1462739803\',\'0\',\'{"type":"vBForum_Channel","sort": {"displayorder":"ASC"},"channel":"2","depth":"1"}\',\'14,15,17,16\',\'4\');' ,
    1 =>
    array (
    0 => 'exception_trace',
    1 => '## */core/vb/database.php(1247) Exception Thrown
    #0 */core/vb/database/mysqli.php(176): vB_Database->halt()
    #1 */core/vb/database.php(506): vB_Database_MySQLi->execute_query(true, Object(mysqli))
    #2 */core/packages/vbdbsearch/db/mysql/querydefs.php(664): vB_Database->query_write(\'\\n\\t\\t\\tREPLACE INT...\')
    #3 */core/vb/db/query/method.php(175): vBDBSearch_dB_MYSQL_QueryDefs->cacheResults(Array, Object(vB_Database_MySQLi), false, false)
    #4 */core/vb/db/assertor.php(283): vB_dB_Query_Method->execSQL()
    #5 */core/vb/search/core.php(283): vB_dB_Assertor->assertQuery(\'vBDBSearch:cach...\', Array)
    #6 */core/vb/api/search.php(163): vB_Search_Core->cacheResults(Array, Object(vB_Search_Criteria), 0.0021591186523438, 0)
    #7 */core/vb/api/search.php(127): vB_Api_Search->getSearchResultsCriteria(Object(vB_Search_Criteria), 0)
    #8 */core/vb/api/search.php(215): vB_Api_Search->getSearchResult(\'{"channel":"2",...\', 0)
    #9 [internal function]: vB_Api_Search->getInitialResults(Array, \'999\', \'1\', \'0\')
    #10 */core/vb/api/wrapper.php(129): call_user_func_array(Array, Array)
    #11 [internal function]: vB_Api_Wrapper->__call(\'getInitialResul...\', Array)
    #12 [internal function]: vB_Api_Wrapper->getInitialResults(Array, \'999\', \'1\', \'0\')
    #13 */includes/api/interface/collapsed.php(201): call_user_func_array(Array, Array)
    #14 */includes/vb5/template/runtime.php(506): Api_Interface_Collapsed->callApi(\'search\', \'getInitialResul...\', Array, false, true)
    #15 */core/cache/template/template20263.php(144): vB5_Template_Runtime:arseData(\'search\', \'getInitialResul...\', Array, \'999\', \'1\', \'0\')
    #16 */includes/vb5/template.php(330): include(\'/home/x/www/s...\')
    #17 */includes/vb5/template/cache.php(134): vB5_Template->render(false)
    #18 */includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'\\r\\n\\t\\r\\n\\t\\r\\n\\t\\r\\n\\t\\r\\n\\t...\')
    #19 */includes/vb5/template/cache.php(134): vB5_Template->render(false)
    #20 */includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'<!-- ##template...\')
    #21 */includes/vb5/frontend/controller/page.php(245): vB5_Template->render()
    #22 [internal function]: vB5_Frontend_Controller_Page->index(13, 13, 13, \'$pagenum\', 163, \'Sound Forums Ne...\', 1, \'/external?type=...\', \'Above The Fold\', 1)
    #23 */index.php(86): call_user_func_array(Array, Array)
    #24 {main}',
    ),
    )

    on line 510 in */includes/vb5/template/runtime.php
    Step 0: showErrorPage() called on line 215 in */includes/vb5/applicationabstract.php
    Step 1: handleException() called
    Exception API Error
    Controller: search
    Method: getInitialResults
    Error(s):
    array (
    0 =>
    array (
    0 => 'invalid_search_resultid',
    ),
    )

    on line 510 in */includes/vb5/template/runtime.php
    Last edited by David Karol; Sat 15th Sep '18, 1:35am.

    Comment


    • #3
      Restarting mysql service resolved front page issue. Search module database error still persists.

      Comment


      • #4
        The site is in debug mode...does the error persist if you take out of debug mode?
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.5.6 Demo
        AdminAmmo - My Cloud Demo

        Comment


        • #5
          Mark,

          To get out of debug mode, is the only setting located in /core/includes/config.php?
          Debug mode still persists with
          Code:
          $config['Misc']['debug'] = true;
          commented out.

          Note that the site has continuously been in debug mode for the past day.

          Comment


          • #6
            Could this have been related to /tmp being out of space. For some reason, the available space there was 1MB. After rebooting the server, this is back to normal, and no database error occurs.

            Comment

            Related Topics

            Collapse

            Working...
            X