Media Mover reports files have not finished processing, but all files are marked as MMA_FILE_STATUS_COMPLETE_COMPLETE in dbase

There is a cache issue that can cache the file before it is completed, despite the fact that the file did actually complete. This has been fixed in the development branch. Try going to admin > settings > performance and flushing your caches- this should hopefully take care of the issue

Oh, and if you can confirm that your files arrived, you can always just set those files status with mysql until we get this figured out.

You'd just need to do it in media_mover_files, something like:

UPDATE {media_mover_files} SET status = 8 WHERE status != 8 AND status != -1

But, his statuses are correct in that table already, didn't he just say that?

I've run into a similar issue, my files are all status 8, 2 or 0 in the media_mover_files table though.

mysql> select count(mmfid) from media_mover_files where status !=8 and status !=-1;
+--------------+
| count(mmfid) |
+--------------+
| 0 |
+--------------+
1 row in set (0.01 sec)

edit: ignore that, I misunderstood, I'll hunt elsewhere for my bug.

@Rhino - sorry, not totally clear on what issue you're having. It sounds like there is just an issue with the sql that reports file status. Can you give me a screen shot or something that I can reference to figure out where to look for the issue?

Hi, thanks. I'm not sure if it is related.

I recently upgraded to D20 from D19 and have been squashing mystery quirks (not related) ever since. My media mover module is 6.x-1.0-beta2 and has been manually patched to play nice with other modules, it hasn't been updated. I turned non-core modules off before upgrading, and back on after upgrade, and that's where this phenomena happened: Media mover does 3 things for me - harvest & make HD film, Harvest & make small film, Harvest & make screendump. There are currently no files that haven't been passed through media-mover at some point and are "finished"- but when I turned it on again it tells me that I have these files to process:

Files / Files in process
config1 - 515/ 0
config2 - 53301 / 0
config3 - 350 / 0

I need it to stop thinking this, so that it won't re-process 53301 files and eat up all my serverspace. I can not use the link in "These files may not ever finish. You can remove them all at once." as that doesn't remove any of the files when clicked. I just want these out of the queue.

(turns out I can delete the files *one at a time* just fine though...)

Still not quite sure what you're end goal is. If all your files are good but media mover is reporting bad information, set the file status like:

db_query("UPDATE {media_mover_files} SET status = %d WHERE status <> %d", MMA_FILE_STATUS_COMPLETE_COMPLETE, MMA_FILE_STATUS_COMPLETE_COMPLETE);

If you need to delete these files in bulk, here's some rough code:

  $results = db_query("SELECT mmfid FROM {media_mover_files} WHERE status <> %d ", MMA_FILE_STATUS_COMPLETE_COMPLETE);
  while ($result = db_result($results)) {
    $form['mm_fid']['#value'] = $result;
    media_mover_api_file_delete_confirm_form_submit($form, array());
  }