Problem downloading video from youtube with youtube-dl-开源...

来自 : CSDN技术社区 发布时间：2021-03-24

私信 访问主页

weixin_39552874 2020-11-27 21:07 首页 开源项目 Problem downloading video from youtube with youtube-dl

I have tried downloading video shared from youtube, but stuck with this error.

I have download the new version youtube-dl to my instance, but still cannot solve this problem

Do you have any suggestions or what cause this problem?

p.s. it happens with some videos, and the video that have problem I have tried on your demos site and not found any problems.

Error in Encoder log shows:

[28-Apr-2020 23:52:18 Asia/Shanghai] getTitleFromLink: Get Title: LC_ALL en_US.UTF-8 /usr/local/bin/youtube-dl --no-check-certificate --no-playlist --force-ipv4 --skip-download -e https://www.youtube.com/watch?v TyEX5cTgea4 Array [0] WARNING: Assuming --restrict-filenames since file system encoding cannot encode all characters. Set the LC_ALL environment variable to fix this. [1] )

[28-Apr-2020 23:52:18 Asia/Shanghai] youtubeDl::addVideo We could not get the title () of your video (https://www.youtube.com/watch?v TyEX5cTgea4)

该提问来源于开源项目 WWBN/AVideo

点赞 写回答 收藏 复制链接分享 删除 再等等 结题 再想想 20条回答

私信 访问主页

weixin_39552874 3月前

Hi guys, I just can fixed the issue by restore all changes and then only change the encoding in mysql for column encoder_queue for db aVideo-Encoder

ALTER TABLE encoder_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

After doing this, it seems encoder can download youtube video.

Thanks both :)

点赞 评论 复制链接分享

私信 访问主页

weixin_39620334 3月前

if you manually run this code what is the output?

ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:360 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_Low.mp4

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

and how can I fix this issue?

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

yea, is it due to db alter change?

点赞 评论 复制链接分享

私信 访问主页

weixin_39960145 3月前

I see no problems . even encoding starts : ffmpeg -i /var/www/html/macrocare/Encoder/videos/2_tmpFile.mp4 -vf scale -2:1080 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/2_tmpFile_converted_HD.mp4

But also { status : error , msg : getDurationFromFile ERROR, File () Not Found }

I m confused

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

Yes, it s working and video can downloaded

点赞 评论 复制链接分享

私信 访问主页

weixin_39960145 3月前

Run this on your server ( cmd )

youtube-dl -v https://youtu.be/QgaTQ5-XfMM

Does it works ?

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

I don t see any errors anymore .

[0] WARNING: Assuming --restrict-filenames since file system encoding cannot encode all characters. Set the LC_ALL environment variable to fix this.[1]

this lines has disappeared .

Here s the log

encoder.log

点赞 评论 复制链接分享

私信 访问主页

weixin_39960145 3月前

I don t see any errors anymore .

[0] WARNING: Assuming --restrict-filenames since file system encoding cannot encode all characters. Set the LC_ALL environment variable to fix this.[1]

this lines has disappeared .

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

I ve reconfigure the locales to en_US.UTF-8

However, this new error persists with all encoding

[29-Apr-2020 01:15:29 Asia/Shanghai] getTitleFromLink: Get Title: LC_ALL en_US.UTF-8 /usr/local/bin/youtube-dl --no-check-certificate --no-playlist --force-ipv4 --skip-download -e https://youtu.be/QgaTQ5-XfMM Array [0] Christina Perri - A Thousand Years (Piano/Cello Cover))

