The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
Query: UPDATE video SET ext = 'flv', size = , duration = 120.21, thumb = 1, thumbs = 20, server = 0, status = 1 WHERE video_id = 579 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 = 120.21, thumb = 1, ' at line 3
Error Number: 1064
Settings:
phpinfo: http://dev.mypornow.com/info.php
http://hot.famehosted.com/D/D0/D02C05AB5F/6/67/6771/c6d6d42f14/6771_04/01/6771_04_120sec_00.flv|Anal Acrobats #03|Hot babes licking and toying their large horny ass holes !|Lesbian,Hardcore,Toys,Cunilingus,Rimming,Straight Porn
http://hot.famehosted.com/D/D0/D02C05AB5F/6/67/6771/c6d6d42f14/6771_03/01/6771_03_120sec_00.flv|Anal Acrobats #03|Very hot horny girls getting hammered in their big assholes!|Threesome,Toys,Blowjob,Blonde,Tattoo/Piercing,Dark Hair
http://hot.famehosted.com/D/D0/D02C05AB5F/6/67/6771/c6d6d42f14/6771_01/01/6771_01_120sec_00.flv|Anal Acrobats #03|Super hot couple of lesbian girls licking their horny asses!|Lesbian,Brunette,Tattoo/Piercing,Bubble Butt,Cunilingus,Rimming
Tested with setting "Copy Videos" this runs through but without any Thumbs, and says "imported 0 Videos".
The normal single upload incl. conversion works without problems. So i exclude server problems, i.e. missing modules.
EDITH SAYS: Hmm, mentioned now that the size field is empty
Last edited by Coscast (2011-09-03 17:08:34)
Offline
I tested this on my box and it works, however i discovered a new bug: the duplicate detect function is not accurate, thats why it only added 1 video (all 3 videos have the same tile). I will change the video duplicate system to work like this: save the video url (from the csv) in a separate table and this way no duplicates, even if the title is the same. Hope it makes sense, kinda tired.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Ok nailed it down, checked via commandline and i got an error while creating thumbs:
/usr/local/bin/ffmpeg -ss 20 -i '/opt/lampp/htdocs/asp/media/videos/vid/579.flv' -f image2 -s 160x120 -an -vframes 2 -y /opt/lampp/htdocs/asp/tmp/thumbs/579/%03d.jpg
ffmpeg version N-32290-g6fc1299, Copyright (c) 2000-2011 the FFmpeg developers
built on Sep 2 2011 10:45:30 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. 14. 0 / 51. 14. 0
libavcodec 53. 12. 0 / 53. 12. 0
libavformat 53. 10. 0 / 53. 10. 0
libavdevice 53. 3. 0 / 53. 3. 0
libavfilter 2. 37. 0 / 2. 37. 0
libswscale 2. 0. 0 / 2. 0. 0
libpostproc 51. 2. 0 / 51. 2. 0
[flv @ 0xa48420] Estimating duration from bitrate, this may be inaccurate
Seems stream 0 codec frame rate differs from container frame rate: 1000.00 (1000/1) -> 29.97 (30000/1001)
Input #0, flv, from '/opt/lampp/htdocs/asp/media/videos/vid/579.flv':
Metadata:
hasKeyframes : true
audiodatarate : 96
hasVideo : true
stereo : false
canSeekToEnd : true
framerate : 30
audiosamplerate : 44000
videocodecid : 2
datasize : 13115146
lasttimestamp : 120
audiosamplesize : 16
audiosize : 1495000
hasAudio : true
audiodelay : 0
videosize : 11618286
metadatacreator : inlet media FLVTool2 v1.0.6 - http://www.inlet-media.de/flvtool2
lastkeyframetimestamp: 120
height : 240
filesize : 13147979
hasMetadata : true
audiocodecid : 2
videodatarate : 771
duration : 120
hasCuePoints : false
width : 360
Duration: 00:02:00.21, start: 0.000000, bitrate: 885 kb/s
Stream #0.0: Video: flv1, yuv420p, 360x240, 789 kb/s, 29.97 tbr, 1k tbn, 1k tbc
Stream #0.1: Audio: mp3, 44100 Hz, mono, s16, 96 kb/s
Incompatible pixel format 'yuv420p' for codec 'mjpeg', auto-selecting format 'yuvj420p'
[buffer @ 0xa49660] w:360 h:240 pixfmt:yuv420p tb:1/1000000 sar:0/1 sws_param:
[scale @ 0xa4fa80] w:360 h:240 fmt:yuv420p -> w:160 h:120 fmt:yuvj420p flags:0x4
Output #0, image2, to '/opt/lampp/htdocs/asp/tmp/thumbs/579/%03d.jpg':
Metadata:
hasKeyframes : true
audiodatarate : 96
hasVideo : true
stereo : false
canSeekToEnd : true
framerate : 30
audiosamplerate : 44000
videocodecid : 2
datasize : 13115146
lasttimestamp : 120
audiosamplesize : 16
audiosize : 1495000
hasAudio : true
audiodelay : 0
videosize : 11618286
metadatacreator : inlet media FLVTool2 v1.0.6 - http://www.inlet-media.de/flvtool2
lastkeyframetimestamp: 120
height : 240
filesize : 13147979
hasMetadata : true
audiocodecid : 2
videodatarate : 771
duration : 120
hasCuePoints : false
width : 360
encoder : Lavf53.10.0
Stream #0.0: Video: mjpeg, yuvj420p, 160x120, q=2-31, 200 kb/s, 90k tbn, 29.97 tbc
Stream mapping:
Stream #0.0 -> #0.0 (flv -> mjpeg)
Press [q] to stop, [?] for help
[image2 @ 0xa49720] Could not open file : /opt/lampp/htdocs/asp/tmp/thumbs/579/001.jpg
av_interleaved_write_frame(): Input/output error
It seems that php cannot create an directory into thumbs. The whole thing works if ffmpeg creates the files directly in "thumbs" dir without subdir.
Offline
Hmm...make sure the /opt/lampp/htdocs/asp/tmp/thumbs is writable by the username that runs the web server (also special cases like selinux, app-armor, grsecurity could influence this, chattr also).
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Offline
This is correct. Hmm...there is no difference between the thumb creation function for normal upload and the thumb creation function for mass csv importing (same frunction from libraries/framework/video.php).
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1