Hi all.
After struggling for a couple of days building a decent version of ffmpeg on my Ubuntu 8.10 I finally got it working yesterday. After changing the flashvideo ffmpeg command to use the libmp3lame mp3 encoder I also managed to convert some videos. Problem is that I still get the 'Video not...' .png when I view my node (blog post). I've read the "After I submit my node and run cron, all I see is "Video Currently not Available"" node and checked the tables 'flashvideo' and 'files'.
My 'files' table has the following rows:
303 1 Lake_302.jpg files/Lake_302.jpg jpg 4092 1 1233580769
304 1 Lake_302.flv files/Lake_302.flv flv-application/octet-stream 739795 1 1233580773
and my 'flashvideo' table has the following rows:
303 287 302 3 0 450 337 1 0
304 287 302 3 0 450 337 1 0

AFAI can tell the mime types and id:s are looking good. But, no video when adding a '[video]' to the node body.
Any pointers to how I can find debug info on this is very much apprecitated.

br
Svante

Comments

zanaca’s picture

zanaca commented

Hi there!

have you had any success converting those flvs? I having that trouble too. I keep receiving the "invalid stream" alert and than, I see that no video was encoded: "video:0kB audio:101kB global headers:0kB muxing overhead 4.370534%".

Its kind of frustanting

berglsv’s picture

berglsv commented

converting is not a problem, my problem is that I can't display the converted files.

attheshow’s picture

attheshow commented

berglsv,

What kind of message are you receiving from FlashVideo when you run cron? Is it telling you that it successfully created the files or is it reporting a failure?

berglsv’s picture

berglsv commented

success. Both if I create them by cron or if I create them when the node containing the video is saved.
Output is
FlashVideo successfully created: 20081206008_350.jpg
FlashVideo successfully created: 20081206008_350.flv
Page test has been created.

available here
http://www.kumliens.se/content/test

attheshow’s picture

attheshow commented

Do you have the necessary "Player.swf" in your site's primary "files" directory?

berglsv’s picture

berglsv commented

sure do. I've tried with both players mentioned at the project page (jw and dash).
And thanks for spending time on this one :-)

attheshow’s picture

attheshow commented
Component: Code » User interface

Can you please post the link to the .jpg file that was created? I tried looking at the normal paths:

http://www.kumliens.se/sites/default/files/Lake_302.jpg
http://www.kumliens.se/sites/www.kumliens.se/files/Lake_302.jpg
http://www.kumliens.se/sites/kumliens.se/files/Lake_302.jpg

...but couldn't find it in any of those locations. Perhaps your file setup is unusual in some way?

berglsv’s picture

berglsv commented

The jpg was created directly under my drupal root in the files directory like:
http://www.kumliens.se/files/20081206008_350.jpg

If you're trying to access files directly I might add that I've renamed the flash players to dash_player.swf and jw_player.swf. I then change the setting 'Flash Player Name' in the 'Flash Player settings' section.

