Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Problem with Top Rated page.  (Read 5145 times)

0 Members and 1 Guest are viewing this topic.

gosha

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Problem with Top Rated page.
« on: December 17, 2004, 07:59:32 pm »

Hi!

I have a strange problem with a "top rated" page, only first image (rating 4) is displayed correctly. Any other images after a cliecking on a thumbnail loads absolutley another image, that present on a "top rated" page on another position. This is not the case when the rating has been changed between the page loading and clicking on a thumbnail, I know that I'm alone on the site. Anyone knows something about it?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Problem with Top Rated page.
« Reply #1 on: December 19, 2004, 06:48:18 am »

link?

Joachim
Logged

gosha

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: Problem with Top Rated page.
« Reply #2 on: December 20, 2004, 12:31:21 am »

I'm sorry, but I'm preffer to email the link the the login, this is a functional private gallery...
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Problem with Top Rated page.
« Reply #3 on: December 20, 2004, 01:35:44 am »

then I can't help you, as I prefer not to be emailed nor contacted by PM. I'm not so sure you have understood the nature of the internet though ::):

Joachim
Logged

gosha

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: Problem with Top Rated page.
« Reply #4 on: December 20, 2004, 09:18:29 am »

Hi,

Address is http://testcf.island.ee/

I've created the thest installation with the test users and test pics, placed a test votes and got the same result.

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Problem with Top Rated page.
« Reply #5 on: December 20, 2004, 09:24:54 am »

unable to replicate this on the test page you posted about, it shows expected behaviour. Are you sure we're talking about "top rated" and not "most viewed"?

Joachim
Logged

gosha

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: Problem with Top Rated page.
« Reply #6 on: December 20, 2004, 09:32:23 am »

Yes, top rated. First 2 images displays expected after a click, but all another - dont. I cleared the browser's cache, and even tried to check with another browser, still the same.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Problem with Top Rated page.
« Reply #7 on: December 20, 2004, 09:40:21 am »

OK, now I can see what you mean. This is being caused by the small number of votes you have, and the fact that you allow pics with only one vote to appear on the top rated page. I'm not sure wether a fix has been posted already, please search the board.

Joachim
Logged

gosha

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: Problem with Top Rated page.
« Reply #8 on: December 20, 2004, 11:35:52 pm »

Did not found any solution  ???

 ;) any advices welcome
Logged

surfer

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
    • http://photoalbum.mario.org
Re: Problem with Top Rated page.
« Reply #9 on: December 24, 2004, 05:23:42 pm »

I had the same problem. I've solved it by doing this:

Replace the following in /include/functions.inc.php

Code: [Select]
ORDER BY ROUND((pic_rating+1)/2000) DESC, votes DESC $limit");
in

Code: [Select]
ORDER BY ROUND((pic_rating+1)/2000) DESC, votes DESC, pid DESC $limit");
Surfer
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.