Query on Line 118 needs update to be compliant with PostgreSQL 8.3 backend

estoyanov - August 3, 2009 - 14:25
Project:Booktree
Version:6.x-1.2
Component:Code
Category:bug report
Priority:normal
Assigned:Uccio
Status:closed
Description

Current code results in following error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /home/atlasproject/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT DISTINCT n.nid as nid, m.plid as plid, m.mlid as mlid, n.title as title FROM book as b inner join menu_links as m ON b.mlid = m.mlid inner join node as n ON n.nid = b.nid WHERE m.plid = '341' AND n.status = 1 ORDER by m.weight, n.title, n.nid, m.plid, m.mlid in /home/atlasproject/drupal-6.13/sites/all/modules/booktree/booktree.module on line 118.weight

Line #118 which is now
$sql= "SELECT DISTINCT n.nid as nid, m.plid as plid, m.mlid as mlid, n.title as title

should become
$sql= "SELECT DISTINCT n.nid as nid, m.plid as plid, m.mlid as mlid, n.title as title, m.weight

#1

Uccio - August 4, 2009 - 07:39
Assigned to:Anonymous» Uccio

estoyanov,

thank you for your feedback,
I fix the issue asap.

#2

Uccio - August 10, 2009 - 22:00
Status:active» closed

OK,

get the new version!

 
 

Drupal is a registered trademark of Dries Buytaert.