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.
I read about 3 post with same problem and no solution. RC4 was wroking perfect until i updated and got this issue which i need fix asap. have the same problem for 2 days now. and i can't upload nor does my videos get converted. Yes, i have uninstall and reinstalled ffmpeg.
Query: UPDATE video SET ext = 'flv', size = , duration = 1804.36, thumbs = 40, mobile = '0', server = 0, s3 = 0, status = 2 WHERE video_id = 3781 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 = 1804.36, ' at line 3
Error Number: 1064
http://forum.adultscriptpro.com/viewtop … 9855#p9855
http://forum.adultscriptpro.com/viewtop … 9854#p9854
Last edited by DuttyRock (2012-09-01 14:51:13)
Offline
Mysql query is bad because size of converted video is not calculated
It can't be calculated if there was something wrong with conversion and video doesn't exist.
Did you check whether video is converted fine and video file exists in destination directory?
Did you check in your Admin if all conversion tools and libs are OK?
This is first step to do.
Next is analyzing conversion logs.
Offline
Yeah i was getting a log review by hodmedia. http://forum.adultscriptpro.com/viewtopic.php?id=1713
3 post had the same problem, im starting to think it's the new ASP script. Just want to see a solution somewhere. It's annoying that i can't convert anything. vids being upload by members show as error in admin panel. 2 days n counting.
Offline
3 post had the same problem, im starting to think it's the new ASP script. Just want to see a solution somewhere. It's annoying that i can't convert anything. vids being upload by members show as error in admin panel. 2 days n counting.
No man, this is not script's error! I see it even without access to your server.
It is very clear that mysql query is invalid because of missing "size" value.
If it is null - this means that video was not converted, doesn't exists.
Your conversion log shows that conversion failed: HD: conversion failed!
And this the reason of your problem. This means that ffmpeg command failed. Not the script.
From log you can see it fails to assign CRF value.
You were told to check in admin->video->conversion CRF value. It can't be 0 or null
You can also try to change Bitrate Method to Auto.
If this won't help you will need to reinstall ffmpeg or get someone to install it correctly.
Installation of ffmpeg is not so obvious. It can vary form distro to distro, from version to version, can depend on different server setups.
There is no ONE universal installation method. I know that well as I did it hundreds times.
BTW.
Just imagine developer who wrote the script. Script is working properly, but someone comes and write about script's error, which is not.
This is really not nice, people should not do that until they're sure what they write about.
Last edited by Nuevolab (2012-09-01 02:14:49)
Offline
oh don't get me wrong. im not blaming the script because RC4 worked perfect, if you checked the links other people had the same issue and no solution was posted, and it so happens that this is from the updated script. im just trying to see if it's a bug that need fixing so current and future members can find a fix.
anyhow, i did change CRF from 0 to 22, the video is present in the upload folder from (FTP Upload), error when uploaded from front end, I also payed someone to install ffmpeg and x264 yesterday. same error. same failure.
Last edited by DuttyRock (2012-09-01 02:46:39)
Offline
paste your ffmpeg from ssh that would tell me if you have the correct version.. i fixed the error by upgrading my ffmpeg its your ffmpeg thats causing the mysql error also post a recent log from yout tmp/logs
Last edited by hodmedia (2012-09-01 04:34:33)
Offline
FFmpeg version 0.6.5, Copyright (c) 2000-2010 the FFmpeg developers
built on Jan 29 2012 23:55:02 with gcc 4.1.2 20080704 (Red Hat 4.1.2-51)
configuration: --prefix=/usr --libdir=/usr/lib64 --shlibdir=/usr/lib64 --mandi r=/usr/share/man --incdir=/usr/include --disable-avisynth --extra-cflags='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp- buffer-size=4 -m64 -mtune=generic -fPIC' --enable-avfilter --enable-avfilter-lav f --enable-libdirac --enable-libfaac --enable-libfaad --enable-libfaadbin --enab le-libgsm --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-am rwb --enable-libx264 --enable-gpl --enable-nonfree --enable-postproc --enable-pt hreads --enable-shared --enable-swscale --enable-vdpau --enable-version3 --enabl e-x11grab
libavutil 50.15. 1 / 50.15. 1
libavcodec 52.72. 2 / 52.72. 2
libavformat 52.64. 2 / 52.64. 2
libavdevice 52. 2. 0 / 52. 2. 0
libavfilter 1.19. 0 / 1.19. 0
libswscale 0.11. 0 / 0.11. 0
libpostproc 51. 2. 0 / 51. 2. 0
FFmpeg 0.6.5
libavutil 50.15. 1 / 50.15. 1
libavcodec 52.72. 2 / 52.72. 2
libavformat 52.64. 2 / 52.64. 2
libavdevice 52. 2. 0 / 52. 2. 0
libavfilter 1.19. 0 / 1.19. 0
libswscale 0.11. 0 / 0.11. 0
libpostproc 51. 2. 0 / 51. 2. 0Offline
Okay... i will get on him another day. So it's it's outdated ffmpeg... will im on it then. if i find a fix i will post it up for those who need help. Second thought, let me play some MW3 first. relax the mind.
Offline
you should get a refund from who ever installed that is an super old version of ffmpeg 2000-2010 the latest version is 2000-2012 he may have just did yum install to install that
Had the guy installed ffmpeg 0.10.4 and FLV coverts fine no more error. now time to figure out how to make it convert to MP4 and not flv.
ffmpeg version 0.10.4
built on Sep 1 2012 16:53:25 with gcc 4.1.2 20080704 (Red Hat 4.1.2-52)
configuration: --enable-gpl --enable-libmp3lame --enable-libtheora --enable-libvo-aacenc --enable-libvorbis --enable-libvpx --enable-libx264 --enable-version3 --prefix=/usr/local
libavutil 51. 35.100 / 51. 35.100
libavcodec 53. 61.100 / 53. 61.100
libavformat 53. 32.100 / 53. 32.100
libavdevice 53. 4.100 / 53. 4.100
libavfilter 2. 61.100 / 2. 61.100
libswscale 2. 1.100 / 2. 1.100
libswresample 0. 6.100 / 0. 6.100
libpostproc 52. 0.100 / 52. 0.100Last edited by DuttyRock (2012-09-01 14:50:41)
Offline
i told ya man lol and flv is fine dont worry about mp4 they get bigger after a while and you will be buying more HD space trust me i know flv is smaller when you are working with clips ive had sites with mp4 that range from 200mbs each and i know flv is smaller
Offline
Yeah you was on point. but i don't mess with FLV... i want to do MP4, file size is smaller, plus better traffic shaping. any ideas how to get them only to MP4? my old setting from RC4 don't work. when i click "convert mobile" it don't convert either. i check "which x264" and it shows installed in the right location.
Offline
Please send me a email with ssh root access and i will check your ffmpeg.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Please send me a email with ssh root access and i will check your ffmpeg.
Okay i sent it in the e-mail
jus manually convert them to mobile it will do it in the background but it will work thats how i do it just click the videos 1by1 and do it
that's what i usually do, but no MP4 of any type is executing.
Last edited by DuttyRock (2012-09-01 18:01:31)
Offline
You modified config/video.php and you changed the reference width/height for the MP4 conversion. It works now.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
That's what i had to do in RC4 to make all video convert to MP4 because the command in video>config don't work. even when i have FLV conversion to "NO" it only convert to FLV.
Anyhow, the problem still wasn't fix. Your test file still can't convert to mobile. No file can convert to mobile, and i edit the config/video.php so all video at 320x240 convert to MP4 and not FLV. But before anything im still trying to get this conversion stuff working with the new script 1.0.1
Hey admin, what version ffmpeg you have installed with script 1.0.1??? this info might help us all.
Last edited by DuttyRock (2012-09-03 05:51:44)
Offline
I fixed the mp4 part. You have edited the wrong partof the config/video.php file and thats why it didnt work. I will also check mobile and fix. Any ffmpeg version > 0.10 will work.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
I upload files that was 320x240 and none was converted to MP4. since i edit the wrong part which part should i edit??? i don't want to use FLV at all only MP4, no matter how small or large the video i just want i to convert to MP4. what do i need to edit to make this happen?
Offline
Duration: 00:00:37.67, start: 0.000000, bitrate: 1131 kb/s
Stream #0:0(eng): Video: h264 (High) (avc1 / 0x31637661), yuv420p, 960x540 [SAR 1:1 DAR 16:9], 997 kb/s, 25 fps, 25 tbr, 25k tbn, 50 tbc
Metadata:
creation_time : 2010-05-19 15:32:58
handler_name : GPAC ISO Video Handler
Stream #0:1(eng): Audio: aac (mp4a / 0x6134706D), 48000 Hz, stereo, s16, 137 kb/s
Metadata:
creation_time : 2010-05-19 15:32:58
handler_name : GPAC ISO Audio Handler
Unknown encoder 'libfaac'
I just checked your server. Your ffmpeg is not installed correctly. There is a minimum width/height for mp4 videos, you can set it in config/video.php (just check the names and its self explanatory) and you need to modify the files for the upload method you are using to disable the FLV conversion. The FLV conversion cannot be disabled from the administration panel.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Yeah that's what i did with config/video.php, i change the minimum to 320x240 for MP4 and change FLV to some high resolution like 1260x720. So the script gets the 1064 error with ffmpeg 6.5.0 but the newer ffmpeg 0.10.x don't have libfaac compiled. well that's a start in the right direction. So just have to add libfaac support to the newer ffmpegs and everything should work.
Offline
All fix, the guy said he added libfaac in ffmpeg 0.10.4
Last edited by DuttyRock (2012-09-03 20:32:49)
Offline