FAP SUPPORT - Album Error SQL Error : 1064-Couldn't Get Total Number Of P


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?

Subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O
Topic moved to FAP Support ;-)

Profile PM  
Subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O
thanks, sorry! :oops:

Subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O
Upgrade to the latest FAP release (FAP 1.4.1)

Profile PM  
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!

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 :oops: and I had no real issues.

Profile PM  
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?

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).

Profile PM  
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.

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

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

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.0861s (PHP: 27% SQL: 73%)
SQL queries: 10 - Debug Off - GZIP Enabled