[drupal-devel] [bug] List of nodes from admin/node are not sorted

[kbahey]

Issue status update for http://drupal.org/node/22721

 Project:      Drupal
 Version:      4.6.0
 Component:    node system
 Category:     bug reports
 Priority:     normal
 Assigned to:  kbahey
 Reported by:  kbahey
 Updated by:   kbahey
 Status:       patch

The display from the admin/node page is not sorted by anything. This is
confusing.


In order to make the display make sense, I recommend sorting it by the
date of last change.


Here is a patch for doing this. Line 912 of node.module in 4.6:


$result = pager_query('SELECT n.*, u.name, u.uid FROM {node} n '. $join
.' INNER JOIN {users} u ON n.uid = u.uid '. $where, 50, 0, NULL, $args);


Should be:


$result = pager_query('SELECT n.*, u.name, u.uid FROM {node} n '. $join
.' INNER JOIN {users} u ON n.uid = u.uid '. $where . " ORDER BY
n.changed DESC ", 50, 0, NULL, $args);




kbahey