I am experiencing trouble in setting up this plugin...

I am using a virtual private server hosted by cirtex. Red 5 is installed on the same server as drupal.

I have a cck content type 'video' with three fields: video in, video out, and thumbnail. I have setup OpenSSH keys on the server, but because Red 5 is installed i don't think i can follow the readme.txt instructions. I enabled SMTP streaming. I am using the Dash Media Player (woohoo!).

When I create the video content type, the video converts correctly... but the thumbnail isn't posting... I am getting the following log entry:

Unknown column 'delta' in 'field list' query: INSERT INTO content_field_video_thumb (vid, nid, delta, field_video_thumb_fid, field_video_thumb_list) VALUES (451, 451, 0, 475, 0) in /home/magician/public_html/sites/all/modules/flashvideo/flashvideo.module on line 757.

The ffmpeg setting for thumbnails is:
-y -i @input -vframes 1 -ss @thumbtime -an -vcodec mjpeg -f rawvideo -s "@thumbsize" @output

The video is also not playing... I am sure the conversion worked well, but the video isnt being posted to the red 5 server which I have the filepath of: /usr/local/red/webapps/oflaDemo/

RTMP Settings on flash video are:
streaming url: rtmp://208.xxx.xxx.128/oflaDemo
streaming server address: 208.xxx.xxx.128:100
streaming server filepath: /usr/local/red/webapps/oflaDemo/streams

Please help!

Thank You!

Best Regards,
Mark

Comments

marcin-mark’s picture

marcin-mark commented

:( nobody?

roald’s picture

roald commented
Component: Miscellaneous » Code

Hi!

I have the same problem, but it does not seem to be related to the RTMP module. I'm getting this problem if I use the field_video_thumb in more than one content-type AND this field is defined to have only one entry.
Apparently the flashvideo.module around line 750 always uses the db-column 'delta' if the "db_storage = 0 means 'stored in its own table'." (see comment in flashvideo.module around line 750). However, the delta column is only there if the cck-field is defined to have more than one entry.

I guess this qualify as a minor bug in flashvideo...(?)

Roald

roald’s picture

roald commented

See also http://drupal.org/node/538934

travist’s picture

travist commented
Status: Active » Closed (duplicate)

I am pretty sure that this is caused by an issued described in the other issue given by roald... ( thanks roald ).

I am marking this as duplicate. Mark ( attheshow ) is working on the fix for this issue and should have a patch that fixes it soon. Please test his patch and let me know if that fixes your problem.

Thanks,

Travis.