2006-08-18, 09:00 AM
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)
is it possible to not show those forums and have it still work?
thanks in advance for your help
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