MyBB Community Forums

Full Version: recent_threads_profile
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
ive got a problem with recent threads in profile

im running Show Recent Threads on Profile version 1.5.1 with mybb version 1.1.7

when its active we get this error:
mySQL error: 1052
Column: 'fid' in where clause is ambiguous
Query: SELECT t.*, f.name, i.path FROM mybb_threads t LEFT JOIN mybb_forums f ON (f.fid=t.fid) LEFT JOIN mybb_icons i ON (i.iid=t.icon) WHERE t.uid='1' AND fid NOT IN ('21','23','22') ORDER BY t.dateline DESC LIMIT 10

we have 3 forums currently that are private only for admins

if i comment out the following lines from recent_threads_profile.php it works fine (but shows the private forums for admins only in the list)
        if($unviewableforums)
        {
                $unviewwhere = "AND fid NOT IN ($unviewableforums)";
        }

is it possible to not show those forums and have it still work?

thanks in advance for your help Smile