Active
Project:
Filefield Stats
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
12 May 2010 at 10:42 UTC
Updated:
12 May 2010 at 10:42 UTC
Hi!
Thanks for this module.
I found a bug, when you list the field in one view in 'File' basic type, it works fine, but when you try to add this field by relation, for example, working with the 'Node' basic type view, and adding a relation with a filefield, and after you add 'download_corunt' as field, you get a sql error like the following:
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 'LEFT JOIN content_type_recurso_didactico node_data_field_rd_recurso ON node.vid ' at line 6 query: SELECT node.nid AS nid, node.title AS node_title, node.language AS node_language FROM node node LEFT JOIN filefield_stats filefield_stats_files ON filefield_stats_download_count = filefield_stats_files. LEFT JOIN content_type_recurso_didactico node_data_field_rd_recurso ON node.vid = node_data_field_rd_recurso.vid LEFT JOIN files files_node_data_field_rd_recurso ON node_data_field_rd_recurso.field_rd_recurso_fid = files_node_data_field_rd_recurso.fid WHERE (node.type in ('recurso_didactico')) AND (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) LIMIT 0, 10 in /home/dev/sites/default/modules/views/includes/view.inc on line 771.