[29-Apr-2020 01:15:29 Asia/Shanghai] decideFormatOrder: { videoURL : https:\\/\\/youtu.be\\/QgaTQ5-XfMM , audioOnly : false , spectrum : false , webm : false , inputHLS : false , inputLow : true , inputSD : true , inputHD : true , categories_id : 0 }[29-Apr-2020 01:15:29 Asia/Shanghai] decideFormatOrder: MP4 All[29-Apr-2020 01:15:29 Asia/Shanghai] Encoder::sendFile videos_id 0, format mp4[29-Apr-2020 01:15:29 Asia/Shanghai] { status : error , msg : getDurationFromFile ERROR, File () Not Found }[29-Apr-2020 01:15:32 Asia/Shanghai] Encoder::sendFile sending file to http://localhost/aVideoEncoder.json[29-Apr-2020 01:15:32 Asia/Shanghai] Encoder::sendFile reading file from[29-Apr-2020 01:15:32 Asia/Shanghai] AVideo-Streamer answer { error :false, video_id :94}[29-Apr-2020 01:15:32 Asia/Shanghai] { error :false, format : mp4 , file : , resolution : , videoDownloadedLink : https:\\/\\/youtu.be\\/QgaTQ5-XfMM , target : http:\\/\\/localhost\\/aVideoEncoder.json , postFields :12, response_raw : {\\ error\\ :false,\\ video_id\\ :94} , response :{ error :false, video_id :94}}[29-Apr-2020 01:15:32 Asia/Shanghai] Encoder::save id () title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :143, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :852, function : setReturn_varsVideos_id , class : Encoder , object :{}, type : - , args :[94]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :71, function : sendFile , class : Encoder , type : :: , args :[ ,0, mp4 ,{}]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :117, function : addVideo , args :[ https:\\/\\/youtu.be\\/QgaTQ5-XfMM , 2 ]}][29-Apr-2020 01:15:32 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :77, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :117, function : addVideo , args :[ https:\\/\\/youtu.be\\/QgaTQ5-XfMM , 2 ]}][29-Apr-2020 01:15:35 Asia/Shanghai] getReturn_vars { videos_id :94}[29-Apr-2020 01:15:35 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :532, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:15:35 Asia/Shanghai] downloadFile: start queue_id 5[29-Apr-2020 01:15:35 Asia/Shanghai] downloadFile: url https://youtu.be/QgaTQ5-XfMM[29-Apr-2020 01:15:35 Asia/Shanghai] getYoutubeDl: Getting from Youtube DL /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlLU1ams.mp4 -f mp4 https://youtu.be/QgaTQ5-XfMM [29-Apr-2020 01:15:37 Asia/Shanghai] /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlLU1ams.mp4 -f mp4 https://youtu.be/QgaTQ5-XfMM Array)

[29-Apr-2020 01:15:37 Asia/Shanghai] getYoutubeDl: Getting from Youtube other option DL /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlLU1ams.mp4 https://youtu.be/QgaTQ5-XfMM [29-Apr-2020 01:15:40 Asia/Shanghai] /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlLU1ams.mp4 https://youtu.be/QgaTQ5-XfMM Array)

