Wrong order of photos in Top Rated?

[peakoverload]

I'll be the first to say that the voting system in Coppermine has always confused the hell out of me and I am having a bit of a problem with it at the moment.

I run Coppermine in a frame within my Mambo driven site (www.peakoverload.com). On Coppermine's Index page I have it set uip to show 32 positions of Top Rated photos but recently a number of members have been noticing some weird movement of their photos on this page. In that photos that featured highly up the page now appear right at the bottom or not at all. Now this could be put down to lots of new votes on other photos but we have all noticed that the order of some photos appears to be wrong.

For example at the moment the photos in 20th (photo ID 1652) and 21st (photo ID 1663) position are I think the wrong way around.

Photo 1652 has a score of 4.7/5 with 3 votes
Photo 1663 has a score of 5/5 with 3 votes

Looking in the database
Photo 1652 has a score of 9333
Photo 1663 has a score of 10000

So surely photo 1663 should be in 20th place and photo 1652 should be in 21st place, shouldnt it?

My setup up is as follows, I'm running CPG 1.3.1:

2x categorys

Category 1 has 1 album
Category 2 has 3 albums

I then have 13 other albums that are not in any category at all

The two photos I mentioned come from 2 different albums that are not in either of the two categorys.

This isnt the only example either. The two photo that are currently in 9th (PID 159) and 10th (PID 1144) place are also the wrong way around.

PID 159 has a score of 4.5/5 with 4 votes
PID 1144 has a score of 4.7/5 with 4 votes

So shouldnt these also be the other way around?

[peakoverload]

Here is the debug info if its any help:

USER:
------------------
Array
(
    [ID] => 8e2ce7f545cc03f06bfee855692f8f09
    [am] => 1
    [lang] => english
    [liv] => Array
        (
           

• => 1652
              [1] => 1483
              [2] => 1639
              [3] => 159
              [4] => 1144
          )
  
      [sort] => dd
      [search] => ###G5
      [uid] => 1
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_group] => 1
      [user_active] => YES
      [user_name] => *****
      [user_password] => ********
      [user_lastvisit] => 2005-01-15 12:08:18
      [user_regdate] => 2004-06-12 14:20:55
      [user_group_list] =>
      [user_email] =>
      [user_website] =>
      [user_location] =>
      [user_interests] =>
      [user_occupation] =>
      [user_actkey] =>
      [user_favpics] =>
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 0
      [ufc_max] => 1
      [ufc_min] => 1
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 0
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 1
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
      [groups] => Array
          (
              [1] => 1
          )
  
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg130_filetypes;
      [1] => SELECT * FROM cpg130_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '8b9a3c4ad9955d5702173d77ed1eea9b'
      [2] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg130_usergroups WHERE group_id in (1)
      [3] => SELECT group_name FROM  cpg130_usergroups WHERE group_id= 1
      [4] => DELETE FROM cpg130_banned WHERE expiry < 1105947866
      [5] => SELECT * FROM cpg130_banned WHERE ip_addr='80.3.69.175' OR ip_addr='80.3.69.175' OR user_id=1
      [6] => SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND votes >= '2'
      [7] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, pic_rating, votes, aid FROM cpg130_pictures WHERE approved = 'YES' AND votes >= '2'  ORDER BY ROUND((pic_rating+1)/2000) DESC, votes DESC  LIMIT 0 ,12
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [album] => toprated
      [cat] => 0
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.10 - OK
  ------------------
  mySQL version: 4.0.22-standard-log
  ------------------
  Coppermine version: 1.3.1
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version bundled (2.0.28 compatible)
  FreeType Support enabled
  FreeType Linkage with freetype
  GIF Read Support enabled
  GIF Create Support enabled
  JPG Support enabled
  PNG Support enabled
  WBMP Support enabled
  XBM Support enabled
  ==========================
  Module: mysql
  ------------------
  Active Persistent Links 0
  Active Links 1
  Client API version 3.23.49
  MYSQL_MODULE_TYPE builtin
  MYSQL_SOCKET /var/tmp/mysql.sock
  MYSQL_INCLUDE no value
  MYSQL_LIBS no value
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
  open_basedir | /home/peakover/:/usr/lib/php:/usr/local/lib/php:/tmp | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | -1 | -1
  upload_max_filesize | 2M | 2M
  post_max_size | 55M | 55M
  ==========================
  Page generated in 0.16 seconds - 8 queries in 0.019 seconds - Album set :

[peakoverload]

I've now applied the hack listed here http://forum.coppermine-gallery.net/index.php?topic=10009.0 so the photos I mentioned are no longer in the order I listed here. I not sure if this hack is the solution I am looking for or not. Apologies for the cross posting I did search before posting this thread but didnt find anything at the time and am still confused by what the hack is doing 

[Casper]

Yes, you found the correct thread, and answer, which has been applied to the next version.