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
Comment #1
MichelleAh, sorry about that. I got that code from someone else and forgot to fix that. Thanks for the report.
Michelle
Comment #2
MichelleCommitted.
Michelle
Comment #3
sanestrategy CreditAttribution: sanestrategy commentedIs 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.
Comment #4
MichelleWeird... 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
Comment #5
sanestrategy CreditAttribution: sanestrategy commentedThat definitely fixed it. You rock!
Comment #6
MichelleGreat! Thanks to melodiesmaster for pointing it out.
Michelle
Comment #7
Anonymous (not verified) CreditAttribution: Anonymous commentedAutomatically closed -- issue fixed for two weeks with no activity.