When I am viewing as a list I see 10 images (no paging). When I click to view as thumbs I see 48 thumbs. Clearly there is something very different in the code between the "Display as list" and "Display as thumbs". As an exercise I turned off JS in my browser and reloaded the pages. No different.

Comments

reg’s picture

reg commented

This is the line (line # 114) that causes this in media_admin_list():

  $query->join('users', 'u', 'f.uid = u.uid');

If you change it to this you get all the images back:

  $query->leftjoin('users', 'u', 'f.uid = u.uid');

And I think I know why. When I looked at the file_managed table it referenced two users that I deleted but moved the content to the anonymous user. I suspect that drupal didn't also change the uid in the file_managed table.

What I don't know is whether this is by design in Drupal or not. However, making the change above fixes the problem here for now but I suspect that the real fix needs to be in Drupal so this is just an interim workaround.

reg’s picture

reg commented

I logged an issue for the Drupal core on this: http://drupal.org/node/1461042

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Closed (duplicate)

Let's fix the core issue in #1461042: When a user gets "cancelled reassign" uid's in the table file_managed don't get updated to the new uid (0) making them orphaned then!