[Done 1.3.9] Media Collection - Clip Order jumbled

I am using 1.3.8a and on one particular music product there are a few clips which "refuse" to sort into the correct numerical order which I have assigned.

I have tried to fix this in phpMyAdmin and cannot resolve the problem here either.

Here is a link to the page where you can see the issue: http://www.campbenaiah.org.au/store/index.php?main_page=product_music_info&products_id=18

To make the media collection sort alphabetically on the filename, make the following change:

/includes/modules/media_manager.php
around lines 27-29 you'll see the following code. Make the change shown in red (adding the ORDER BY clause):```
} else {
$zv_clips_query = "select * from " . TABLE_MEDIA_CLIPS . "
where media_id = '" . (int)$zq_media_manager->fields['media_id'] . "'[B] order by clip_filename[/B]";

:bigups:

Sweet! That did it!

Thanks, Dr. Byte.

It seems that some punctuation marks (eg, apostrophes) had been causing some of the problem. I ended up taking them out and that corrected most, but not all of the problems--until I added your suggested fix.

Everything looks great now!