I'm using Drupal 7 and I have a content type, Picture, which includes an image field. Users use this to add image to the site.
Sometimes, however, there is no data on the server. For example, if I copy the database from my production to my testing server, the image files will be registered in the db but they don't actually exist on the testing server, so the pictures cannot be displayed.
I would like to create a view that shows these images-- the data is in the DB, but the file does not actually exist.
I created a view for my content type Picture and added the following Filter Criteria
- Image: fid- empty
- OR File size- empty (Through File Usage: File relationship)
However, this does not show pics that exist in the DB but not in the filesystem.
Is there a way to do this in views, or is there no way to test if the file actually exists?