Nov

WordPress Plugin NextGEN Gallery Sorting Bugfix

The changing the sort options of WordPress plugin “NextGEN Gallery” doesn’t affect on the images of the gallery sorted by tags. To fix the bug, do the following changes in nextgen-gallery\lib\ngg-db.php

set

// Check for the exclude setting
 
$ngg_options = get_option('ngg_options');
$gal_sort = $ngg_options['galSort'];
$gal_sort_dir = $ngg_options['galSortDir'];
 
if ( $gal_sort_dir == 'RAND' ) {
   $order_clause = 'ORDER BY rand() ';
} elseif ( $gal_sort_dir == 'DESC' ) {
   $order_clause = ' ORDER BY t.'.$gal_sort.' DESC';
} else {
   $order_clause = ' ORDER BY t.'.$gal_sort.' ASC';
}

instead of

// Check for the exclude setting
 
$order_clause = ($order == 'RAND') ? 'ORDER BY rand() ' : ' ORDER BY t.pid ASC' ;

in the function find_images_in_list.

Getting the sort options from the database that is set in this function for not affecting on the work of other functions.

Tags: bugfix, NextGEN, plugin, Wordpress

Wordpress

11 Comments on WordPress Plugin NextGEN Gallery Sorting Bugfix

TFM says:

February 10, 2010 at 05:19

Fix works perfect – thank you so much!
Julia says:

November 11, 2010 at 02:12

This didn’t work for me. Any idea why?
Ruben Sargsyan says:

November 11, 2010 at 10:30

Julia,

Please write the versions of WordPress and the plugin “NextGEN Gallery” that you use and I’ll try top help you.

Thank you.
Joanne says:

June 27, 2011 at 20:35

Thanks for posting this fix. I wondered if anyone corrected the sorting bug in next-gen gallery for the galleries by tag. Totallly awesome of you to post it — thanks it worked great just as you posted it.
13 says:

October 29, 2011 at 02:30

This worked for me for the latest version of WordPress and NextGEN Gallery as of November 2011. Thank you so much!
Ruben Sargsyan says:

November 18, 2011 at 12:07

Joanne and 13, it is really great to help you!!!!

Thanks.
Kees says:

November 26, 2011 at 13:15

Thanks! Been struggling with this a while!
Cant you persuade Alex to include this in the code
Ruben Sargsyan says:

November 29, 2011 at 22:03

Hi Kees,

Sorry, but it is not my problem!!!

Thanks.
chris vo says:

December 31, 2011 at 02:56

YOU SOLVED MY PROBLEM! THANK YOU
lisa says:

January 1, 2012 at 18:59

Thank you for your post! I found it very useful and fast for my website!
Peter Cunningham says:

January 16, 2012 at 20:56

Thanks very much, that worked perfectly for me too.