We've been using Media: Viddler for many months, and it's great! But just recently, when we use it to embed a new video on Viddler, the video doesn't appear. Looking at the HTML being output, I can see the <embed name="" and the <param name="movie" value="".

Even if I grab the video URL from an old node (which works), and try to embed it in a new node, it won't display in the new node. I don't know how this all works, but it's almost like Viddler's servers aren't returning some kind of special code/id needed.

We made no changes to this Drupal install before it stopped working.

Comments

BassistJimmyJam’s picture

BassistJimmyJam commented
Title: New videos not displaying » Support new oEmbed return format
Assigned: Unassigned » BassistJimmyJam
Status: Active » Fixed

The issue here is that Viddler changed the return format of their oEmbed service. I have updated the module to support this new format. Part of this update includes a new index in the video data array that is stored in the database. Included in this update is an update to existing values. This should also fix any values that you saved after Viddler changed the return format. However, in the event that it does not you should be able to just edit and save the node.

Status: Fixed » Closed (fixed)

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

lwithrow’s picture

lwithrow commented

Thanks for the fix! Although now when I try to install the new version and run update.php, it keeps failing.

The first couple of times I ran it, it timed out. I increased the execution time in my php.ini, and now it's failing with "An HTTP error 500 occurred."

The update process was aborted prematurely while running update #6000 in media_viddler.module. All errors have been logged. You may need to check the watchdog database table manually.

When I look at the error log (admin/reports/dblog), I see hundreds of errors that look like this:
Unknown column 'field_video_embed_data' in 'field list' query: UPDATE content_type_in_house_production SET field_video_embed_data = 'a:1:{s:24:\"emvideo_viddler_embedurl\";N;}' WHERE nid = 0 AND vid = 0 in E:\inetpub\wwwroot\drupal\sites\all\modules\media_viddler\media_viddler.install on line 47.

Any idea what might be causing this? I went ahead and restored the backup I made of my database before installing the update. But it still fails when I run the update process again (with a 300 minute execution time limit, just in case). Still giving the same "Unknown column" error.

lwithrow’s picture

lwithrow commented

I was eventually able to fix this by editing lines 28 and 80 of media_viddler.install from:
$table = 'content_type_' . $instance['type_name'];
To:
$table = 'content_field_video_embed';

I'm not sure why my embedded video data is in that table instead of the node-type table, but there it is.