Invalid SQL after upgrade to 5.6.3 and ran Vb5 database tools

[holymannn]

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?

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

[holymannn]

anyone can help? please

[In Omnibus]

Are you using PHP 7.2.0 or higher?

[holymannn]

Are you using PHP 7.2.0 or higher?

Hi i am using php 7.3 mysql 5.6

[OrganForum]

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

[holymannn]

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

Thanks alot, no more issue after replacing the file

[holymannn]

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

[Wayne Luke]

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.

[holymannn]

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

[holymannn]

How about this error log? Very often.

[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

[holymannn]

Also this error log...

[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}

[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?

[holymannn]

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.