video type not supported video module

I get the same error "video type not supported" after migrating from D5.x to D6.x. There are over 20 video nodes, of which all the uploaded videos nodes give this error and do not show an embedded video. I've checked that all the required players are in the shared folder and some also have copies in the drupal root.

If your using upload video type then create upload_video table as in video_upload plug-in, then migrate all vid nid info to that table from file revisions, that will help you to recover.

@didymo as I can see, go to ffmpeg helper settings and un-check, if you already check "convert video when cron run". please add separate cron run for video_scheduler.php

@ heshanmw: you have recommended creation of an "upload_video" table, but I only see a video_upload schema in the installation file of video_upload plugin, let me reconfirm that the table name is correct. Also, the above error seems to occur for URL_videos too, while Youtube and Google videos show up fine.

if you can tell me which tables to back up, I would like to do a clean reinstall to the D6 version. Many other modules have not upgraded from D5 to D6 gracefully and needed the same treatment.

Thanks!

@ajzz, Please refer the video_upload.install file on creating schema, then migrate all file_revision nid, fid values.

@didymo there was such a error few months back on video module, please user 2.5 release, then you can fix it

Hi Heshan,

Here are some queries I am logging on this thread in case someone needs them later.

There is no nid in D5 file_revisions

mysql> desc file_revisions;
+-------------+---------------------+------+-----+---------+-------+
| Field       | Type                | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| fid         | int(10) unsigned    | NO   | PRI | 0       |       | 
| vid         | int(10) unsigned    | NO   | PRI | 0       |       | 
| description | varchar(255)        | NO   |     |         |       | 
| list        | tinyint(1) unsigned | NO   |     | 0       |       | 
+-------------+---------------------+------+-----+---------+-------+

So this is what I did:
IN D5

mysql> select file_revisions.vid,node.nid,file_revisions.fid from node right join file_revisions on node.vid=file_revisions.vid where node.type='video' into outfile 'videodata_vid_nid_fid';

IN D6

mysql> create table video_upload (vid INT UNSIGNED NOT NULL PRIMARY KEY, nid INT UNSIGNED NOT NULL, fid INT UNSIGNED NOT NULL);
mysql> load data local infile 'videodata_vid_nid_fid' into table video_upload;

The above steps load the vid, nid and fid into the video_upload table in D6.

Nothing changed... still get the error. I even tried loading all the file revisions data without the node.type filter. Still no change...
Error persists on all the URL and Uploaded Video nodes in D6.

Can you check the commom.inc file in includes folder?

What do you want me to look for in the file?

common.inc file should have this

function _video_common_get_player($node) {
  switch (_video_get_filetype($node->vidfile)) {
    case 'divx':
      return theme('video_play_divx', $node);
    case 'mov':
    case 'mp4':
    case '3gp':
    case '3g2':
    case 'mpg':
      return theme('video_play_quicktime', $node);
    case 'rm':
      return theme('video_play_realmedia', $node);
    case 'flv':
      return theme('video_play_flash', $node);
    case 'swf':
      return theme('video_play_swf', $node);
    case 'dir':
    case 'dcr':
      return theme('video_play_dcr', $node);
    case 'asf':
    case 'wmv':
    case 'avi':
      return theme('video_play_windowsmedia', $node);
    case 'ogg':
      return theme('video_play_ogg_theora', $node);
    case 'youtube':
      return theme('video_play_youtube', $node);
    case 'googlevideo':
      return theme('video_play_googlevideo', $node);
    default:
      drupal_set_message('Video type not supported', 'error');
      break;
  }
}

@didymo #488616 please have a look.

link http://drupal.org/node/488616

@heshan, something similar is already in site/all/modules/video/includes/common.inc (lines 2 and 3 below are the only parts that differ). What next?

function _video_common_get_player($node) {
  $op = ($node->vtype == "upload")?  _video_get_filetype($node->vidfile) : $node->vtype;
  switch ($op) {
    case 'divx':
      return theme('video_play_divx', $node);
    case 'mov':
    case '3gp':
    case '3g2':
    case 'mp4':
      return theme('video_play_quicktime', $node);
    case 'rm':
      return theme('video_play_realmedia', $node);
    case 'f4v':
    case 'flv': // flowplayer also supprts MP4, H.264 (.extension?)
      return theme('video_play_flash', $node);
    case 'swf':
      return theme('video_play_swf', $node);
    case 'dir':
    case 'dcr':
      return theme('video_play_dcr', $node);
    case 'asf':
    case 'wmv':
    case 'avi':
    case 'mpg':
    case 'mpeg':
     return theme('video_play_windowsmedia', $node);
    case 'ogg':
      return theme('video_play_ogg_theora', $node);
    case 'youtube':
      return theme('video_play_youtube', $node);
    case 'googlevideo':
      return theme('video_play_googlevideo', $node);
    default:
      drupal_set_message('Video type not supported', 'error');
      break;
  }
}

FYI: you missed the sq brackets for didymo [ #488616 ] gives #488616: Upload Video module seems designed to lose your converted video