Tweet
After upgrading from 5.6.2 pl1 to 5.6.3, I am getting this sql error regularly.
I am on PHP 7.3 and Maria DB 10.3
------------------------------------------------------------
Database error in vBulletin 5.6.3:
Invalid SQL:
SELECT DISTINCT CASE WHEN starter.nodeid IN (27,23) OR starter.parentid in (27,23)
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 <> 29 AND
node.showpublished = 1 AND
closure.parent = '22' AND
node.nodeid <> closure.parent AND
node.inlist = 1 AND
node.protected <> '1' AND
node.lastcontent >= 1596194843
AND (node.public_preview = 1 OR ( ( ( (node.parentid IN (13,1,2,22,29,30,34,43,45,47,3,8,20,28,33,36,38,46,48,18,31,39,41,6,24,25,17,26,32,12,19,1 5,762778,915140) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
OR ( node.nodeid IN (27,23) OR node.parentid IN (27,23) )
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 : Monday, August 31st 2020 @ 11:27:23 AM
Error Date : Monday, August 31st 2020 @ 11:27:23 AM
Script : https://theforums.com/board/activity/get
Referrer : https://theforums.com/board/forum/me...ity-stream-tab
I am on PHP 7.3 and Maria DB 10.3
------------------------------------------------------------
Database error in vBulletin 5.6.3:
Invalid SQL:
SELECT DISTINCT CASE WHEN starter.nodeid IN (27,23) OR starter.parentid in (27,23)
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 <> 29 AND
node.showpublished = 1 AND
closure.parent = '22' AND
node.nodeid <> closure.parent AND
node.inlist = 1 AND
node.protected <> '1' AND
node.lastcontent >= 1596194843
AND (node.public_preview = 1 OR ( ( ( (node.parentid IN (13,1,2,22,29,30,34,43,45,47,3,8,20,28,33,36,38,46,48,18,31,39,41,6,24,25,17,26,32,12,19,1 5,762778,915140) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
OR ( node.nodeid IN (27,23) OR node.parentid IN (27,23) )
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 : Monday, August 31st 2020 @ 11:27:23 AM
Error Date : Monday, August 31st 2020 @ 11:27:23 AM
Script : https://theforums.com/board/activity/get
Referrer : https://theforums.com/board/forum/me...ity-stream-tab
Comment