I cannot get flashvideo to convert my files

Are you able to convert a video from the command line using an ffmpeg command? Please see the tutorial on the main project page for the module if you're not sure how to do this.

I am using windows and so the command line is not something I ever use. I think I should switch to Linux cause it seems most people develop under linux and most servers run on it. The problem is I have profiles for people and they need to add video to their profiles but I would like the videos to show the thumbnail and if people click on it the whole video. I have tried everything and I keep running cron but I cannot find the files and I don't see ffmpeg converting them. I include pictures of all my settings so you can see what they are. Please tell me where am I doing it wrong.

Thanks it is much appreciated. Wish I can find a developer that can maintain my sites. I'm a newbie to Drupal but I am learning

It keeps saying conversion failed. Where am I suppose to put the ffmpeg binary? I'm really battling with this one for the last couple of days. Flashvideo creates the thumbnail but it doesn't convert the video.

Then I get the following error:
warning: rename(C:\wamp\www\test/sites/default/files/4X4.wmv,C:\wamp\www\test/sites/default/files/sites/default/files/videos/4X4.wmv) [function.rename]: No such file or directory in C:\wamp\www\test\sites\all\modules\flashvideo\flashvideo.module on line 1103.

I also now get the flashvideo to convert the files but it doesn't show. It just shows the name of the video but not the video

Can someone with some knowledge please help me?

Well, just from looking at "rename(C:\wamp\www\test/sites/default/files/4X4.wmv,C:\wamp\www\test/sites/default/files/sites/default/files/videos/4X4.wmv)" I can see your problem...

C:\wamp\www\test/sites/default/files/sites/default/files/videos/4X4.wmv is a bogus file path.... Please make sure you have the correct output directory set... It is also considered good practice to change all of the "/" to "\\" when in a Windows environment.

Thanks,

Travis.

I have built a new site and I followed the settings on my previous site exactly the same and on the previous site it converts the videos and play it but on this site I get:

* user warning: Unknown column 'field_thumbnail_fid' in 'field list' query: UPDATE content_type_video SET field_thumbnail_fid = 12, field_thumbnail_list = 0 WHERE nid = 5 in /home/gigguide/public_html/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 729.
* user warning: Unknown column 'field_video_conv_fid' in 'field list' query: UPDATE content_type_video SET field_video_conv_fid = 13, field_video_conv_list = 0 WHERE nid = 5 in /home/gigguide/public_html/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 740.

What am I doing wrong please?

It converts the file though:

* Operating in off-line mode.
* had to get defaults for node->node_invites_enabled
* FlashVideo successfully created: buzo_0_11.jpg
* FlashVideo successfully created: buzo_0_11.flv
* Video Buzo has been created.

but gives me that error and I have made sure that all my settings are correct. I am using the CCK fields option in flash video general settings
and it says this:

You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.

Did you happen to change your field names after you initially configured them? That's the only thing I can think of that might result in the query errors above. If that's the case, you should just go back to your content type settings and choose your new field names.

The message you mention at the bottom "You are missing some Flash content..." isn't coming from the FlashVideo module.

I deleted the content type then recreated the content type again with new fields and did the settings in flashvideo again. I get the same error:

* user warning: Unknown column 'field_thumbnail_fid' in 'field list' query: UPDATE content_type_video SET field_thumbnail_fid = 22, field_thumbnail_list = 0 WHERE nid = 10 in /home/gigguide/public_html/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 729.
* user warning: Unknown column 'field_converted_fid' in 'field list' query: UPDATE content_type_video SET field_converted_fid = 23, field_converted_list = 0 WHERE nid = 10 in /home/gigguide/public_html/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 740.

What I don't understand is what is the _fid in the 'field_converted_fid' since that is not part of the name? I don't know what to do I have disabled it and enabled it I don't know what next I should do. Please help!

I have now disabled the module and reinstalled it and did everything from the start and I get the same error every time:

* user warning: Unknown column 'field_thumbnail_fid' in 'field list' query: UPDATE content_type_video SET field_thumbnail_fid = 34, field_thumbnail_list = 0 WHERE nid = 11 in /home/gigguide/public_html/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 729.
* user warning: Unknown column 'field_converted_fid' in 'field list' query: UPDATE content_type_video SET field_converted_fid = 35, field_converted_list = 0 WHERE nid = 11 in /home/gigguide/public_html/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 740.

