Icy Phoenix

     
 


This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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?
 



 
girljoSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Album Error SQL Error : 1064-Couldn't Get Total Number O 
 
Topic moved to FAP Support
 



 
TheSteffenSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album Error SQL Error : 1064-Couldn't Get Total Number O 
 
thanks, sorry!  
 



 
girljoSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Album Error SQL Error : 1064-Couldn't Get Total Number O 
 
Upgrade to the latest FAP release (FAP 1.4.1)
 



 
ArtieSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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!
 



 
girljoSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
lefty74Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 



 
girljoSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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).
 




____________
lefty74
www.zoocrew.eu - help us save our wildlife
 
lefty74Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
girljoSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
girljoSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
ArtieSend private message  
Back to topPage bottom
This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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