Files view duplicating images after adding either of "draggableviews: file" or "(flag) Flags: Flag link" field [#1990914]

Steps to reproduce this issue:

- Modules require:
1. Draggableviews
2. Flag
3. Flag_files

- Create new content type "multifiles"
Add "image" image field with "number of values" = "unlimited"

- Add "multifiles" content having multiple images per content.

- Create new "files" flag named as "markfile"

- Create new view where "show" = "files"
Add relationships :
1. File: Content using multifiles Images
2. Flags: markfile (by current user)

Add fields :
1. (field_multifiles_images) Content: multifiles Images
2. (flag) Flags: Flag link
3. Draggableviews: File

Format : Table

- Save view

- Now when you run the view you will see that images are getting duplicated.

Comments

Comment #1

Mołot commented 9 May 2013 at 13:15

Can this bug be duplicated without any modules except views (and it's dependences)?
If it cannot, it's more like a problem with draggableviews and flag modules, or with the way you define relationships.

Would you care to paste SQL generated by your view? And schema of the tables it's using or CREATE TABLE statements for them, for easier reference?

Comment #2

mandarmbhagwat78 commented 13 May 2013 at 07:34

Yes, this bug is duplicated without draggableviews and flag modules. You can add any field or relationship to reproduce this issue.

Here is the view query:

SELECT DISTINCT field_workspace_pdf_images_file_managed.nid AS field_workspace_pdf_images_file_managed_nid, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.delta AS field_workspace_pdf_images_file_managed__field_data_field_wo, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.language AS field_workspace_pdf_images_file_managed__field_data_field_wo_1, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.bundle AS field_workspace_pdf_images_file_managed__field_data_field_wo_2, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.field_workspace_pdf_images_fid AS field_workspace_pdf_images_file_managed__field_data_field_wo_3, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.field_workspace_pdf_images_alt AS field_workspace_pdf_images_file_managed__field_data_field_wo_4, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.field_workspace_pdf_images_title AS field_workspace_pdf_images_file_managed__field_data_field_wo_5, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.field_workspace_pdf_images_width AS field_workspace_pdf_images_file_managed__field_data_field_wo_6, field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.field_workspace_pdf_images_height AS field_workspace_pdf_images_file_managed__field_data_field_wo_7, file_managed.fid AS fid, flag_content.content_id AS flag_content_content_id, 'node' AS field_data_field_workspace_pdf_images_node_entity_type
FROM 
{file_managed} file_managed
INNER JOIN {field_data_field_workspace_pdf_images} field_data_field_workspace_pdf_images ON file_managed.fid = field_data_field_workspace_pdf_images.field_workspace_pdf_images_fid AND (field_data_field_workspace_pdf_images.entity_type = 'node' AND field_data_field_workspace_pdf_images.deleted = '0')
INNER JOIN {node} field_workspace_pdf_images_file_managed ON field_data_field_workspace_pdf_images.entity_id = field_workspace_pdf_images_file_managed.nid
LEFT JOIN {flag_content} flag_content_file_managed ON file_managed.fid = flag_content_file_managed.content_id AND (flag_content_file_managed.fid = '2' AND flag_content_file_managed.uid = '1')
LEFT JOIN {field_data_field_workspace_pdf_images} field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images ON field_workspace_pdf_images_file_managed.nid = field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.entity_id AND (field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.entity_type = 'node' AND field_workspace_pdf_images_file_managed__field_data_field_workspace_pdf_images.deleted = '0')
LEFT JOIN {flag_content} flag_content ON file_managed.fid = flag_content.content_id AND (flag_content.fid = '2' AND flag_content.uid = '1' AND flag_content.sid = '0')
WHERE (( (field_workspace_pdf_images_file_managed.nid = '801' ) ))