Error (half german, why is PostgreSQL doing that to me?!):

PDOException: SQLSTATE[42P10]: Invalid column reference: 7 FEHLER: bei SELECT DISTINCT müssen ORDER-BY-Ausdrücke in der Select-Liste erscheinen LINE 6: ORDER BY sticky DESC, created DESC ^: SELECT DISTINCT n.nid AS nid FROM {node} n INNER JOIN {node_access} na ON na.nid = n.nid WHERE (promote = :db_condition_placeholder_0) AND (status = :db_condition_placeholder_1) AND(( (na.gid = :db_condition_placeholder_2) AND (na.realm = :db_condition_placeholder_3) )OR( (na.gid = :db_condition_placeholder_4) AND (na.realm = :db_condition_placeholder_5) ))AND (na.grant_view >= :db_condition_placeholder_6) ORDER BY sticky DESC, created DESC LIMIT 10 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => all [:db_condition_placeholder_4] => 0 [:db_condition_placeholder_5] => user_relationship_node_access_author [:db_condition_placeholder_6] => 1 ) in node_page_default() (line 2473 of node/node.module).

Fix is easy and I probably broke that myself when porting node.module to DBTNG :(

CommentFileSizeAuthor
node_page_default_distinct.patch499 bytesBerdir
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Josh Waihi’s picture

Status: Needs review » Reviewed & tested by the community

cool! it this an issue that MySQL doesn't have issue with this? It will become a DX WTF

Dries’s picture

Status: Reviewed & tested by the community » Fixed

Shocked to see we still have an error in this query (of all queries).

Committed to CVS HEAD though.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.