Cannot drop Google as provider after upgrade to 6.x-2.3

Here's where it's currently maintained: http://drupal.org/project/media_video_flotsam

I don't even know if it works anymore- feel free to create a media_google module if you're using it! ;-)

oddly, the nag should only appear if a provider exists in a field as an embedded media object, as the query is against the field content, rather than the allowed providers. this and another similar issue tells me something else might be going on. re-opening to remind myself to look into this more closely.

thanks, sean!

This is because hook_requirement runs sql scanning all node revisions.

Using the SQL below I can make the err away by deleting the particular node revisions.

SELECT n.nid, n.vid "N.latest vid", v.vid, v.field_videos_provider FROM node n INNER JOIN content_field_videos v ON n.nid = v.nid WHERE v.nid in (165, 5463, 5466) AND v.field_videos_provider = '' ORDER BY n.nid, v.vid;
+------+--------------+------+-----------------------+
| nid  | N.latest vid | vid  | field_videos_provider |
+------+--------------+------+-----------------------+
|  165 |         9208 |  667 |                       |
| 5463 |         9210 | 7277 |                       |
| 5466 |         8641 | 7422 |                       |
+------+--------------+------+-----------------------+

function _emfield_audit() {
...
    $sql = "SELECT $provider_column FROM {{$table}} WHERE $provider_column IS NOT NULL GROUP BY $provider_column";
    $results = db_query($sql);
    while ($result = db_fetch_object($results)) {
      $provider = emfield_system_list($module, $result->$provider_column);
      if (empty($provider)) {
        $audit[$result->$provider_column] = $result->$provider_column;
      }
    }
...

runs SQL below giving (in my case) empty provider from the past.

SELECT field_videos_provider FROM {content_field_videos} WHERE field_videos_provider IS NOT NULL GROUP BY field_videos_provider

My 2cnts

Added inline images