I'm am running a local instance of my production drupal installation. Both instances have the same bug that is prevent image cache images from displaying. After much clue following, I ended up attempting to create a view to see if the SQL is a problem, and that's what it is, but I don't know what is causing it or how to fix it. Here's the error:
user warning: Unknown column 'node_data_field_image_cache.delta' in 'field list' query: SELECT DISTINCT node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_data_field_image_cache.field_image_cache_fid AS node_data_field_image_cache_field_image_cache_fid, node_data_field_image_cache.field_image_cache_list AS node_data_field_image_cache_field_image_cache_list, node_data_field_image_cache.field_image_cache_data AS node_data_field_image_cache_field_image_cache_data, node_data_field_image_cache.delta AS node_data_field_image_cache_delta, RAND() AS _random FROM node node LEFT JOIN content_field_collections_ref node_data_field_collections_ref ON node.vid = node_data_field_collections_ref.vid LEFT JOIN content_field_image_cache node_data_field_image_cache ON node.vid = node_data_field_image_cache.vid WHERE (node.type in ('publication')) AND (node_data_field_collections_ref.field_collections_ref_nid = 0) ORDER BY _random ASC LIMIT 0, 1 in C:\xampp\htdocs\drupal\sites\all\modules\views\includes\view.inc on line 771.
Even more puzzling, is that another developer here is running the same code as I am and we're both using the same development database. I tried to duplicate the error on his installation, but the query is constructed properly:
SELECT node.nid AS nid, node_data_field_image_cache.field_image_cache_fid AS node_data_field_image_cache_field_image_cache_fid, node_data_field_image_cache.field_image_cache_list AS node_data_field_image_cache_field_image_cache_list, node_data_field_image_cache.field_image_cache_data AS node_data_field_image_cache_field_image_cache_data, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, RAND() AS _random FROM node node LEFT JOIN content_field_image_cache node_data_field_image_cache ON node.vid = node_data_field_image_cache.vid WHERE node.type in ('publication') ORDER BY _random ASC