Dear cornelombaard,

Can you possibly look in your database and confirm that the field is there? I'm guessing that the warning message is right and that the database field is missing for some reason.

Can you please then go to http://[YOURSITE]/admin/build/modules and let me know which versions of CCK, FileField, and FlashVideo you're using?

I'm trying to think of reasons why when you create a new file field, CCK would not create the necessary "fid" field in the table.

Dear Sir

I have decided to rebuild the site completely because of some other errors I had as well. I really appreciate the help to get this working and I will now make sure that I do everything the correct way and will let you know. Thank you so very much for the help.

I have now created a brand new site and I have made sure that I do everything exactly like it is supposed to be done. I do not get the errors mentioned above anymore. I have built the site with the brand new version on flashvideo but now none of my files get converted. It says conversion failed every time.

Sorry no I do get errors:

When I tried to delete the test video I created it gave me the following:

* user warning: Unknown column 'field_converted_fid' in 'field list' query: UPDATE content_type_video SET field_video_fid = NULL, field_video_list = NULL, field_converted_fid = NULL, field_converted_list = NULL, field_thumbnail_fid = NULL, field_thumbnail_list = NULL WHERE nid = 4 in /home/gigguide/public_html/sites/all/modules/flashvideo/flashvideo.module on line 2488.
* user warning: Unknown column 'field_converted_fid' in 'field list' query: UPDATE content_type_video SET field_video_fid = NULL, field_video_list = NULL, field_converted_fid = NULL, field_converted_list = NULL, field_thumbnail_fid = NULL, field_thumbnail_list = NULL WHERE nid = 4 in /home/gigguide/public_html/sites/all/modules/flashvideo/flashvideo.module on line 2488.

Seriously I don't understand this. It's the same server, the same settings, the same path to ffmpeg and it's not working. Now I had Drupal 6.10 installed on my previous site and the conversion , everything worked fine. Now with 6.13 I am having all these difficulties and I can't go back to 6.10. Why is a better version of Drupal giving me more hassles than an older version? Everything is the latest, filefield, flashvideo, etc.

CCK version 2.4
Filefield version 3.1
Flashvideo version 6.x-1.5-rc3

How do I check the following? (Can you possibly look in your database and confirm that the field is there? I'm guessing that the warning message is right and that the database field is missing for some reason.) Which table in the database do I have to look at pls?

I have now tested on another site running on the same server and I get the same error: Conversion failed and when I delete the video I get the:

* user warning: Unknown column 'field_converted_fid' in 'field list' query: UPDATE content_type_video SET field_video_fid = NULL, field_video_list = NULL, field_converted_fid = NULL, field_converted_list = NULL, field_thumbnail_fid = NULL, field_thumbnail_list = NULL WHERE nid = 2 in /home/gigguide/public_html/hosted/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 2488.
* user warning: Unknown column 'field_converted_fid' in 'field list' query: UPDATE content_type_video SET field_video_fid = NULL, field_video_list = NULL, field_converted_fid = NULL, field_converted_list = NULL, field_thumbnail_fid = NULL, field_thumbnail_list = NULL WHERE nid = 2 in /home/gigguide/public_html/hosted/usagigguide.com/sites/all/modules/flashvideo/flashvideo.module on line 2488.

Dear cornelombaard,

The database table you'd be looking at on your system would be the "content_type_video" table since that's the table that the UPDATE queries are failing on.

The fields are not in the database. The only fields that are there are the fields video_fid video_list and video_data which is the the field for uploading the file so it doesn't create the other fields. How do I fix this?

Excuse me pls. Like I said I am new to this.

The fields are all there.
content_field_converted
content_field_thumbnail
content_field_video

So the field, 'field_converted_fid' is there so why can it not see it or find it?

This is approximately what you should be seeing in the database table (see attachment). If you're not seeing this, I'd probably recommend posting to the CCK and/or FileField issue queues and see why your database structure is different.

Well mine doesn't look like that at all I will try that and post it there thank you. I can't understand why a thing can work fine the one day and not work at all the next day. Same system same everything. Feel like turning this Drupal stuff up and stop trying. It's just too difficult. Now I'll have to wait a week or two before someone might help me.

Thank you though for all your help!

Moving discussion to #538934: Flashvideo does not see a field I created and it says unknown column although it exists. CCK database structure is wrong. Closing this issue out.