[wpmu-trac] [WordPress MU Trac] #291: Bugs "SortBy" in Blogs/Users with internationalisation

[WordPress MU Trac]

#291: Bugs "SortBy" in Blogs/Users with internationalisation
---------------------------+------------------------------------------------
 Reporter:  momo360modena  |       Owner:  somebody
     Type:  defect         |      Status:  new     
 Priority:  highest        |   Milestone:  WPMU 2.0
Component:  component1     |     Version:  2.0     
 Severity:  blocker        |    Keywords:          
---------------------------+------------------------------------------------
 In wpmu-blogs.php et wpmu-users.php (same concept)

 {{{
 $posts_columns = array(
         'id'           => __('ID'),
         'blogname'     => __('Blog Name'),
         'last_updated' => __('Last Updated'),
         'registered'   => __('Registered'),
         'users'        => __('Users'),
         'plugins'      => __('Actions')
 );
 }}}
 Title colunms are internationalized

 But your test
 Example :
 {{{
 if( $_GET[ 'sortby' ] == 'Registered' )
 }}}
 or
 {{{
 elseif( $_GET[ 'sortby' ] == 'LastUpdated' ) {
 }}}

 are not internationalized...

 And cause a bug :
 {{{
 WordPress database error: [You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near 'ASC LIMIT 0, 60' at line 3]
 SELECT * FROM wp_blogs WHERE site_id = '1' ASC LIMIT 0, 60
 }}}

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/291>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser