Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.The bug is:
* warning: pg_query() [function.pg-query]: Query failed: ERREUR: pour SELECT DISTINCT, ORDER BY, les expressions doivent apparaître dans la liste SELECT in /home/..../www/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT DISTINCT nid, type, title from node WHERE type IN ('album','story','zikstory','ziksong','page','quiz','siteweb','star') AND created >= 1278907200 AND created < 1279079999 AND status = 1 ORDER BY created DESC in /home/.../www/sites/all/modules/simplenews_digest/simplenews_digest.module on line 468.
Comments
Comment #1
azoungrana commentedComment #2
azoungrana commentedORDER BY syntax is:
ORDER BY expression [ ASC | DESC | USING opérateur ] [, ...]
And the SQL Language says that "expression" must be included in the columns specified in SELECT.
To solve the problem, just replace in line 455:
if (!empty($terms) && $terms != 0) {
$query = "SELECT DISTINCT n.nid, n.type, n.title from {node} n " .
...
} else {
$query = "SELECT DISTINCT nid, type, title from {node} " .
...
}
By:
if (!empty($terms) && $terms != 0) {
$query = "SELECT DISTINCT n.nid, n.type, n.title, n.created from {node} n " .
...
} else {
$query = "SELECT DISTINCT nid, type, title, created from {node} " .
...
}
Thanx
Comment #3
azoungrana commentedComment #4
azoungrana commented