F4V Import

Coscast · 2011-09-25 01:04:56

F4V Files do NOT work. Tested serveral times. With Conversion and with Option "Copy" files.
When i select copy videos, i have no videos on my servers.
When i select convert, following error appears:

Query: UPDATE video SET ext = 'mp4', size = , duration = 51.25, thumb = 1, thumbs = 6, server = 0, status = 1 WHERE video_id = 6227 LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' duration = 51.25, thumb = 1, ' at line 3
Error Number: 1064

CSV used above:

http://cdn1.ads.brazzers.com/scenes/5773/trailer-hd.f4v|Party of Four|Its a wedding anniversary celebration party of four in a hotel room. A good start with kisses all over their bodies, then the cleaning lady,Brynn, joins the celebration with her sexy tits. After having good time, they want some dessert, so they asked for Ramon to CUM for them to satisfy their sweet tooth.|big dicks,big tits,cumshot,facial,doggystyle,cowgirl, Brynn Tyler,Emma Starr | Brynn Tyler,Emma Starr 
http://cdn1.ads.brazzers.com/scenes/5751/trailer-hd.f4v|Give my Wife a Bone|Madelyn and Joe have been madly in love for years. They enjoy each other's company, like the same things, and have an amazing sex life. After months of trying to bring it up with her husband, Madelyn finally tells him what her greatest fantasy is. Although Joe is a little hesitant, he'll do anything for his wife, even let another dude fuck her.|ass licking,big tits,facial,lingerie,doggystyle,Madelyn Marie|Madelyn Marie

symtab · 2011-09-25 09:08:30

I cannot reproduce this. On my box your CSV works perfectly, it adds two High Quality HD Videos This looks like the previous problem with undetected format?

Coscast · 2011-09-25 09:54:50

Yes, exactly

root@g6950-24586:~# ffmpeg -i trailer-hd.f4v
ffmpeg version N-32309-g09c5f99, Copyright (c) 2000-2011 the FFmpeg developers
  built on Sep  4 2011 19:08:25 with gcc 4.4.5
  configuration: --prefix=/usr/local --enable-shared --enable-gpl --enable-version3 --enable-nonfree --enable-postproc --enable-libfaac --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libvpx --enable-libx264 --enable-libxvid
  libavutil    51. 16. 0 / 51. 16. 0
  libavcodec   53. 13. 0 / 53. 13. 0
  libavformat  53. 11. 0 / 53. 11. 0
  libavdevice  53.  3. 0 / 53.  3. 0
  libavfilter   2. 37. 0 /  2. 37. 0
  libswscale    2.  1. 0 /  2.  1. 0
  libpostproc  51.  2. 0 / 51.  2. 0
[mov,mp4,m4a,3gp,3g2,mj2 @ 0x25e6780] max_analyze_duration 5000000 reached at 5015510
Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'trailer-hd.f4v':
  Metadata:
    major_brand     : isom
    minor_version   : 512
    compatible_brands: isomiso2avc1mp41
    creation_time   : 1970-01-01 00:00:00
    encoder         : Lavf52.31.0
  Duration: 00:01:02.48, start: 0.000000, bitrate: 1651 kb/s
    Stream #0.0(eng): Video: h264 (High) (avc1 / 0x31637661), yuv420p, 768x432 [SAR 1:1 DAR 16:9], 1493 kb/s, 29.92 fps, 29.97 tbr, 30k tbn, 59.94 tbc
    Metadata:
      creation_time   : 1970-01-01 00:00:00
    Stream #0.1(eng): Audio: aac (mp4a / 0x6134706D), 44100 Hz, stereo, s16, 123 kb/s
    Metadata:
      creation_time   : 1970-01-01 00:00:00
    Stream #0.2(und): Data: none (rtp  / 0x20707472)
    Metadata:
      creation_time   : 2011-07-17 15:04:53
    Stream #0.3(und): Data: none (rtp  / 0x20707472)
    Metadata:
      creation_time   : 2011-07-17 15:04:54
At least one output file must be specified

Last edited by Coscast (2011-09-25 10:21:34)

Coscast · 2011-09-25 10:24:23

Sorry for doublepost.

Fixed it, by adding h264 to libraries/framework/video.php

    private $flv_formats    = array(
        'flv', 'flv1', 'vp3', 'vp5', 'vp6', 'vp6a', 'vp6f', 'h264'
    );

EDIT: Copying the videos without conversion works now, but with the option "Convert Videos" it does not work

Last edited by Coscast (2011-09-25 10:35:51)

symtab · 2011-09-25 10:35:23

Hmm...if it works ok. I dont have that, thats only for FLV formats. It should be detected as mp4, at least thats how its detected for me.

symtab · 2011-09-25 10:42:55

Identify works correctly:

(array) Array
(
    [cmd] => /usr/bin/ffmpeg -i '/home/symtab/trailer-hd.f4v'
    [container] => mov,mp4,m4a,3gp,3g2,mj2
    [duration_timecode] => 00:00:51.25
    [duration_seconds] => 51.25
    [start] => 0.000000
    [bitrate] => 1690
    [format] => h264 (High)
    [colorspace] => yuv420p
    [framerate] => 1490
    [audio] => aac
    [audio_frequency] => 44100
    [audio_stereo] => stereo
    [audio_bitrate] => 122
    [frames] => 76363
    [width] => 768
    [height] => 432
    [dar] => 16:9
    [dar_float] => 1.7777777777778
)

(string) mp4

Coscast · 2011-09-25 11:09:07

Hm.Ok. As i said: Copying works now, but converting via Mass Csv throws an SQL error.

Query: UPDATE video SET ext = 'mp4', size = , duration = 62.48, thumb = 1, thumbs = 6, server = 0, status = 1 WHERE video_id = 6374 LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' duration = 62.48, thumb = 1, ' at line 3
Error Number: 1064

So i assume my Solution to just add h264 to the video.php is NOT a Solution. LOL

It is like my other Problem: Uploading via acp in admin/index.php?q=video/upload works and the video gets converted as it should without any errors/problem but csv does not work

symtab · 2011-09-25 11:43:50

Please email me "your double admin access protection" :PPPP I still have FTP access from yesterday.

symtab · 2011-09-28 14:10:28

Still working on this...its wierd exactly the same works perfectly for me, however on your site (and 2 other sites) it doesnt.

Coscast · 2011-09-28 14:27:45

Thanks for updating me on this. Maybe ... i don't know ... it has something todo with our ffmpeg version.

symtab · 2011-09-28 14:53:48

Ffmpeg detects the correct format, its mp4, however it does not detect the size...still debugging.

symtab · 2011-09-29 12:32:05

Fixed the size problem with the conversion. Still trying to figure out why it doesnt work with Copy Files.

Adult Script Pro Community Forums

#1 2011-09-25 01:04:56

F4V Import

#2 2011-09-25 09:08:30

Re: F4V Import

#3 2011-09-25 09:54:50

Re: F4V Import

#4 2011-09-25 10:24:23

Re: F4V Import

#5 2011-09-25 10:35:23

Re: F4V Import

#6 2011-09-25 10:42:55

Re: F4V Import

#7 2011-09-25 11:09:07

Re: F4V Import

#8 2011-09-25 11:43:50

Re: F4V Import

#9 2011-09-28 14:10:28

Re: F4V Import

#10 2011-09-28 14:27:45

Re: F4V Import

#11 2011-09-28 14:53:48

Re: F4V Import

#12 2011-09-29 12:32:05

Re: F4V Import

Board footer