Delete image works but warning: array_flip(): Can only flip STRING and INTEGER values! in DrupalDefaultEntityController->load()

Just some thoughts to help fix the problem:

Doing a search found a different problem but with a similar message, one of the remedies suggested may be useful for solving this issue: http://drupal.org/node/1811850#comment-6597686

Therefore, the thinking so far would be one or more of:
- to make code in entity.inc more defensive - such a fix being similar to the remedy in: http://drupal.org/node/1811850#comment-6597686
- to make sure that the parameters are valid that are passed by the calling code to entity.inc

Yes, media 2.x - 7.x-2.0-unstable6 to be exact. I will look at the issue you mention but perhaps it is not a duplicate as in my case the gallery is not broken as such, it's just that the error message is shown for each image that I have deleted via the delete option that the media gallery provides - the other images still display OK. Thanks for your suggestion.

By the way, I have been able to use the development version of media gallery to get it working with media 2.x - credit to those who worked on media gallery (rather than myself). I have documented my steps to get it working here - comment 102: http://drupal.org/node/1244204#comment-6678836

Drupal user @leanderl confirms they can reproduce my same problem in this issue, their comment is made in this other issue here: http://drupal.org/node/1244204#comment-6708178

I can confirm that the root cause is that the entry for the deleted image is not removed from field_data_media_gallery_media table in the Drupal MySQL database. This is the equivalent of a null/dangling pointer in other software. The remedy would be to add code to the media_gallery to remove the entry from the field_data_media_gallery_media table.

The root cause is illustrated in the following screen shot showing the relationship between the error, the Drupal MySQL tables including field_data_media_gallery_media, and the media files themselves.

(locally on drupal.org :- )

(same screenshot also available externally here:- )

http://i46.tinypic.com/b67mtx.jpg

A work around would be to do a standard MySQL delete/drop of the specific entries in field_data_media_gallery_media that refer now to the deleted files.

A work around would be to do a standard MySQL delete/drop of the specific entries in field_data_media_gallery_media that refer now to the deleted files.

I have tried this - my own suggestion - and it does not cause the error to no longer appear. Clean up to remove the deleted file references will also be necessary in the following database tables (but cleaning these up also still does not remedy the problem)

• image dimensions
• field_revision_field_file_image_title_text
• field_revision_field_folder

So although I was correct to point out that there were references to deleted files in some MySQL tables. I was incorrect to assume that these are the only cause of the error message.

Further update which eliminates the error message that this issue is about ("Delete image works but warning: array_flip(): Can only flip STRING and INTEGER values! in DrupalDefaultEntityController->load()" )

Steps:

1. After I cleaned up the references to the deleted files in the tables that I mentioned in comment #5 and comment #7
2. I then went into Edit gallery: /node/22/edit did nothing here and clicked Save. The error does not now appear.

From this I'm wondering if it is necessary to clean up the entries myself in the database tables or just delete the images via the gallery, and then go into edit the gallery and just click save.

Clarified setup to recreate the problem