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
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
Comment