Tracking this one down. I believe it has to do with content types with imagefields but with no nodes yet.
SELECT DISTINCT(images.fid), f.filepath as path, n.nid, images.data FROM (SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_product WHERE field_image_cache_fid IS NOT NULL UNION SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_photography WHERE field_image_cache_fid IS NOT NULL UNION SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_page WHERE field_image_cache_fid IS NOT NULL UNION SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_vt_block WHERE field_image_cache_fid IS NOT NULL UNION SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_360_virtual_tour WHERE field_image_cache_fid IS NOT NULL UNION SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_360_photography WHERE field_image_cache_fid IS NOT NULL UNION SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_test WHERE field_image_cache_fid IS NOT NULL UNION SELECT nid,field_image_cache_fid as fid, field_image_cache_data as data FROM content_type_high_rez WHERE field_image_cache_fid IS NOT NULL) as images LEFT JOIN node n ON n.nid = images.nid LEFT JOIN files f on f.fid = images.fid ORDER BY n.changed DESC in /home/xxx/public_html/sites/all/modules/imagefield_assist/imagefield_assist.module on line 790.
Comments
Comment #1
lourenzo commentedOK, I'll try to reproduce this one ASAP
Comment #2
lourenzo commentedJust fixed in cvs branch, which soon will update the package.
Could you please test if it's ok now?
Thanks
Comment #3
sgriffin commentedThanks! It works now.
I think a lot of people have been waiting for this module for a very long time.
Comment #4
lourenzo commentedComment #5
lourenzo commented