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
Comment