Icy Phoenix :: View topic - FAP SUPPORT - Members Cant See Member Profiles ?

Archived phpBB Topics (Styles, Mods, Support) - FAP SUPPORT - Members Cant See Member Profiles ?

MattUK [ Mon 28 May, 2007 09:58 ]
Post subject: FAP SUPPORT - Members Cant See Member Profiles ?

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

MattUK [ Tue 29 May, 2007 22:42 ]
Post subject: Re: Members Cant See Member Profiles ?

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

Thanks.

Matt

Artie [ Tue 29 May, 2007 23:43 ]
Post subject: Re: Members Cant See Member Profiles ?

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.