https://www.icyphoenix.com/viewtopic.php?f=26&t=1364
-----------------------------------
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?


-----------------------------------
TheSteffen
Sun 18 Mar, 2007 18:51

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


-----------------------------------
girljo
Sun 18 Mar, 2007 19:20

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


-----------------------------------
Artie
Mon 19 Mar, 2007 20:47

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

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

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)[/quote]

I just upgraded to 1.4.1 myself yesterday :oops: and I had no real issues.


-----------------------------------
girljo
Sun 01 Apr, 2007 02:56

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

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

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

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

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


