MODX Staff
Run away!
Nothing will be sortable. Ditto and Wayfinder will return odd results.
Sounds clear, thanks.
Run away!
Nothing will be sortable. Ditto and Wayfinder will return odd results.
<?php
/*
Plugin Name: 123 No Group By ID
Plugin URI: http://schnurpsel.de/wordpress-und-die-suboptimale-mysql-optimierung-5051-74/
Description: Ändert bei WP das GROUP BY id in GROUP BY post_date (Problem ab MySQL 5.0.51).
Author: Ingo Henze
Version: 0.12
Author URI: http://putzlowitsch.de/
*/
// GROUP BY auswerten
function plw123ngb_posts_groupby( $groupby ) {
if( preg_match( "/(|[ ,.])id(|[ ,])/i", $groupby ) ) {
// sonst GROUP BY auf post_date setzen
$groupby = 'post_date';
}
return $groupby;
}
add_filter( 'posts_groupby', 'plw123ngb_posts_groupby' );
?>
) to adapt this plugin usable for MODx? Instead of hacking the snippets?
Wayfinder and Ditto will return weirdly-sorted results unless they’re changed in the same way.
technical hotline don’t know any about updates/changes. And all in all the performance of strato’s db is bad. Instead of hacking snippets we will change.