Random pix not random at all

[metropolis2003]

Hi,

probably a MySQL bug (ORDER BY RAND()), but in my CPG installation, the random pictures shown on the gallery main page are not random at all. I have set it to display four random pictures, however one of my total 50 pictures is being displayed about 95% of the time.

There are 2-3 other pictures shown much more often (I'd say about 60%). Those "not randomized" pictures where the numbers 2,3,4,5 when I (batch-)uploaded the pictures. The first picture I uploaded however does not show a significant display peak.

Anyone had similar problems? How can I hack the randomize function use a different randomizer? (Because I begin to hate that picture  :twisted: )

[Nibbler]

You could try altering it to ORDER BY RAND() ASC or DESC see if that makes any difference.