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

lourenzo’s picture

OK, I'll try to reproduce this one ASAP

lourenzo’s picture

Status: Active » Needs review

Just fixed in cvs branch, which soon will update the package.

Could you please test if it's ok now?

Thanks

sgriffin’s picture

Thanks! It works now.
I think a lot of people have been waiting for this module for a very long time.

lourenzo’s picture

Status: Needs review » Fixed
lourenzo’s picture

Status: Fixed » Closed (fixed)