https://www.icyphoenix.com/viewtopic.php?f=26&t=1814 ----------------------------------- girljo Thu 03 May, 2007 04:27 FAP SUPPORT - Album Error ----------------------------------- OK... After several mishaps concerning the upgrade of FAP to 1.4.1, because we were told that moving to the latest would get rid of all of the above error. we are exactly back at square one with the addition of some OTF gallery that we have yet to learn about and blue stars. Can someone please help me cure this ill once and for all. I will do whatever I have to do for you to help me. :mryellow: Could not get category comment count information 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(comment_id) AS comment_count FROM phpbb_album_comment LEFT JOIN phpbb_album ON comment_pic_id = pic_id WHERE pic_cat_id IN () Line : 1029 File : album_hierarchy_sql.php My album info below: Photo Album Powered by: Mighty Gorgon Full Album Pack 1.4.1 © 2006 [based on Smartor Photo Album plus IdleVoid's Album CH & CLowN SP1] ----------------------------------- lefty74 Thu 03 May, 2007 08:16 Re: Album Error ----------------------------------- hmm, do you still get this error? Looks like it is working fine when I am looking at it ----------------------------------- girljo Thu 03 May, 2007 19:17 Re: Album Error ----------------------------------- We do. It is only in the Personal Galleries and you'd have to be a member of a particular Usergroup to see it. As the admin, I have no problem but the members do on MOST personal galleries. I am not sure why only one work and others do not. I thought maybe it had to do with creating sub categories within the personal galleries but it does not. I am at my wits end with this so any help is appreciated. I can give you access to see what I am talking about. Thanks ----------------------------------- girljo Thu 03 May, 2007 19:42 Re: Album Error ----------------------------------- Not sure if this helps but Line : 1029 File : album_hierarchy_sql.php message_die(GENERAL_ERROR, 'Could not get category comment count information', '', __LINE__, __FILE__, $sql); ----------------------------------- Artie Thu 03 May, 2007 20:12 Re: Album Error ----------------------------------- What version were you using before upgrade ? ----------------------------------- girljo Thu 03 May, 2007 21:33 Re: Album Error ----------------------------------- Valid question. It was 1.2.1 ----------------------------------- Artie Fri 04 May, 2007 00:18 Re: Album Error ----------------------------------- It's sure looks like the error occurs for PG's w/subcats..... Why, I really don't know at the moment... Maybe MG will drop in soon and offer some of his knowledge. Just to perhaps narrow the problem a bit, would you go to your ACP album configuration and set [highlight=#FFFFAA]Show the number of total comments for current categories and all it's sub categories in index table[/highlight] to [highlight=#FFFFAA]No[/highlight] ... then check if any other errors appear. ----------------------------------- girljo Fri 04 May, 2007 01:09 Re: Album Error ----------------------------------- Didn't seem to help anything. The error may have changed some. Another thing that I may or may not have mentioned and it might mean something. I don't get the error as an admin. Only those who are permitted to see the image gets it. Could not get last pic information 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 ') ORDER BY p.pic_time DESC LIMIT 1' at line 4 SELECT p.pic_id, p.pic_title, p.pic_user_id, p.pic_username, p.pic_time, p.pic_cat_id, u.user_id, u.username FROM phpbb_album AS p LEFT JOIN phpbb_users AS u ON p.pic_user_id = u.user_id WHERE p.pic_cat_id IN () ORDER BY p.pic_time DESC LIMIT 1 Line : 758 File : album_hierarchy_sql.php ----------------------------------- Artie Fri 04 May, 2007 02:12 Re: Album Error ----------------------------------- Before FAP, did you have Smartor's album installed ? ----------------------------------- girljo Fri 04 May, 2007 03:17 Re: Album Error ----------------------------------- Not really sure what we had. This is the second version we have had. I can't even recall where I downloaded it from. I am guessing the phppb site. When first encountered problems, I posted this at smartor and they sent me here. http://smartor.is-root.com/viewtopic.php?t=18798&highlight= ----------------------------------- Artie Fri 04 May, 2007 03:28 Re: Album Error ----------------------------------- Ok, if you had Smartor's before this could be part of the problem with the personal galleries. Run the file fap_install.php (again), but this time click on the [highlight=#FFFFAA]Migrate Personal Galleries from Smartor Album without CH[/highlight] link. If it returns [highlight=#FFFFAA]There aren't any 'old' personal galleries to migrate. Script is ending.[/highlight], then the problem is probably not related to an old Smarter installation. ----------------------------------- girljo Fri 04 May, 2007 04:49 Re: Album Error ----------------------------------- Artie you rock for trying to help us with this. I hope that the photos over there aren't scaring you off. Now, if only you had that little nailbiting emoticon that I have so I could use it right now. I am really gun shy after Sunday's blow up of everything. :oops: BACK UP FIRST! BACK UP FIRST! BACK UP FIRST! BACK UP FIRST! BACK UP FIRST! BACK UP FIRST! BACK UP FIRST! BACK UP FIRST! BACK UP FIRST! ----------------------------------- girljo Fri 04 May, 2007 20:51 Re: Album Error ----------------------------------- I haven't tried what you said yet, but I will point out that this problem existed BEFORE the upgrade. The problem is the reason we did so. ----------------------------------- Artie Fri 04 May, 2007 21:24 Re: Album Error ----------------------------------- Yes, I understand..... but if you originally had Smartor's with personal galleries, this step should have been done after the FAP installation. Without access to your database, this is the only way to verify this has been done. I don't know that this will fix it, but I"m hoping it will..... I can't think of anything else that would cause this short of a bad installation. ----------------------------------- girljo Fri 04 May, 2007 21:33 Re: Album Error ----------------------------------- Thanks... We'll try it.