Announcement

Collapse
No announcement yet.

Database error in search module

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

  • David Karol
    replied
    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.

    Leave a comment:


  • David Karol
    replied
    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.

    Leave a comment:


  • Mark.B
    replied
    The site is in debug mode...does the error persist if you take out of debug mode?

    Leave a comment:


  • David Karol
    replied
    Restarting mysql service resolved front page issue. Search module database error still persists.

    Leave a comment:


  • David Karol
    replied
    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\',\'ip\',\'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; Wed 15th Jan '20, 2:22am.

    Leave a comment:


  • David Karol
    started a topic Database error in search module

    Database error in search module

    Occurring in 'Recent Discussions' module, in side bar, at site. 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 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
    Last edited by David Karol; Wed 15th Jan '20, 2:21am.

Related Topics

Collapse

Working...
X