Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: exclude album from random block on index  (Read 5142 times)

0 Members and 1 Guest are viewing this topic.

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
exclude album from random block on index
« on: October 13, 2006, 08:52:27 pm »
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.
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: exclude album from random block on index
« Reply #1 on: October 14, 2006, 08:59:46 am »
Logged
‍I don't answer to PM with support question
Please post your issue to related board

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
Re: exclude album from random block on index
« Reply #2 on: October 14, 2006, 04:48:35 pm »
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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: exclude album from random block on index
« Reply #3 on: October 14, 2006, 04:55:38 pm »
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.
Logged

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
Re: exclude album from random block on index
« Reply #4 on: October 14, 2006, 05:09:24 pm »
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
Logged

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
Re: exclude album from random block on index
« Reply #5 on: October 15, 2006, 04:35:28 am »
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
Logged

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
Re: exclude album from random block on index
« Reply #6 on: October 15, 2006, 04:40:24 am »
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
Logged

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
Re: exclude album from random block on index
« Reply #7 on: October 15, 2006, 04:53:15 am »
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.
Logged

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
Re: exclude album from random block on index
« Reply #8 on: November 13, 2006, 05:11:25 pm »
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
Logged

Nibbler

  • Guest
Re: exclude album from random block on index
« Reply #9 on: November 13, 2006, 11:41:39 pm »
Logged

studeo

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 50
Re: exclude album from random block on index
« Reply #10 on: November 16, 2006, 04:23:38 am »
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
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.046 seconds with 19 queries.