I recently updated video module on Drupal 7.14 from 7.x-2.5 to 7.x-2.7 and have been receiving this error SINCE moving BACK down to 7.x-2.5 and when trying to upload a video file :

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vid' in 'where clause': SELECT 1 FROM {video_thumbnails} WHERE vid = :vid; Array
(
[:vid] => 539
)
in Transcoder->extractFrames() (line 47 of /srv/d7/sites/commons.kennesaw.edu.coles_presents/modules/video/includes/Transcoder.inc).

I checked my database, and the video_thumbnails table has two columns, "videofid" and "thumbnailfid". Where did "vid" column come from? Did it just get corrupted from moving the versions back and forth? Would it be ok to just rename the column name in Transcoder.inc for 7.x-2.5?

I would update back to 7.x-2.7 to see if any changes correct the problem, but there's a world of other problems with transcoding hanging when I do that, whereas I'll open another ticket later to handle. Thanks!

Comments

Jorrit’s picture

Status: Active » Postponed (maintainer needs more info)

Downgrading is not supported. Upgrades may result in database changes and these changes can't be rolled back. Why did you go back to 2.5? Perhaps you can try to use 2.6 and see if that one works.

drupalrp’s picture

Status: Postponed (maintainer needs more info) » Closed (works as designed)

I updated back to 7.x-2.7, and I'm able to upload files again. I'm in the process of transcoding a 512mb file into mp4, flv, ogv, and webm using video module, if it continues to hang, I'll open a new ticket. Thanks!

Jorrit’s picture

Large files are always tricky because they can fail on many different levels. Before you open a new ticket, check if the timeouts of PHP, MySQL and Apache are set high enough.

drupalrp’s picture

I think this might be more related to - http://drupal.org/node/1002048, because some times I can upload files, other times I can't - and it's the same files.