I get this code when i select "Relativity: Parent Title" in the filter. Any help would be greatful
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid) AS relativity_parent_node_nid FROM node node LEFT JOIN relat' at line 1 query: SELECT DISTINCT(node.nid), relativity_parent_node.title AS relativity_parent_node_title, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, relativity_parent_ DISTINCT(node.nid) AS relativity_parent_node_nid FROM node node LEFT JOIN relativity relativity ON node.nid = relativity.nid LEFT JOIN node relativity_parent_node ON relativity.parent_nid = relativity_parent_node.nid WHERE (node.type IN ('mangachapter')) AND (node.status = '1') GROUP BY node.nid, relativity_parent_node_title ORDER BY relativity_parent_node_title ASC, relativity_parent_node_title DESC LIMIT 0, 100 in /home/skanim/public_html/includes/database.mysql.inc on line 172.
Comments
Comment #1
karens commentedThis is a Relativity issue, not a Views issue. That module sets up its own Views handling.
Comment #2
merlinofchaos commentedQuick note: This is being screwed up by db_rewrite_sql
You can fix this by adjusting the alias for the relatively node to not end in 'node'. 'node_' would work. That'd prevent db_rewrite_sql from thinking it should turn relativity_parent_node.nid inDISTINCT.
Comment #3
nainainai commentedhow do i do that? im dont know anything about php or db_rewrite_sql
Comment #4
mendelson commentedAnyone an idea how to resolve this?
I have the same problem. :((