old videos broke after upgrade.

Hey Mike!

Long time no talk to! Good to hear from you.

Yeah, we had to make a change to the video queries to include the "vid" which is the node version ID... We were having issues using the node ID since sometimes the node ID and the version ID are different. What version of Drupal are you using? My guess is your node ID's and the version ID's are different, and is causing some issues with database ID alignment. I have fixed this before, but it required me to write a custom script to fix any discrepancies. What I would recommend is taking a look at your database tables and look closely at the "vid" and "nid" columns. If they do not align, then write a script that fixes the flashvideo table so that they are correct.

Hope this helps.

Travis.

Hi Travis,

Yeah been in limbo with my site, ie the video side of it has just sat there if you know what i mean. Using drupal 6. Cheers for the info, i can see that i need to do an update on the tables as some are out. Also just found another problem with even older videos. It seems a lot of them don't have an entry in the upload table for the .flv record set. There is a record for the wmv (that particular vid) but the sql query is trying to join on an entry in the upload table with the same file id as the flv record set which doesnt exist.

for my old old videos it seems that the row in flashvideo for the original(ie wmv) row has the file id for the original files in the upload table only and not a flv entry, so the join is failing. I think I'll make a new query when the first fails to check for this old data as a work around, or i could just add the row. hmmmm

No further discussion after a month. Marking issue as closed.

I'm having the same problem. I'm updating from Drupal 5 with flashvideo version 5.x-2.7 to Drupal 6 with flashvideo 6.x-1.5-rc3 .

None of my old video thumbnails show and the video does not load with the player. I can download the *.mpg file and then re-upload and convert and that node then works correctly.

I have about a dozen school districts using flashvideo and am updating to Drupal6 with all of their web sites. Is there a quick and easy way for a not-so-great at administering databases guy to fix this?

Thanks..
;-) Paul

You may wish to try the patch I created here; http://drupal.org/node/474154

It could very well solve your problem. If it does, please mark this issue as a duplicate.

NOTE: Ignore the title of the issue, it's relevant regardless of whether you're using CCK or not. The issue relates to retrieving the correct path of the thumbnail rather than preg_matching the transcoded flv file.

Pobster

Hi, I have the same problem and the patch mentioned above did not work for me. I upgrade my site (and flashvideo) from D5 to D6, and all old videos broke. I've tried with both RC4 and head, to no avail. New videos seem to register fine, though.

The FlashVideo module currently does not have an upgrade path from D5 to D6. This was never implemented so it really doesn't surprise me that this is broken. This is most certainly caused from the difference in how files are handled between D5 and D6, where an "upload" table is used vs. the "files" table for all uploads within D5.

As for the next release, this probably won't make it in since the use case is rather small. However, if you wish to hire a professional to do the upgrade for you, I might be able to assist with this task. Or Mark ( attheshow ) would be able to do it for a fee.

Otherwise, I am afraid that this will just need to be postponed until new features are being added to the module.

Thanks,

Travis.

Ah ok, that explains. I don't have a huge amount of videos anyways, so I'm just downloading the original file and re-uploading it to the same node to reattach it. Since the node is already and the right videos are already in place, I was just wondering if there was a way to "tell" the node which video it should display without reuploading the original video.