exclude album from random block on index

[studeo]

Hello:

I have read for hours the info posted on this issue. Posts range from missing plug-ins to mods, hooks to skins to misc. The edit I thought would work for include/functions.inc was for the replacement of some code that wasn't even in my file. Has the coppermne team come up with a concensus on what is needed to make this mod?  I have only 1 or 2 albums I would like to exclude from the random image block on the index page.

Thank you very much.

[Sami]

Is this what you looking for:
http://forum.coppermine-gallery.net/index.php?topic=24350.0

[studeo]

Yes but that plugin has problems. If I exclude an album by a member, and its their ONLY album, I get a database error when I click to view that album. Also, I only need to exclude certain albums from the random block on the index page.

It also worked when I installed the plugin...but the next time I went to the gallery the images I excluded were back. I have since uninstalled the plugin and will wait for a cleaner code for the mod. 

Thank you for your reply.

[Joachim Müller]

Enable debug_mode and post the actual error message you get (the query that fails, not the debug_output) if you have issues with a plugin.

[studeo]

Critcal error: There was an error while processing a database query

While executing query "SELECT COUNT(*) from cpg148_pictures WHERE approved = 'YES' AND aid IN ()" on 0

mySQL error: 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 1

[studeo]

Here is another error returned when I click on 'most viewed'  inside a user album that has been excluded by this mod:

While executing query "SELECT COUNT(*) from cpg148_pictures WHERE approved = 'YES' AND hits > 0  AND aid IN () " on 0

mySQL error: 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 1

[studeo]

And equally, when I click on 'last comments' inside an album that has been excluded.

While executing query "SELECT COUNT(*) from cpg148_comments, cpg148_pictures  WHERE approved = 'YES' AND cpg148_comments.pid = cpg148_pictures.pid AND ( aid IN () )" on 0

mySQL error: 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 1

[studeo]

Another update: comments, number of views, etc. from albums excluded using this mod are also excluded from all data links in cpg from the index page as well as inside the actual albums.

[studeo]

Hello:

Did you have a chance to evaluate this issue with this plugin yet? Im posting here to reactivate the thread and see if there has been any fixes designed yet.

Thank You

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=24350.msg181449#msg181449

[studeo]

Things were woking well with the new link to the code you posted above. But I ran into another problem. The last comments link from the index page brings up a blank page with a database query error. I uninstalled the plugin and there was no error.

Thanks