If this is your first visit, be sure to check the FAQ section first by clicking the link.
You may need to register before you can post: click the register link first to continue
To start viewing posts, select the forum you want to visit from the selection below.
When a guest user clicks the "Latest Activity" tab on the forum, the AJAX call returns a database error. The following query gets generated:
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;
The error:
Code:
Unknown column 'starter.nodeid' in 'field list'
There is no alias or reference to anything called 'starter'. Changing 'starter' to 'node' seems to fix it.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.