[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 
http://drupal.org/node/27108
Post a follow up: 
http://drupal.org/project/comments/add/27108

 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)

Hi,


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