Howdu guys

Newbie ere.

I run four online motorcycle forums and I have installed the FAP in them all.

However I am getting reports from members that when they try and view other members profiles they get this message :

Couldn't get total number of pictures for album categories and sub categories

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3

SELECT COUNT(p.pic_id) AS count FROM phpbb_album_cat AS c LEFT JOIN phpbb_album AS p ON c.cat_id = p.pic_cat_id WHERE c.cat_id IN ()

Line : 1051
File : album_hierarchy_sql.php

When I log in as admin everything looks fine but when I log in as one of them I see that message too.

Any ideas guys why I can see everything but my forum members can't ?

Many thanks.

Matt

Any ideas on this one guys please ? am getting members asking me again.

Thanks.

Matt  

Strange that it doesn't happen with admin too.

Try replacing these 2 files with the original unedited files.

includes/usercp_viewprofile.php
templates/subSilver/profile_view_body.tpl


If that stops the error, carefully apply the edits per FAP install text.