Howdy guys  

OK recently have had a few new forum members upload pics to their personal gallery, and while I can see the pics as admin, other people can only see selected personal galleries, some work some dont show at all and the ones that dont bring the pics up give me 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

-----------------------------------------------------------------------------------------------------------------------------

Any ideas why I can see them as admin but other people cant ?

Many thanks in advance.

Matt

Is this a fresh FAP install or was it a upgrade from Smartor's Album or an earlier version of  FAP ?

Artie wrote: [View Post]

Is this a fresh FAP install or was it a upgrade from Smartor's Album or an earlier version of  FAP ?

Hiya mate, thanks for answering

Not sure on version but its been installed now about... 5 months or so.

Everything was ok, but recently had a few new members join and while members can see other peoples personal gallery, no one can view the 4 new people personal gallery and I have no idea why or where to start and try and fix this ?

Any pointers much appreciated.

Thanks

I've already seen this errors some time ago... and I should have fixed it...

Do you have the latest version installed?

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

Hiya Mighty Gorgon  

To be honest I dont know how to check my current version although I do know its about 5 months since I installed it.

Can you tell me please how to check what version I got and where I can download the latest version ?

Also when upgrading it wont effect my phpbb forum will it ? I hope its a straight forward update, will I lose current members pics ?

MANY thanks mate, appreciate the advice.

Matt

FAP version should be displayed in the album's footer.

Alway backup your files and DB prior to upgrading, but you should not loose anything.

Mine says :

Photo Album Powered by: Mighty Gorgon Full Album Pack 1.4.0 © 2006
[based on Smartor Photo Album plus IdleVoid's Album CH & CLowN SP1]

Do I need to update ? and if so anyone have a linky please where I can download the update ?

Many thanks.

Matt_UK wrote: [View Post]

Do I need to update ? and if so anyone have a linky please where I can download the update ?

Latest FAP version is 1.4.1. and you can get it here. As MG said, last version should fix your problem.

And as Artie said

Artie wrote: [View Post]

Alway backup your files and DB prior to upgrading, but you should not loose anything.

Good luck

____________
Omarska online

I'm having the same problem...  I've installed Mighty Gorgon Full Album Pack 1.4.1 © 2006 and I'm getting this error when commenting and uploading...  I'm assuming it has to do with the apostrophe in the comment/description..  

Please help?!

tearyied wrote: [View Post]

I'm having the same problem...  I've installed Mighty Gorgon Full Album Pack 1.4.1 © 2006 and I'm getting this error when commenting and uploading...  I'm assuming it has to do with the apostrophe in the comment/description..  

Please help?!

It is a different error from the one posted here.

Please open a new topic indicating precisely the error you are having and what you do to get it.

Test account will be welcome.

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON