After enabling flag_note's default views I went to a piece of content and click the "Flag Notes" tab. I was presented the following error
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), note, users_flag_note.name AS users_flag_note_name, ' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), note, users_flag_note.name AS users_flag_note_name, users_flag_note.uid AS users_flag_note_uid, flag_note_node.timestamp AS flag_note_node_timestamp, flag_note_node.fnid AS flag_note_node_fnid, flag_note_node.uid AS flag_note_node_uid FROM node node INNER JOIN flag_note flag_note_node ON node.nid = flag_note_node.content_id INNER JOIN users users_flag_note ON flag_note_node.uid = users_flag_note.uid WHERE node.nid = 48 ORDER BY flag_note_node_timestamp DESC LIMIT 0, 50 in /mnt/stor2-wc1-dfw1/394720/www.ivawsandbox.com/web/content/sites/all/modules/Views/views/includes/v... on line 755.
The module is fantastic, if I can get it working with views it will be everything I need.
Comments
Comment #1
gunzip commentedcan you please provide the exported view (and the version of the view module) ?
(do you use a DISTINCT filter ?)
Comment #2
gunzip commentedComment #3
gunzip commenteddefault views don't ship with the module anymore.