Tweet
Latest Activity Tab - Database Error
When a guest user clicks the "Latest Activity" tab on the forum, the AJAX call returns a database error. The following query gets generated:
The error:
There is no alias or reference to anything called 'starter'. Changing 'starter' to 'node' seems to fix it.
PHP Code:
SELECT DISTINCT CASE WHEN starter.nodeid IN (15,23,24) OR starter.parentid in (15,23,24) 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 <> 29 AND node.showpublished = 1 AND closure.parent = '18' AND node.nodeid <> closure.parent AND node.inlist = 1 AND node.protected <> '1' AND node.lastcontent >= 1609866328 AND (node.public_preview = 1 OR ( ( ( (node.parentid IN (1,2,13,14,16,25,40,47,3,18,32,9,19,33,48,6,20,30,21,46,51,12,50,37,34,27) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 )) OR ( node.nodeid IN (15,23,24) OR node.parentid IN (15,23,24) ) OR node.parentid = 9 AND node.userid IN (0))) ORDER BY node.lastcontent DESC LIMIT 100;
Code:
Unknown column 'starter.nodeid' in 'field list'
