01-16-2011, 12:14 PM
<pre>user error: Unknown column 'acf.fid' in 'on clause'
query:
SELECT ac.title AS actitle, af.title AS aftitle, ai.title AS aititle, ai.link AS ailink, ai.timestamp AS aitimestamp, af.link AS aflink FROM aggregator_category_item a INNER JOIN aggregator_category ac ON a.cid = ac.cid INNER JOIN aggregator_item ai ON ai.iid = a.iid INNER JOIN aggregator_feed af ON af.fid = acf.fid AND ai.fid = af.fid INNER JOIN aggregator_category_feed acf ON acf.cid = ac.cid WHERE a.cid = 34 ORDER BY aftitle ASC, aitimestamp DESC in /home/fishingr/public_html/includes/database.mysql.inc on line 66.</pre>
query:
SELECT ac.title AS actitle, af.title AS aftitle, ai.title AS aititle, ai.link AS ailink, ai.timestamp AS aitimestamp, af.link AS aflink FROM aggregator_category_item a INNER JOIN aggregator_category ac ON a.cid = ac.cid INNER JOIN aggregator_item ai ON ai.iid = a.iid INNER JOIN aggregator_feed af ON af.fid = acf.fid AND ai.fid = af.fid INNER JOIN aggregator_category_feed acf ON acf.cid = ac.cid WHERE a.cid = 34 ORDER BY aftitle ASC, aitimestamp DESC in /home/fishingr/public_html/includes/database.mysql.inc on line 66.</pre>