Announcement

Collapse
No announcement yet.

Error after upgrade 5.6.2 to 5.6.3

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

  • Error after upgrade 5.6.2 to 5.6.3

    Error after upgrade 5.6.2 to 5.6.3

    Can anyone help me investigate this error?



    Database error in vBulletin 5.6.3:
    Invalid SQL:
    SELECT DISTINCT CASE WHEN starter.nodeid IN (70) OR starter.parentid in (70)
    THEN starter.nodeid ELSE node.lastcontentid END AS nodeid
    FROM node as node

    JOIN closure AS closure ON node.nodeid = closure.child
    WHERE node.starter = node.nodeid AND
    node.contenttypeid <> 27 AND
    node.showpublished = 1 AND
    closure.parent = '3' AND
    node.nodeid <> closure.parent AND
    node.inlist = 1 AND
    node.contenttypeid NOT IN ('27','32') AND
    node.protected <> '1' AND
    node.lastcontent >= 1597146341 AND
    (node.public_preview = 1 OR ( ( ( (node.parentid IN
    (1,2,13,14,19,51,58,59,65,3,8,21,35,57,67,23,64,66,6,20,17,22,24,56,12,26,25,38,41,28,27,3 9,32,30,49,40,43,46,29,47,42,44,37,50,31,52,1813061,1815929,1897738,1815931,1815932,181593 3,1815926,1898191,1898192,1898350,1898351)
    ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
    OR ( node.nodeid IN (70) OR node.parentid IN (70) )
    OR node.parentid = 9 AND node.userid IN (0)))

    ORDER BY node.lastcontent DESC
    LIMIT 500

    /**getSearchResults**/;

    MySQL Error : Unknown column 'starter.nodeid' in 'field list
    ' Error Number : 1054
    Request Date : Friday, September 11th 2020 @ 11:45:41 AM
    Error Date : Friday, September 11th 2020 @ 11:45:41 AM
    Script : https://www.m++++ria.it/forum/activity/get
    Referrer : https://www.m++++ria.it/forum/Blogs
    IP Address : 89.118.++.1++8
    Username : Ospite
    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 /var/www/clients/client0/web1/web/forum/includes/api/interface/collapsed.php on line 105
    #14 Api_Interface_Collapsed->callApi() called in /var/www/clients/client0/web1/web/forum/includes/vb5/frontend/controller/activity.php on line 288
    #15 vB5_Frontend_Controller_Activity->actionGet() called in /var/www/clients/client0/web1/web/forum/index.php on line 74



  • #2
    Please see this post here: https://forum.vbulletin.com/forum/vb...16#post4446616
    Translations provided by Google.

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

    Comment


    • #3
      OK Tanks!

      Comment

      Related Topics

      Collapse

      Working...
      X