coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: metropolis2003 on March 03, 2004, 03:21:17 PM

Title: Random pix not random at all
Post by: metropolis2003 on March 03, 2004, 03:21:17 PM
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: )
Title: Random pix not random at all
Post by: Nibbler on March 03, 2004, 03:52:02 PM
You could try altering it to ORDER BY RAND() ASC or DESC see if that makes any difference.