//Update
Ohh, now I understand why you searched for the 'Lake'-files, I used that movie when testing the day before yesterday but then deleted it. My current test is to convert a 20081206008.mp4 (and I won't delete the files...)

attheshow’s picture

attheshow commented

The only other think I can think to ask about at the moment:

Do you have the "Output Directories reference from Drupal Root." checkbox checked?

terkibibend’s picture

terkibibend commented

same problem on me. Just small size videos (1-3mb) works fine. Biggers falls.
I have checked ffmpeg logs and files table in the database. avi and thumbnail jpg files are listed in the database but flv file is not listed. But i can see flv file in related folder. So if video file size is big, flashvideo cannot write related records to db.

I hope Travis is reading this.

travist’s picture

travist commented

Hello everyone,

Thanks for your patience while I have been away, and HUGE thanks to Mark (attheshow) for holding the line while I have been out.

If your videos are not converting, this is most likely caused by the following reasons...

  • Your values are not set in the php.ini file. Both the max_execution_time and memory_limit not being large enough would cause a failed conversion for a large file.
  • You have an old version of ffmpeg installed. If you have SSH access, you can find out your version by typing in /usr/bin/ffmpeg -help. Then compare this version to the latest version on the FFmpeg website at http://ffmpeg.org
  • You are using mp3 when you should be using libmp3lame in your FFMPEG command.
  • You don't have libmp3lame installed at all within ffmpeg. Typing /usr/bin/ffmpeg -help in shell will tell you if you do.

This is all that I can think of for non-converting videos....

As for those who say their videos converted, but where not put into the flashvideo database, this is usually caused from permission issues in your output directory. Please verify that the output directory that you specified is actually writable. If it is not, then the move from the conversion directory to the output directory would fail causing the files to be there, but flashvideo to not find them.

Hope this helps.

Also, I want everyone to know that I still plan on being VERY involved with this project in the near future. I am currently writing a book that is taking all of my time, but should be done with that around April or so.

Thanks everyone for your support and patience. Mark, again, you are a rockstar.

Travis.

berglsv’s picture

berglsv commented

Nope, that one is not checked (but I checked the 'Delete original video').
Kind of annoying, everything works nicely except viewing the file: the input video is converted allright, the data in the tables looks ok and I've think I've chmod 777 the complete drupal installation... (no, not really but at least the 'files' dir.) Is there anything I can add to the modules .php files to print out some debug info? I have a feeling that since the most important steps (conversion of files and insertion of db-records) works, my problem is related to some misconfig done by me, god knows what...

terkibibend’s picture

terkibibend commented

I think so flashvideo has some problems with db. Convertion works fine but flashvideo cannot update database in some cases, especially on large size files.

If you manually create db records for converted video, it works fine. So flashvideo developers needs to check how they write converting status to db.

Additionally i would know is there any other module to convert videos on drupal.

berglsv’s picture

berglsv commented

Well, I don´t have any problem with large files (> 50Mb). It´s just weird that the module isn't able to play those converted files.

berglsv’s picture

berglsv commented

Think I found the reason why:

If I use the converted file (.flv) and add it to a page then it all works! That is:
I copy the generated .flv from my server to my workstation
Create a new page and add the copied .flv as video
And it works! I found a few differences in the db-records for the two files but the one that made a difference was the last one I found:

One last difference: in the 'upload' table. The first file (not working) have a 'vid' value of '0' but the second file (working) has a 'vid' value equal to the 'nid' value. And eureca! yes, if I insert the 'nid' value as 'vid' value for the first file that one works too! But why didn´t it get a valid 'vid' value at conversion time? Anybody knows? My bad or bug?

attheshow’s picture

attheshow commented

berglsv,

It still sounds to me like the FlashVideo module isn't able to find the converted files on your system for some reason. Just for testing purposes, I'd suggest creating a simple "page" type node and manually try inserting a player into it. Just to see what happens. You might also need to check your input filters and make sure that the object, param, and embed tags are allowed. The code would look something like:


<div id="video-player" align="center">
  <object id="flashvideo" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="450" height="350" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab">
  <param name="movie" value="<strong>http://sandbox/sites/sandbox/files/Player.swf</strong>" />
  <param name="FlashVars" value="file=<strong>http://sandbox/sites/sandbox/files/videos/startrek-tlr2_h.480_140.flv</strong>&image=<strong>http://sandbox/sites/sandbox/files/videos/startrek-tlr2_h.480_140.jpg</strong>&rotatetime=3&autostart=false" />
  <param name="quality" value="high" />
  <param name="wmode" value="window" />
  <param name="allowfullscreen" value="true" />
  <embed name="flashvideo" allowScriptAccess="always" src="<strong>http://sandbox/sites/sandbox/files/Player.swf</strong>"
    width="450"
    height="350"
    border="0"
    type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"
    wmode="window"
    allowfullscreen="true"
    quality="high"
    flashvars="file=<strong>http://sandbox/sites/sandbox/files/videos/startrek-tlr2_h.480_140.flv</strong>&image=<strong>http://sandbox/sites/sandbox/files/videos/startrek-tlr2_h.480_140.jpg</strong>&rotatetime=3&autostart=false" />
</object>
</div>

Be sure to replace the paths in the code with the paths for your site.

berglsv’s picture

berglsv commented

done. works nicely (http://www.kumliens.se/content/flash-test)
Btw, my previous comment (#15) didn't make sense because I removed to much text from it, I've put some of it back, hope it makes more sense now.

attheshow’s picture

attheshow commented
Assigned: Unassigned » attheshow
Status: Active » Needs review

I just committed a change for this. Could people please test the latest 6.x-1.x-dev version for today (February 5th) as soon as it's available?

berglsv’s picture

berglsv commented

Tested this morning with latest and gratest.
Sorry to say, after conversion (successfull), there is still no 'vid' value for the .flv file in the 'upload' table. I still get the video not available. Please tell me if you are helped with any type of access to my server, db-dump or anything else.

ps
My dirty workaround which worked in previous version, to manually set the 'vid' value to the same as the 'nid' value doesn't work either. But, the old page with video still displays nicely.

pss
url to test page created with latest build http://www.kumliens.se/content/flash090206
url to test page created with previous build is http://www.kumliens.se/content/flash-test

br
svante

jseffel’s picture

jseffel commented

I tested the dev-version right now and it didnt work for me either. Conversion worked (check the db and file system). If I do a
echo "

".print_r($node->files, trie)."

";

hook_nodeapi problem?

attheshow’s picture

attheshow commented

Ok, I just got this working on my sandbox. Definitely caused by incorrect entries into the Upload table. It seems odd that we didn't notice this bug previously. Can anyone test?

berglsv’s picture

berglsv commented

You didn't mention any new drop, I assume you want someone else than me to test?

attheshow’s picture

attheshow commented

The new code is already in CVS. The dev snapshot code gets repackaged every 12 hours, so as soon as the February 7th code appears on the module page, that'll be it.

-Mark

berglsv’s picture

berglsv commented
Status: Needs review » Closed (fixed)

Mark.
You are THE man!
It works!!!, I have video on my site :-)
One little step for mankind, one giant leap for me!
Since I reported this bug I guess I can close it?

Again, thanks for the attention.

/svante

jseffel’s picture

jseffel commented
Category: support » bug
Status: Closed (fixed) » Active

I have to reopen this.

If I do this query:
SELECT f.*, u.* FROM node n
INNER JOIN node_revisions nr ON n.nid = nr.nid AND nr.vid = n.vid
INNER JOIN upload u ON u.nid = nr.nid
INNER JOIN files f ON f.fid = u.fid
WHERE n.nid = 3543

I see three files (.wmv, .jpg, .flv) all with correct filesizes. If I do a print_r on $node in min node-video.tpl.php all I see is the .wmv file.

I had a look att function flashvideo_nodeapi in flashvideo.module and it finds all the files at line 2249 ($files = _flashvideo_load($node)).

The stable version works.

jseffel’s picture

jseffel commented
Status: Active » Closed (fixed)

My bad. Sorry.

kuan’s picture

kuan commented
Version: 6.x-1.x-dev » 6.x-1.5-beta2
Component: User interface » Code
Assigned: attheshow » Unassigned
Category: bug » support
Status: Closed (fixed) » Postponed (maintainer needs more info)

Try this:

Open up the 'files' table, go to 'filemime' column, and change any row with "flv-application/octet-stream" into "application/octet-stream". This works so far.

Can we just modify or patch the code in assigning "application/octet-stream" to all conversions? Thanks.

attheshow’s picture

attheshow commented
Status: Postponed (maintainer needs more info) » Closed (fixed)
shakazam’s picture

shakazam commented

Hi!

I have the same issue than berglsv had. I don't see the player in my full node (I tried to use both 6.x-1.5-rc3 and 6.x-1.x-dev) , however I get the thumbnail in teaser and I don't have any problem to convert video, this works great!

Please see my configuration (basic drupal installation settings with Mamp)

The Player is located in htdocs/"my sitename"/files/Player.swf
.flv .mov .jpg is in the sites/default/files directory after conversion

FlashVideo Settings :

Enable the FlashVideo for all nodes of this type: video (checked)
Disable the [video] tag. (unchecked)
Change Node Status after Conversion. (checked)
Convert videos immediately. (checked)
Video Import Directory.: sites/all/files

Universal settings :

Use the CCK FileField module for upload (checked)
Use FFMPEG-PHP to extract video information. (unchecked)

I don't see the "Output Directories reference from Drupal Root." checkbox Attheshow told about (Is this option displayed in the 2 new module versions?)
Moreover I see in the table "files" paths for .flv and .jpg are sites/default/files//... .jpg and sites/default/files//... .flv. However I tried to put one / put it doesn't change anything, so...

I would be pleased if someone could help me on this. It is maybe a wrong jw player location or I don't know...

Thanks!

shakazam’s picture

shakazam commented

I tried also to put the Player in : http://localhost:8888/"mysite"/sites/default/files/Player.swf cause firebug indicated the link as the path directory in the div id="video-player". However the player doesn't show more...

shakazam’s picture

shakazam commented

Ok, I'm the most stupid guy in the world, new computer and I didn't install the adobe flash player. Works great!!

Sorry for all that...