Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - FAP SUPPORT - Album Error SQL Error : 1064-Couldn't Get Total Number Of P

girljo [ Sun 18 Mar, 2007 18:30 ]
Post subject: 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?

TheSteffen [ Sun 18 Mar, 2007 18:51 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

Topic moved to FAP Support

girljo [ Sun 18 Mar, 2007 19:20 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

thanks, sorry!

Artie [ Mon 19 Mar, 2007 20:47 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

Upgrade to the latest FAP release (FAP 1.4.1)

girljo [ Sat 31 Mar, 2007 19:20 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

We upgraded to the new album pack for the fix, but it essentially installed an additional album. Is there a way to upgrade rather than do a side by side install?

Do we delete the old album first? (Then what happens to pix/posts/ratings, etc)

Did we do something wrong?

Please help!

lefty74 [ Sat 31 Mar, 2007 23:20 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

Hi,
this is from the download topic

Quote:
How to upgrade from FAP 1.4.0

* Upload fap_install.php to your phpBB root folder and run it when logged as Admin... then choose to upgrade!
* Replace all FAP files with the new ones (or use WinMerge to compare your files with the new ones)

I just upgraded to 1.4.1 myself yesterday

and I had no real issues.

girljo [ Sun 01 Apr, 2007 02:56 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

Thanks much, we'll give it a shot.

Edit:

Actually... can you tell me if you used easymod?

lefty74 [ Sun 01 Apr, 2007 11:19 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

no, i almost never use easymod, i have quite a few mods installed and I find it is easier to do this manually (imo).

girljo [ Sun 01 Apr, 2007 18:57 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

Thanks for your help and input! We'll work on it today or tomorrow.

girljo [ Mon 30 Apr, 2007 18:25 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

Bump for help.

We have tried upgrading rather than installing on several occasions with no luck. My partner who is doing this for us is at his wits end. Last night he actually broke something and now out darkroom page is blank. The forum is active so reverting to Saturday's back up would be a huge bummer.

Can someone please help me?

http://www.duojo.com/forum/album.php

Artie [ Mon 30 Apr, 2007 20:36 ]
Post subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O

Please do not request help for the same problem in 2 different post.

Topic Locked