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?
FAP SUPPORT - Album Error SQL Error : 1064-Couldn't Get Total Number Of P
Subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O
Topic moved to FAP Support ;-)
Subject: Re: Album Error SQL Error : 1064-Couldn't Get Total Number O
Upgrade to the latest FAP release (FAP 1.4.1)
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!
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
I just upgraded to 1.4.1 myself yesterday :oops: and I had no real issues.
this is from the download topic
Quote:
I just upgraded to 1.4.1 myself yesterday :oops: and I had no real issues.
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?
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).
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
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
Topic Locked
Page 1 of 1
You cannot post new topicsYou 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