search

WWBN / AVideo-Encoder

Encoder Server for AVideo Platform Open-Source
https://platform.avideo.com
GNU Affero General Public License v3.0
152 stars 189 forks source link

YT-Videos with emojis won't get send to the website #384

Open mj1985 opened 3 years ago

mj1985 commented 3 years ago

Hey, I tried to get this youtube video with the encoder. Encoding the vid itself is working without any problem, but the video won't be transfered to the website. YT Video example with emoji in the title: https://www.youtube.com/watch?v=U4n3GQqnMyw

Error message:

[28-May-2021 00:05:45 Europe/Berlin] {"error":true,"file":"\/var\/www\/clients\/client2\/web1\/web\/YouPHPTube-Encoder\/videos\/avideoTmpFile_25_streamers_id_1__720.mp4","filesize":23612423,"response":null,"target":"https:\/\/videos.[REMOVED]\/aVideoEncoderChunk.json","response_raw":"","msg":"cURL error (92):\n Stream error in the HTTP\/2 framing layer \n \/var\/www\/clients\/client2\/web1\/web\/YouPHPTube-Encoder\/videos\/avideoTmpFile_25_streamers_id_1__720.mp4 \n (https:\/\/videos.[REMOVED]\/aVideoEncoderChunk.json)"}
[28-May-2021 00:05:45 Europe/Berlin] Encoder::sendFile videos_id=0, format=mp4
[28-May-2021 00:05:46 Europe/Berlin] Encoder::sendFile sending file to https://videos.[REMOVED]/aVideoEncoder.json
[28-May-2021 00:05:46 Europe/Berlin] Encoder::sendFile reading file from /var/www/clients/client2/web1/web/YouPHPTube-Encoder/videos/avideoTmpFile_25_streamers_id_1__720.mp4
[28-May-2021 00:05:47 Europe/Berlin] AVideo-Streamer answer 1 Execute query error, because: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
[28-May-2021 00:05:47 Europe/Berlin] {"error":true,"format":"mp4","file":"\/var\/www\/clients\/client2\/web1\/web\/YouPHPTube-Encoder\/videos\/avideoTmpFile_25_streamers_id_1__720.mp4","resolution":"720","videoDownloadedLink":"https:\/\/www.youtube.com\/watch?v=69Ndn__UEwo","target":"https:\/\/videos.[REMOVED]\/aVideoEncoder.json","postFields":16,"videoFileSize":"22.52MB","response_raw":"Execute query error, because: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='","response":null,"msg":"cURL error (1):\n Unsupported protocol \n \/var\/www\/clients\/client2\/web1\/web\/YouPHPTube-Encoder\/videos\/avideoTmpFile_25_streamers_id_1__720.mp4 \n (https:\/\/videos.[REMOVED].net\/aVideoEncoder.json)\n 4 "}
[28-May-2021 00:05:47 Europe/Berlin] PHP Notice:  Trying to get property 'video_id' of non-object in /var/www/clients/client2/web1/web/YouPHPTube-Encoder/objects/Encoder.php on line 1116
[28-May-2021 00:05:47 Europe/Berlin] Encoder::save id=(25) title=(\'The F Word\' Bloopers 🖕 Younger | TVLand)

I think the interesting part is this one: AVideo-Streamer answer 1 Execute query error, because: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

I'm running version avideo 10.7 encoder 3.8 on Ubuntu 20.03 with MariaDB.

Any suggestion how to fix this error?

akhilleusuggo commented 3 years ago

we're at version 11.1 , maybe you should update.