I'm getting a SQL error in the log when using the dev release of the advanced Forum. It also is occurring when using alpha8. I'm getting it with the included template files. It looks like it might be the apostrophes, but then I really don't know what I'm talking about. It appears to function correctly, just a bunch of errors in the log.

Here is the error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT title, created AS time, query: SELECT n.title AS topictitle, r.title AS replytitle, r.time timestamp, r.type AS replytype, n.type AS topictype, n.nid AS topicid, t.tid, r.cid AS cid, r.uid, u.name FROM node AS n INNER JOIN ( (SELECT title, created AS time, nid, uid, type, 'cid' AS cid FROM node ) UNION (SELECT subject, timestamp, nid, uid, 'comment', cid FROM comments WHERE comments.status = 0 ) ORDER BY time DESC ) AS r ON n.nid=r.nid INNER JOIN term_node AS t ON n.nid = t.nid INNER JOIN users AS u ON r.uid = u.uid WHERE n.status = 1 GROUP BY tid; in /var/home/soul/wwwroot/soultracks.com/test/includes/database.mysql.inc on line 172.

Comments

rinvelt’s picture

rinvelt commented

It looks like the problem is the infamous "advanced_forum_get_all_last_topics".

To "correct" the issue I just comment out the call to that in the module. The SQL looks ugly enough not to want to touch.

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented
Status: Active » Closed (duplicate)

Yes, it's that function.

Michelle