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 :(
Comment | File | Size | Author |
---|---|---|---|
node_page_default_distinct.patch | 499 bytes | Berdir | |
Comments
Comment #1
Josh Waihi CreditAttribution: Josh Waihi commentedcool! it this an issue that MySQL doesn't have issue with this? It will become a DX WTF
Comment #2
Dries CreditAttribution: Dries commentedShocked to see we still have an error in this query (of all queries).
Committed to CVS HEAD though.