[29-Apr-2020 01:15:40 Asia/Shanghai] downloadFile:getYoutubeDl queue_id 5[29-Apr-2020 01:15:40 Asia/Shanghai] downloadFile: success[29-Apr-2020 01:15:40 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :276, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :533, function : downloadFile , class : Encoder , type : :: , args :[ 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:15:40 Asia/Shanghai] downloadFile: { error :false, filename : 5_tmpFile.mp4 , pathFileName : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 }[29-Apr-2020 01:15:40 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :550, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:15:40 Asia/Shanghai] sendImages: Sending image to [94][29-Apr-2020 01:15:40 Asia/Shanghai] { status : error , msg : getDurationFromFile ERROR, File (/var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4) Not Found }[29-Apr-2020 01:15:40 Asia/Shanghai] sendImages: AVideo-Encoder sending file to http://localhost/objects/aVideoEncoderReceiveImage.json.php[29-Apr-2020 01:15:40 Asia/Shanghai] sendImages: AVideo-Encoder reading file from /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4[29-Apr-2020 01:15:42 Asia/Shanghai] getThumbsFromLink: /usr/local/bin/youtube-dl --no-check-certificate --no-playlist --force-ipv4 --write-thumbnail --skip-download -o /tmp/thumbsHhtSTc.jpg https://youtu.be/QgaTQ5-XfMM [29-Apr-2020 01:15:42 Asia/Shanghai] PHP Warning: A non-numeric value encountered in /var/www/html/macrocare/Encoder/objects/Encoder.php on line 1238[29-Apr-2020 01:15:42 Asia/Shanghai] getGifImage[29-Apr-2020 01:15:42 Asia/Shanghai] getGif: Starts[29-Apr-2020 01:15:42 Asia/Shanghai] getGif: takes 0.064129114151001 sec to complete[29-Apr-2020 01:15:42 Asia/Shanghai] Create Pallete Gif Image error: ffmpeg -y -ss 00:00:00 -t 3 -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf fps 10,scale 320:-1:flags lanczos,palettegen /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4palette.png[29-Apr-2020 01:15:42 Asia/Shanghai] PHP Warning: A non-numeric value encountered in /var/www/html/macrocare/Encoder/objects/Encoder.php on line 1238[29-Apr-2020 01:15:42 Asia/Shanghai] getWebpImage[29-Apr-2020 01:15:42 Asia/Shanghai] getWebpImage: Starts[29-Apr-2020 01:15:42 Asia/Shanghai] getWebpImage: takes 0.05341100692749 sec to complete[29-Apr-2020 01:15:42 Asia/Shanghai] getWebpImage: Image error : ffmpeg -y -ss 00:00:00 -t 3 -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vcodec libwebp -lossless 1 -vf fps 10,scale 640:-1 -q 60 -preset default -loop 0 -an -vsync 0 /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4.webp [ ffmpeg version 3.4.6-0ubuntu0.18.04.1 Copyright (c) 2000-2019 the FFmpeg developers , built with gcc 7 (Ubuntu 7.3.0-16ubuntu3) , configuration: --prefix \\/usr --extra-version 0ubuntu0.18.04.1 --toolchain hardened --libdir \\/usr\\/lib\\/x86_64-linux-gnu --incdir \\/usr\\/include\\/x86_64-linux-gnu --enable-gpl --disable-stripping --enable-avresample --enable-avisynth --enable-gnutls --enable-ladspa --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libcdio --enable-libflite --enable-libfontconfig --enable-libfreetype --enable-libfribidi --enable-libgme --enable-libgsm --enable-libmp3lame --enable-libmysofa --enable-libopenjpeg --enable-libopenmpt --enable-libopus --enable-libpulse --enable-librubberband --enable-librsvg --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libssh --enable-libtheora --enable-libtwolame --enable-libvorbis --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx265 --enable-libxml2 --enable-libxvid --enable-libzmq --enable-libzvbi --enable-omx --enable-openal --enable-opengl --enable-sdl2 --enable-libdc1394 --enable-libdrm --enable-libiec61883 --enable-chromaprint --enable-frei0r --enable-libopencv --enable-libx264 --enable-shared , libavutil 55. 78.100 \\/ 55. 78.100 , libavcodec 57.107.100 \\/ 57.107.100 , libavformat 57. 83.100 \\/ 57. 83.100 , libavdevice 57. 10.100 \\/ 57. 10.100 , libavfilter 6.107.100 \\/ 6.107.100 , libavresample 3. 7. 0 \\/ 3. 7. 0 , libswscale 4. 8.100 \\/ 4. 8.100 , libswresample 2. 9.100 \\/ 2. 9.100 , libpostproc 54. 7.100 \\/ 54. 7.100 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4: No such file or directory ][29-Apr-2020 01:15:42 Asia/Shanghai] sendImages: curl_init[29-Apr-2020 01:15:42 Asia/Shanghai] sendImages: curl_exec[29-Apr-2020 01:15:42 Asia/Shanghai] sendImages: AVideo-Streamer answer { error :false, video_id :94}[29-Apr-2020 01:15:42 Asia/Shanghai] { error :false, file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , target : http:\\/\\/localhost\\/objects\\/aVideoEncoderReceiveImage.json.php , postFields :7, response_raw : {\\ error\\ :false,\\ video_id\\ :94} , response :{ error :false, video_id :94}}[29-Apr-2020 01:15:42 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :143, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :979, function : setReturn_varsVideos_id , class : Encoder , object :{}, type : - , args :[94]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :552, function : sendImages , class : Encoder , type : :: , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 ,94,{}]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:15:42 Asia/Shanghai] run:runMultiResolution[29-Apr-2020 01:15:42 Asia/Shanghai] AVideo-Encoder Start Encoder [ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:1080 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_HD.mp4][29-Apr-2020 01:15:42 Asia/Shanghai] ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:1080 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_HD.mp4 --- [] --- (8, /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4, /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_HD.mp4, 5)[29-Apr-2020 01:15:42 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :334, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :359, function : exec , class : Format , type : :: , args :[ 8 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile_converted_HD.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :77, function : execOrder , class : Format , type : :: , args :[12, \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile_converted_HD.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :62, function : runMultiResolution , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , 5 , 80 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :555, function : run , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:15:42 Asia/Shanghai] AVideo-Encoder Start Encoder [ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:720 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_SD.mp4][29-Apr-2020 01:15:43 Asia/Shanghai] ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:720 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_SD.mp4 --- [] --- (7, /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4, /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_SD.mp4, 5)[29-Apr-2020 01:15:43 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :334, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :359, function : exec , class : Format , type : :: , args :[ 7 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile_converted_SD.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :83, function : execOrder , class : Format , type : :: , args :[11, \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile_converted_SD.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :62, function : runMultiResolution , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , 5 , 80 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :555, function : run , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:15:43 Asia/Shanghai] AVideo-Encoder Start Encoder [ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:360 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_Low.mp4][29-Apr-2020 01:15:43 Asia/Shanghai] ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:360 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_Low.mp4 --- [] --- (1, /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4, /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_Low.mp4, 5)[29-Apr-2020 01:15:43 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :334, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :359, function : exec , class : Format , type : :: , args :[ 1 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile_converted_Low.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :89, function : execOrder , class : Format , type : :: , args :[10, \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile_converted_Low.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :62, function : runMultiResolution , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , 5 , 80 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :555, function : run , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/5_tmpFile.mp4 , 5 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:15:43 Asia/Shanghai] Trying again: [1] Execute code error Array\\n(\\n)\\n Code: ffmpeg -i /var/www/html/macrocare/Encoder/videos/5_tmpFile.mp4 -vf scale -2:360 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/5_tmpFile_converted_Low.mp4[29-Apr-2020 01:15:43 Asia/Shanghai] Encoder::save id (5) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :562, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}]

点赞 评论 复制链接分享

私信 访问主页

weixin_39960145 3月前

ok , try reconfiguring ( if you re using Ubuntu ) Type on your cmddpkg-reconfigure locales

and select UTF-8

This is a CPython issue actually .

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

This worksALTER TABLE encoder_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

mysql ALTER TABLE encoder_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;Query OK, 0 rows affected (0.01 sec)Records: 0 Duplicates: 0 Warnings: 0

This still return errorALTER TABLE encoder_queue CHANGE filename title downloadedFileName VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

mysql ALTER TABLE encoder_queue CHANGE filename title downloadedFileName VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;ERROR 1064 (42000): 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 downloadedFileName VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci at line 1

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

I ve tried and got more problem which cannot encode from youtube anymore even English title T-T

[29-Apr-2020 01:04:12 Asia/Shanghai] getTitleFromLink: Get Title: LC_ALL en_US.UTF-8 /usr/local/bin/youtube-dl --no-check-certificate --no-playlist --force-ipv4 --skip-download -e https://youtu.be/QgaTQ5-XfMM Array [0] WARNING: Assuming --restrict-filenames since file system encoding cannot encode all characters. Set the LC_ALL environment variable to fix this. [1] Christina Perri - A Thousand Years (Piano/Cello Cover))

[29-Apr-2020 01:04:12 Asia/Shanghai] decideFormatOrder: { videoURL : https:\\/\\/youtu.be\\/QgaTQ5-XfMM , audioOnly : false , spectrum : false , webm : false , inputHLS : false , inputLow : true , inputSD : true , inputHD : true , categories_id : 0 }[29-Apr-2020 01:04:12 Asia/Shanghai] decideFormatOrder: MP4 All[29-Apr-2020 01:04:12 Asia/Shanghai] Encoder::sendFile videos_id 0, format mp4[29-Apr-2020 01:04:12 Asia/Shanghai] { status : error , msg : getDurationFromFile ERROR, File () Not Found }[29-Apr-2020 01:04:14 Asia/Shanghai] Encoder::sendFile sending file to http://18.138.241.154/aVideoEncoder.json[29-Apr-2020 01:04:14 Asia/Shanghai] Encoder::sendFile reading file from[29-Apr-2020 01:04:14 Asia/Shanghai] AVideo-Streamer answer { error :false, video_id :93}[29-Apr-2020 01:04:14 Asia/Shanghai] { error :false, format : mp4 , file : , resolution : , videoDownloadedLink : https:\\/\\/youtu.be\\/QgaTQ5-XfMM , target : http:\\/\\/18.138.241.154\\/aVideoEncoder.json , postFields :12, response_raw : {\\ error\\ :false,\\ video_id\\ :93} , response :{ error :false, video_id :93}}[29-Apr-2020 01:04:14 Asia/Shanghai] Encoder::save id () title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :143, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :852, function : setReturn_varsVideos_id , class : Encoder , object :{}, type : - , args :[93]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :71, function : sendFile , class : Encoder , type : :: , args :[ ,0, mp4 ,{}]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :117, function : addVideo , args :[ https:\\/\\/youtu.be\\/QgaTQ5-XfMM , 5 ]}][29-Apr-2020 01:04:14 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :77, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/youtubeDl.json.php , line :117, function : addVideo , args :[ https:\\/\\/youtu.be\\/QgaTQ5-XfMM , 5 ]}][29-Apr-2020 01:04:15 Asia/Shanghai] getReturn_vars { videos_id :93}[29-Apr-2020 01:04:15 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :532, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:04:15 Asia/Shanghai] downloadFile: start queue_id 4[29-Apr-2020 01:04:15 Asia/Shanghai] downloadFile: url https://youtu.be/QgaTQ5-XfMM[29-Apr-2020 01:04:15 Asia/Shanghai] getYoutubeDl: Getting from Youtube DL /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlhyKDyq.mp4 -f mp4 https://youtu.be/QgaTQ5-XfMM [29-Apr-2020 01:04:17 Asia/Shanghai] /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlhyKDyq.mp4 -f mp4 https://youtu.be/QgaTQ5-XfMM Array)

[29-Apr-2020 01:04:17 Asia/Shanghai] getYoutubeDl: Getting from Youtube other option DL /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlhyKDyq.mp4 https://youtu.be/QgaTQ5-XfMM [29-Apr-2020 01:04:19 Asia/Shanghai] /usr/local/bin/youtube-dl --no-check-certificate --force-ipv4 --no-check-certificate --no-playlist -k -o /tmp/youtubeDlhyKDyq.mp4 https://youtu.be/QgaTQ5-XfMM Array)

[29-Apr-2020 01:04:19 Asia/Shanghai] downloadFile:getYoutubeDl queue_id 4[29-Apr-2020 01:04:19 Asia/Shanghai] downloadFile: success[29-Apr-2020 01:04:19 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :276, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :533, function : downloadFile , class : Encoder , type : :: , args :[ 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:04:19 Asia/Shanghai] downloadFile: { error :false, filename : 4_tmpFile.mp4 , pathFileName : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 }[29-Apr-2020 01:04:19 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :550, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:04:19 Asia/Shanghai] sendImages: Sending image to [93][29-Apr-2020 01:04:19 Asia/Shanghai] { status : error , msg : getDurationFromFile ERROR, File (/var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4) Not Found }[29-Apr-2020 01:04:19 Asia/Shanghai] sendImages: AVideo-Encoder sending file to http://18.138.241.154/objects/aVideoEncoderReceiveImage.json.php[29-Apr-2020 01:04:19 Asia/Shanghai] sendImages: AVideo-Encoder reading file from /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4[29-Apr-2020 01:04:21 Asia/Shanghai] getThumbsFromLink: /usr/local/bin/youtube-dl --no-check-certificate --no-playlist --force-ipv4 --write-thumbnail --skip-download -o /tmp/thumbsnOac5N.jpg https://youtu.be/QgaTQ5-XfMM [29-Apr-2020 01:04:21 Asia/Shanghai] PHP Warning: A non-numeric value encountered in /var/www/html/macrocare/Encoder/objects/Encoder.php on line 1238[29-Apr-2020 01:04:21 Asia/Shanghai] getGifImage[29-Apr-2020 01:04:21 Asia/Shanghai] getGif: Starts[29-Apr-2020 01:04:21 Asia/Shanghai] getGif: takes 0.065238952636719 sec to complete[29-Apr-2020 01:04:21 Asia/Shanghai] Create Pallete Gif Image error: ffmpeg -y -ss 00:00:00 -t 3 -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf fps 10,scale 320:-1:flags lanczos,palettegen /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4palette.png[29-Apr-2020 01:04:21 Asia/Shanghai] PHP Warning: A non-numeric value encountered in /var/www/html/macrocare/Encoder/objects/Encoder.php on line 1238[29-Apr-2020 01:04:21 Asia/Shanghai] getWebpImage[29-Apr-2020 01:04:21 Asia/Shanghai] getWebpImage: Starts[29-Apr-2020 01:04:21 Asia/Shanghai] getWebpImage: takes 0.06030797958374 sec to complete[29-Apr-2020 01:04:21 Asia/Shanghai] getWebpImage: Image error : ffmpeg -y -ss 00:00:00 -t 3 -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vcodec libwebp -lossless 1 -vf fps 10,scale 640:-1 -q 60 -preset default -loop 0 -an -vsync 0 /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4.webp [ ffmpeg version 3.4.6-0ubuntu0.18.04.1 Copyright (c) 2000-2019 the FFmpeg developers , built with gcc 7 (Ubuntu 7.3.0-16ubuntu3) , configuration: --prefix \\/usr --extra-version 0ubuntu0.18.04.1 --toolchain hardened --libdir \\/usr\\/lib\\/x86_64-linux-gnu --incdir \\/usr\\/include\\/x86_64-linux-gnu --enable-gpl --disable-stripping --enable-avresample --enable-avisynth --enable-gnutls --enable-ladspa --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libcdio --enable-libflite --enable-libfontconfig --enable-libfreetype --enable-libfribidi --enable-libgme --enable-libgsm --enable-libmp3lame --enable-libmysofa --enable-libopenjpeg --enable-libopenmpt --enable-libopus --enable-libpulse --enable-librubberband --enable-librsvg --enable-libshine --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libssh --enable-libtheora --enable-libtwolame --enable-libvorbis --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx265 --enable-libxml2 --enable-libxvid --enable-libzmq --enable-libzvbi --enable-omx --enable-openal --enable-opengl --enable-sdl2 --enable-libdc1394 --enable-libdrm --enable-libiec61883 --enable-chromaprint --enable-frei0r --enable-libopencv --enable-libx264 --enable-shared , libavutil 55. 78.100 \\/ 55. 78.100 , libavcodec 57.107.100 \\/ 57.107.100 , libavformat 57. 83.100 \\/ 57. 83.100 , libavdevice 57. 10.100 \\/ 57. 10.100 , libavfilter 6.107.100 \\/ 6.107.100 , libavresample 3. 7. 0 \\/ 3. 7. 0 , libswscale 4. 8.100 \\/ 4. 8.100 , libswresample 2. 9.100 \\/ 2. 9.100 , libpostproc 54. 7.100 \\/ 54. 7.100 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4: No such file or directory ][29-Apr-2020 01:04:21 Asia/Shanghai] sendImages: curl_init[29-Apr-2020 01:04:21 Asia/Shanghai] sendImages: curl_exec[29-Apr-2020 01:04:22 Asia/Shanghai] sendImages: AVideo-Streamer answer { error :false, video_id :93}[29-Apr-2020 01:04:22 Asia/Shanghai] { error :false, file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , target : http:\\/\\/18.138.241.154\\/objects\\/aVideoEncoderReceiveImage.json.php , postFields :7, response_raw : {\\ error\\ :false,\\ video_id\\ :93} , response :{ error :false, video_id :93}}[29-Apr-2020 01:04:22 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :143, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :979, function : setReturn_varsVideos_id , class : Encoder , object :{}, type : - , args :[93]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :552, function : sendImages , class : Encoder , type : :: , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 ,93,{}]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:04:22 Asia/Shanghai] run:runMultiResolution[29-Apr-2020 01:04:22 Asia/Shanghai] AVideo-Encoder Start Encoder [ffmpeg -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf scale -2:1080 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_HD.mp4][29-Apr-2020 01:04:22 Asia/Shanghai] ffmpeg -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf scale -2:1080 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_HD.mp4 --- [] --- (8, /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4, /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_HD.mp4, 4)[29-Apr-2020 01:04:22 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :334, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :359, function : exec , class : Format , type : :: , args :[ 8 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile_converted_HD.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :77, function : execOrder , class : Format , type : :: , args :[12, \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile_converted_HD.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :62, function : runMultiResolution , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , 4 , 80 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :555, function : run , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:04:22 Asia/Shanghai] AVideo-Encoder Start Encoder [ffmpeg -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf scale -2:720 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_SD.mp4][29-Apr-2020 01:04:22 Asia/Shanghai] ffmpeg -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf scale -2:720 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_SD.mp4 --- [] --- (7, /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4, /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_SD.mp4, 4)[29-Apr-2020 01:04:22 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :334, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :359, function : exec , class : Format , type : :: , args :[ 7 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile_converted_SD.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :83, function : execOrder , class : Format , type : :: , args :[11, \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile_converted_SD.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :62, function : runMultiResolution , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , 4 , 80 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :555, function : run , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:04:22 Asia/Shanghai] AVideo-Encoder Start Encoder [ffmpeg -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf scale -2:360 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_Low.mp4][29-Apr-2020 01:04:22 Asia/Shanghai] ffmpeg -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf scale -2:360 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_Low.mp4 --- [] --- (1, /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4, /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_Low.mp4, 4)[29-Apr-2020 01:04:22 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :334, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :359, function : exec , class : Format , type : :: , args :[ 1 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile_converted_Low.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :89, function : execOrder , class : Format , type : :: , args :[10, \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile_converted_Low.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Format.php , line :62, function : runMultiResolution , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , 4 , 80 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :555, function : run , class : Format , object :{}, type : - , args :[ \\/var\\/www\\/html\\/macrocare\\/Encoder\\/videos\\/4_tmpFile.mp4 , 4 ]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}][29-Apr-2020 01:04:22 Asia/Shanghai] Trying again: [1] Execute code error Array\\n(\\n)\\n Code: ffmpeg -i /var/www/html/macrocare/Encoder/videos/4_tmpFile.mp4 -vf scale -2:360 -movflags faststart -preset ultrafast -vcodec h264 -acodec aac -strict -2 -max_muxing_queue_size 1024 -y /var/www/html/macrocare/Encoder/videos/4_tmpFile_converted_Low.mp4[29-Apr-2020 01:04:22 Asia/Shanghai] Encoder::save id (4) title (Christina Perri - A Thousand Years (Piano/Cello Cover))[{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/objects\\/Encoder.php , line :562, function : save , class : Encoder , object :{}, type : - , args :[]},{ file : \\/var\\/www\\/html\\/macrocare\\/Encoder\\/view\\/run.php , line :6, function : run , class : Encoder , type : :: , args :[]}]

点赞 评论 复制链接分享

私信 访问主页

weixin_39960145 3月前

Actually , this could make sense .The UTF8MB4 , can have a maximum of 191 varchar . ( uses 4 bytes )The UTF8 can reach 255 varchar ( 3 bytes )

Try changing the value to 191

Try this one after changing the value to 191 or 190

ALTER TABLE encoder_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE encoder_queue CHANGE filename title downloadedFileName VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

The second command line should not give errors since it s 191 varchar

Try it out .

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

but as I ve tried alter the table, it works for SQL execution, but encode from Youtube link still not working :(

mysql ALTER TABLE encoder_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;Query OK, 0 rows affected (0.04 sec)Records: 0 Duplicates: 0 Warnings: 0

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

Still getting this frustrating error, could you please provide me the mysql command that could work?p.s. I ve added the configuration encoder successfully.

mysql ALTER TABLE encoder_queue CHANGE filename VARCHAR(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;ERROR 1064 (42000): 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 VARCHAR(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci at line 1mysql ALTER TABLE encoder_queue CHANGE filename VARCHAR(400) CHARACTER SET utf8mb4;ERROR 1064 (42000): 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 VARCHAR(400) CHARACTER SET utf8mb4 at line 1

点赞 评论 复制链接分享

私信 访问主页

weixin_39960145 3月前

### 1- You don t need to convert the entire DB , you need to convert the tables only .To be precise , the table encoder_queue . And the columns that should be changed are : filename , title , downloadedFileNameThose need to be on utf8mb4

ERROR 1064 (42000): 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

You maybe getting this error because not all columns has a collation type . Example streamers_id , does not have a collation type .Only the VarChar type can alter collation

### 2- And another tip : add this line on your configuration encoder .

...................$global[ disableImportVideo ] false;$global[ mysqli_charset ] utf8mb4_unicode_ci

..................

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

I ve tried to set db CHAR_SET, but got this error when trying to convert Encoder db

mysql ALTER DATABASE aVideo-Encoder CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;ERROR 1064 (42000): 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 -Encoder CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci at line 1

p.s. aVideo DB converting fine

点赞 评论 复制链接分享

私信 访问主页

weixin_39552874 3月前

oh! thanks, in which table do I need to set it?

点赞 评论 复制链接分享

私信 访问主页

weixin_39960145 3月前

It s not a bug , but you need to set your db to use uft8 or utf8mb4

点赞 评论 复制链接分享 提交 再想想 采纳 为你推荐 PHP exec输出不返回并执行命令 cmdwindowsyoutube-dlphpexec 1个回答 点击登录 提问题 欢迎建议意见 . 如何写高质量提问和回答？ 采纳榜7天 被采纳次数 ProfSnail 25 幻灰龙 19 qq_34124780 154 coagenth 115 规则边缘 116 GoCityPass新加坡曼谷通票 117 cpp_learner 98 Jack_Yang(数据分析及可视化) 99 我不喜欢这个世界 810 天际的海浪 6 加急问题 500 500 基于tensorflow的模型做预测时，cpu占用率过高，如何降低程序的cpu占用率？ 500 如何将蓝鲸智云社区版6.0.2的流程服务和监控平台(SAAS应用）从中文切换到英文 100 unity 设置Animation的culling type 导致游戏崩溃 100 java实现下面两个算法 100 ECDSA加密算法中，签名和验证都是需要时间的，那其时间复杂度怎么用椭圆曲线参数如阶或模p来表示呢？ 75 数据库只有myd文件没有frm,myi文件，怎么打开呢 51 利用Adams联合matlab仿真求运动学反解问题 50 labview使用datasocket与c/c#程序的通信 50 如何用C语言实现凯撒密码对文本文件(.txt)的读取穷举暴力破解？ 50 已知地图GPS坐标点A和坐标点B，获取A点往B点直线走一定距离的坐标点经纬度？