Announcement

Collapse
No announcement yet.

Invalid SQL after upgrade to 5.6.3 and ran Vb5 database tools

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

  • holymannn
    replied
    Originally posted by Wayne Luke
    For the first error, that should be a valid call. What version of PHP are you using?

    The second error means MySQL closed the connection before returning any results from a query and didn't error out. Can't really say way. How large is your session table?
    Php version 7.3.22
    My session table size 2.3mb and 697 rows.

    Leave a comment:


  • Wayne Luke
    replied
    For the first error, that should be a valid call. What version of PHP are you using?

    The second error means MySQL closed the connection before returning any results from a query and didn't error out. Can't really say way. How large is your session table?

    Leave a comment:


  • holymannn
    replied
    Also this error log...

    Code:
    [02-Oct-2020 03:43:48 UTC] MySQL server has gone away
    
    ## phar:///home/xxx/public_html/forum/core/vb/vb.phar/db/query/update.php(109) Exception Thrown
    
    #0 phar:///home/xxx/public_html/forum/core/vb/vb.phar/db/query/update.php(89): vB_dB_Query_Update->doUpdates()
    
    #1 phar:///home/xxx/public_html/forum/core/vb/vb.phar/db/assertor.php(293): vB_dB_Query_Update->execSQL()
    
    #2 phar:///home/xxx/public_html/forum/core/vb/vb.phar/db/assertor.php(530): vB_dB_Assertor->assertQuery('session', Array)
    
    #3 phar:///home/xxx/public_html/forum/core/vb/vb.phar/session.php(611): vB_dB_Assertor->update('session', Array, Array)
    
    #4 phar:///home/xxx/public_html/forum/core/vb/vb.phar/shutdown.php(86): vB_Session->save()
    
    #5 /home/xxx/public_html/forum/core/vb/vb.php(483): vB_Shutdown->shutdown()
    
    #6
    [internal function]: vB::shutdown() #7 {main}

    Leave a comment:


  • holymannn
    replied
    How about this error log? Very often.

    Code:
    [02-Oct-2020 03:44:03 UTC] PHP Fatal error: Uncaught Error: Call to a member function hasAdminPermission() on null in phar:///home/xxx/public_html/forum/core/vb/vb.phar/api/wrapper.php:254 Stack trace:
    #0
    /home/xxx/public_html/forum/includes/api/interface/collapsed.php(105): vB_Api_Wrapper->__call('fetchCurrentUse...', Array)
    #1 /home/xxx/public_html/forum/includes/vb5/user.php(52): Api_Interface_Collapsed->callApi('user', 'fetchCurrentUse...', Array)
    #2 /home/xxx/public_html/forum/includes/vb5/user.php(41): vB5_User->__construct()
    #3 /home/xxx/public_html/forum/includes/vb5/user.php(76): vB5_User::instance()
    #4 /home/xxx/public_html/forum/includes/vb5/string.php(403): vB5_User::get('lang_charset')
    #5 /home/xxx/public_html/forum/includes/vb5/applicationabstract.php(562): vB5_String::getCharset()
    #6 /home/xxx/public_html/forum/includes/vb5/applicationabstract.php(480): vB5_ApplicationAbstract::setCharset()
    #7 /home/xxx/public_html/forum/includes/vb5/applicationabstract.php(636): vB5_ApplicationAbstract::minEr in phar:///home/xxx/public_html/forum/core/vb/vb.phar/api/wrapper.php on line 254

    Leave a comment:


  • holymannn
    replied
    Originally posted by Wayne Luke
    Originally posted by holymannn View Post
    hi, now my error log started showing error below? should i ignore?

    [01-Oct-2020 07:06:25 UTC] PHP Warning: Invalid argument supplied for foreach() in phar:///home/xxx/public_html/forum/core/vb/vb.phar/db/mysql/querydefs.php on line 3521
    Unfortunately, this refers to a query that is generated on the fly so without knowing exactly what is calling this function at the time of the warning, I can't offer any solutions. Are there issues with search results displaying anywhere on the site? If not, then I would ignore it for now as a warning.
    So far, no one feedback there is an issue on search result. I will jusr ignore if first

    Leave a comment:


  • Wayne Luke
    replied
    Originally posted by holymannn View Post
    hi, now my error log started showing error below? should i ignore?

    [01-Oct-2020 07:06:25 UTC] PHP Warning: Invalid argument supplied for foreach() in phar:///home/xxx/public_html/forum/core/vb/vb.phar/db/mysql/querydefs.php on line 3521
    Unfortunately, this refers to a query that is generated on the fly so without knowing exactly what is calling this function at the time of the warning, I can't offer any solutions. Are there issues with search results displaying anywhere on the site? If not, then I would ignore it for now as a warning.

    Leave a comment:


  • holymannn
    replied
    hi, now my error log started showing error below? should i ignore?

    [01-Oct-2020 07:06:25 UTC] PHP Warning: Invalid argument supplied for foreach() in phar:///home/xxx/public_html/forum/core/vb/vb.phar/db/mysql/querydefs.php on line 3521

    Leave a comment:


  • holymannn
    replied
    Originally posted by OrganForum View Post
    Thanks alot, no more issue after replacing the file

    Leave a comment:


  • OrganForum
    replied
    See this post for the fix
    https://forum.vbulletin.com/forum/vb...16#post4446616

    Leave a comment:


  • holymannn
    replied
    Originally posted by In Omnibus
    Are you using PHP 7.2.0 or higher?
    Hi i am using php 7.3 mysql 5.6

    Leave a comment:


  • In Omnibus
    replied
    Are you using PHP 7.2.0 or higher?

    Leave a comment:


  • holymannn
    replied
    anyone can help? please

    Leave a comment:


  • Invalid SQL after upgrade to 5.6.3 and ran Vb5 database tools

    Hi, 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?



    Code:
    Database error in vBulletin 5.6.3:
    
    Invalid SQL:
    
    SELECT DISTINCT CASE WHEN starter.nodeid IN (30,203) OR starter.parentid in (30,203)
    THEN starter.nodeid ELSE node.lastcontentid END AS nodeid, node.parentid, node.userid
    FROM node as node
    
    
    JOIN closure AS closure  ON node.nodeid = closure.child
    WHERE node.starter = node.nodeid AND
    node.contenttypeid <> 26 AND
    node.showpublished = 1 AND
    closure.parent = '2742728' AND
    node.nodeid <> closure.parent AND
    node.inlist = 1 AND
    node.protected <> '1' AND
    node.lastcontent >= 1598536618
    AND (node.public_preview = 1 OR  ( ( (  (node.parentid IN (1,2,3,6,13,14,16,17,20,21,23,24,25,31,2662564,2662565,7,8,9,12,2662496,32,34,36,37,42,64, 100,40,41,62,39,46,47,49,50,51,52,53,33,35,45,63,82,85,88,89,90,91,92,38,65,67,68,69,70,71 ,72,73,74,75,96,60,61,78,83,87,93,95,99,115,248,390,502,104,105,106,107,113,119,124,146,16 3,167,186,108,109,110,111,112,118,120,121,122,123,145,165,155,156,157,125,126,127,128,129, 144,147,168,367,138,139,150,285,130,131,132,133,134,135,136,137,143,161,169,360,380,140,14 1,142,149,151,166,230,240,241,256,284,396,152,153,154,282,158,159,160,162,251,253,283,433, 541,2878158,368,385,539,562,2735328,2753930,2802930,2834717,2892598,2896923,200,201,202,20 4,205,296,175,178,179,180,181,184,185,235,117,176,187,188,189,191,192,254,177,195,196,197, 199,316,198,206,207,208,209,260,261,262,266,267,268,269,270,271,272,273,286,287,329,341,37 9,416,426,435,438,454,476,482,497,500,515,523,548,2694820,2742728,2756564,2769867,2774390, 2797626,2799548,2805002,2817255,2817488,2819110,2820576,2823759,2866729,2870151,2877230,28 77235,2878149,2878883,2879463,2881703,2893083,2894185,2899719,2903256,301,489,518,2736606, 485,534,561,2690198,305,309,491,2901703,2873892,303,304,306,417,503) ) AND (node.showapproved > 0 OR node.userid = 103135) AND node.viewperms > 0 AND node.showpublished > 0 ))
    OR ( node.nodeid IN (30,203) OR node.parentid IN (30,203) )
    OR ( node.parentid IN (26) AND node.userid = 103135 )
    OR node.parentid = 9 AND node.userid IN (103135)))
    
    
    ORDER BY node.lastcontent DESC
    LIMIT 300
    
    /**getSearchResults**/;
    
    MySQL Error   : Unknown column 'starter.nodeid' in 'field list'
    Error Number  : 1054
    Request Date  : Sunday, September 27th 2020 @ 01:56:58 PM
    Error Date    : Sunday, September 27th 2020 @ 01:56:58 PM
    Script        : https://xxx/forum/activity/get
    Referrer      : https://xxx/forum/forum/market-place/?tab=activity-stream-tab
    IP Address    : 118.101.82.140
    Username      : zksdzksd
    Classname     : vB_Database_MySQLi
    MySQL Version :
    
    
    Stack Trace:
    #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1207
    #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
    #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 576
    #3 vB_Database->query_read() called in phar://[path]/vb/vb.phar/db/result.php on line 144
    #4 vB_dB_Result->rewind() called in phar://[path]/vb/vb.phar/db/result.php on line 68
    #5 vB_dB_Result->__construct() called in [path]/packages/vbdbsearch/db/mysql/querydefs.php on line 619
    #6 vBDBSearch_dB_MYSQL_QueryDefs->getSearchResults() called in phar://[path]/vb/vb.phar/db/query/method.php on line 68
    #7 vB_dB_Query_Method->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
    #8 vB_dB_Assertor->assertQuery() called in [path]/packages/vbdbsearch/core.php on line 471
    #9 vBDBSearch_Core->getResults() called in phar://[path]/vb/vb.phar/api/search.php on line 164
    #10 vB_Api_Search->getSearchResultsCriteria() called in phar://[path]/vb/vb.phar/api/search.php on line 131
    #11 vB_Api_Search->getSearchResult() called in phar://[path]/vb/vb.phar/api/search.php on line 227
    #12 vB_Api_Search->getInitialResults() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 201
    #13 vB_Api_Wrapper->__call() called in /home/xxx/public_html/forum/includes/api/interface/collapsed.php on line 105
    #14 Api_Interface_Collapsed->callApi() called in /home/xxx/public_html/forum/includes/vb5/frontend/controller/activity.php on line 288
    #15 vB5_Frontend_Controller_Activity->actionGet() called in /home/xxx/public_html/forum/index.php on line 74

Related Topics

Collapse

Working...
X