https://www.icyphoenix.com/viewtopic.php?f=26&t=1364&p=10321#p10321
-----------------------------------
girljo
Sun 18 Mar, 2007 18:30

FAP SUPPORT - Album Error SQL Error : 1064-Couldn't Get Total Number Of P
-----------------------------------
Using the latest phpbb 2.2? and I suspect version bundled (2.0.28 compatible) of the album.

When people in the ACTIVE MEMBERS USERGROUP try to access private albums they get the errror below. There are currently 3 members with albums. I have a test album, and I know the girljo album has multiple folders, if that makes a difference...

But people who are in the active member group who do have access to the albums (The Darkroom) can't access 2 of the personal galleries without getting this message. I think maybe the third gallery has only one folder... could that be the difference?

I can provide login to a test account for someone willing to help me but the site is adult in nature and the photos are explicit.

pm me and I will reply with access.

Thanks!

The total error looks like this:
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 : 1015
File : album_hierarchy_sql.php



Anyone able to help me?