I just upgraded from 5.x-1.x-dev 2007-08-10 to 2008-02-13. Following this all my video nodes no longer contained the video display part. All the other info (title, #plays, size, duration, etc.) was displayed. But no window with the video, play button, etc. There were no corresponding items in the log. Any thoughts?

(I've since reverted to the previous version and everything is working fine.)

Comments

fax8’s picture

fax8 commented
Status: Active » Closed (duplicate)

see http://drupal.org/node/220929

dshaw’s picture

dshaw commented
Status: Closed (duplicate) » Active

As 220929 has been closed and I still have a problem, I'm re-opening this one.

I followed the detailed steps (from 220929) including the latest patch. The contents of the database at the end look ok. I've got values for vtype of 'upload' and 'youtube'. I've enabled several video modules (including params, upload, youtube, custom fields, url). But unfortunately, no joy. I get "Video type not supported" errors and when I edit the video nodes, only two fields appears under "Video Information" and one under "HTML object parameters". No other fields are present to help me manage settings like file size and so on.

SQL: select * from video;

vid nid vidfile videox videoy size download_counter play_counter video_bitrate audio_bitrate audio_sampling_rate audio_channels playtime_seconds download_folder disable_multidownload use_play_folder custom_field_1 custom_field_2  custom_field_3 custom_field_4 custom_field_5 custom_field_6 serialized_data vtype

273 273 files/video/FSoT.flv 480 360 11830151 1 210 0 0 0 233 0 0 a:1:{s:9:"video_fid";N;} upload
274 274 http://www.youtube.com/watch?v=RQ2ekgMEvbo 425 350 1000000 0 92 0 0 0 12 0 0 a:1:{s:9:"video_fid";N;} youtube
fax8’s picture

fax8 commented

Seems that the value of the video_fid serialized data has been loaded as NULL. This is causing your issue. Would you please post the result of these queries?


SELECT * FROM video WHERE nid=273;

SELECT * FROM files WHERE nid=273;

SELECT * FROM file_revisions WHERE vid=273;
dshaw’s picture

dshaw commented

Query results:

A) 73 273 files/video/FSoT.flv 480 360 11830151 1 211 0 0 0 233 0 0 a:1:{s:9:"video_fid";N;} upload
B) nil
C) nil

fax8’s picture

fax8 commented

can you try:

SELECT * FROM files WHERE filepath='files/video/FSoT.flv'

dshaw’s picture

dshaw commented

Result: nil

Now that I think about it, I think the reason for this is that these files were "uploaded" via ftp. That is, because they're so large, ie. >50MB, we ftp'ed them to the server, moved them into the files directory tree and then created video nodes for them. So they weren't "uploaded" through Drupal. So they presumably therefore don't have entries in the "files" table.

This makes me wonder if perhaps they shouldn't have a different vtype?

Any other thoughts?

fax8’s picture

fax8 commented

sure.. a vtype="upload" means that the files where uploaded using drupal's uploading infrastructure. If you used ftp you should insert "url" as vtype.

Fabio

dshaw’s picture

dshaw commented

OK. That's an improvement. I can now watch my url-based and youtube-based videos.

However, when I go to edit them, I don't see any of the parameters I used to see. There's only the URL for the file or the youtube video. The size, duration, etc. are all missing. How do I get them back?

vhmauery’s picture

vhmauery commented

For youtube and google videos, the size and file length should be determined automatically via a XML API.

dshaw’s picture

dshaw commented

Fair enough for the youtube video. But what about my URL videos? I remember entering size, duration, and so on for them. Now I can't see, let alone edit, that information. Similarly when I go to create a new video, I don't get the opportunity to add that information. Is that the way things are now? Or is something broken somewhere?

fax8’s picture

fax8 commented
Assigned: Unassigned » fax8

The idea for the file size and duration of the new code was to follow the approach used now for the resolution stuff.

Now video types which can automatically get the resolution doesn't ask it to the user, while video types who can't ask it to the user.

The same approach will be followed on the size and duration.. but this is still a work in progress and I'm working on this right now.

Fabio

fax8’s picture

fax8 commented

Just committed the code to enable again the playtime informations.

dshaw’s picture

dshaw commented

So I have to enter the video type first? That is, if I picked a media type where this info can't be extracted from it, then more form fields would appear?

fax8’s picture

fax8 commented

Video module currently have 4 video types: youtube, google video, upload, url.

With the most recent -dev version (yesterday) it support automatic playtime info from youtube and upload+ffmpeg_helper.
Other video types will display a field for inserting the playtime (hh, mm, ss).

dshaw’s picture

dshaw commented

Much better! The latest dev version now seems to have the same level of functionality as 5.x-1.x-dev 2007-08-10. Thanks for all the help.

fax8’s picture

fax8 commented
Status: Active » Fixed

setting this as fixed. Feel free to reopen if you still have problems.

jorisx’s picture

jorisx commented

YES !! Thanx for the fix !

I went to the update.php and selected "update #1" from the video module ...
although it gave lot's of errors, it went trough update #1 to #9
and now all my video's are playing again !

super sweet !

fax8’s picture

fax8 commented

well.. I'm happy for this but.. it shouldn't give you errors..

Can you please post them? I want to be sure that nothing bad is happening underway..

fax8’s picture

fax8 commented

Ops.. understand.. if you have selected to update from schema #1 it obviously will give you errors when trying to update an already updated table.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.