[drupal-devel] [bug] book.module needs ORDER BY columns in SELECT portion of queries

Daniel Lyons drupal-devel at drupal.org
Wed Jul 20 04:04:21 UTC 2005

Issue status update for 
Post a follow up: 

 Project:      Drupal
 Version:      4.6.2
 Component:    book.module
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  Daniel Lyons
 Updated by:   Daniel Lyons
 Status:       patch
 Attachment:   http://drupal.org/files/issues/book.module_4.patch (2.71 KB)


I'm running Drupal on PostgreSQL 8.0.1 and had to modify the book
module a little bit to make it work on my system. It's pretty
minor--you just have to ensure that you are also SELECTing all the
columns you're using in your ORDER BY expression, otherwise PostgreSQL
will reject the query.

These changes should have zero ramifications for MySQL installations.

Here is a patch against 4.6.2 which makes these changes.

Daniel Lyons

More information about the drupal-devel mailing list