in file advanced_forum.module, the sql queries use table with no prefix. Like this (line 488):

$query = "SELECT n.title AS nodetitle, res.title AS restitle, res.created, res.type AS restype, n.type AS nodetype, n.nid AS nid, t.tid, res.cid AS cid FROM node AS n INNER JOIN (SELECT title, created, nid, uid, type, 'cid' AS cid FROM node UNION SELECT subject, timestamp, nid, uid, 'comment', cid FROM comments ORDER BY created DESC) AS res ON n.nid=res.nid INNER JOIN term_node AS t ON n.nid = t.nid GROUP BY tid;";

tables used: node, comments.

Table with prefix will receive warning like:

user warning: Table 'dbname.node' doesn't exist query: SELECT n.title AS nodetitle, res.title AS restitle, res.created, res.type AS restype, n.type AS nodetype, n.nid AS nid, t.tid, res.cid AS cid FROM node AS n INNER JOIN (SELECT title, created, nid, uid, type, 'cid' AS cid FROM node UNION SELECT subject, timestamp, nid, uid, 'comment', cid FROM comments ORDER BY created DESC) AS res ON n.nid=res.nid INNER JOIN term_node AS t ON n.nid = t.nid GROUP BY tid; in /home/username/public_html/sites/all/modules/advanced_forum/advanced_forum.module on line 490.

Comments

Michelle’s picture

Ah, sorry about that. I got that code from someone else and forgot to fix that. Thanks for the report.

Michelle

Michelle’s picture

Status: Active » Fixed

Committed.

Michelle

sanestrategy’s picture

Is there a quick way I can fix this? My drupal_ prefix is causing the error on my site, which I think I could fix if I knew where to look in the module file.

Michelle’s picture

Weird... The last reply on this issue came thru email but isn't showing up here. Anyway, the answer to the invisible question is:

http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/advanced_fo...

Michelle

sanestrategy’s picture

That definitely fixed it. You rock!

Michelle’s picture

Great! Thanks to melodiesmaster for pointing it out.

Michelle

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.