Information not updated on video upgrade (Encoder)

[gbrn]

When a video is updated, in the encoder, the data inserted is not updated in the video that was replaced.

Regarding the time (duration) of the file, in this image you can see that the database keeps the information of the first file, and in the player the data of the new file is correct.

I did a new test since the last encoder update and the problem still persists:

[DanielnetoDotCom]

Please update encoder and streamer. It should be fixed already

[gbrn]

I will run new tests

[gbrn]

I tried again and the problem persists...

File Original:

Adding video information in Encoder:

And then the problem remains. Only the video is updated, all other information is not added (Title, Description). The duration of the new video is also not changed.

[gbrn]

Several errors in the log, I don't know if it has relevance:

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM videos WHERE filename = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":1006,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":3138,"function":"getVideoFromFileNameLight","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":2273,"function":"getSourceFile","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":167,"function":"updateDurationIfNeed","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM  plugins WHERE status='active' AND uuid = 'CDN73225-3807-4167-ba81-0509dd280e06' ;) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/plugin.php","line":414,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":550,"function":"getEnabled","class":"Plugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":316,"function":"isEnabled","class":"AVideoPlugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":3096,"function":"loadPluginIfEnabled","class":"AVideoPlugin","type":"::"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

...

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":100,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":421,"function":"writeSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":166,"function":"save","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM  plugins WHERE status='active' AND uuid = '26570956-dc62-46e3-ace9-86c6e8f9c81b' ;) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/plugin.php","line":414,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":550,"function":"getEnabled","class":"Plugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":316,"function":"isEnabled","class":"AVideoPlugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":83,"function":"loadPluginIfEnabled","class":"AVideoPlugin","type":"::"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM categories ORDER BY id ASC LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":321,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":349,"function":"getCategoryDefault","class":"Category","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":166,"function":"save","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM categories WHERE id = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":265,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":102,"function":"getCategory","class":"Category","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":97,"function":"load","class":"Category","type":"->"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":347,"function":"__construct","class":"Category","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM videos WHERE clean_title = 'reaproveitar-7'  AND id != 212  LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":2737,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":314,"function":"fixCleanTitle","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":166,"function":"save","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2013) Lost connection to MySQL server during query (SELECT * FROM videos WHERE filename = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:45:00 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":1006,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":4447,"function":"getVideoFromFileNameLight","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/functions.php","line":1974,"function":"clearCacheFromFilename","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":138,"function":"decideMoveUploadedToVideos"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

...
 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM videos WHERE filename = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":1006,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":3138,"function":"getVideoFromFileNameLight","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":2273,"function":"getSourceFile","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":167,"function":"updateDurationIfNeed","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM  plugins WHERE status='active' AND uuid = 'CDN73225-3807-4167-ba81-0509dd280e06' ;) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/plugin.php","line":414,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":550,"function":"getEnabled","class":"Plugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":316,"function":"isEnabled","class":"AVideoPlugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":3096,"function":"loadPluginIfEnabled","class":"AVideoPlugin","type":"::"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

...
 ************ ******** ****************** ***************** ****************** ******* ******* ****** ***** ****** *** **** **** ***************** * ******* ****** *** ***** * ************************** * ***************** ******** * *************************** ************* * *** ****** * **** *********** * *********************** ******** * ********** **** * ******** ******************* * *** ********* * *** ********* * *** ************** * ***** *********** * ** ******** * **  ******** * *** ******** * *** ******** * *** **** * **** ************ * **** ********* * **** ************* * **** ******* * *** *************** * ******************************************************************************* ******** * ***** ****************** * **** ***************************** * **** * ************** * ***  ********** * ******************************** ******** * ** * ******** * *** * ******************* * ***** * ******** * ****** **************** * ****  ***** ** * **** ******* * ** ************ ******************************* - password

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":100,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":421,"function":"writeSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":166,"function":"save","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM  plugins WHERE status='active' AND uuid = '26570956-dc62-46e3-ace9-86c6e8f9c81b' ;) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/plugin.php","line":414,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":550,"function":"getEnabled","class":"Plugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/plugin\/AVideoPlugin.php","line":316,"function":"isEnabled","class":"AVideoPlugin","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":83,"function":"loadPluginIfEnabled","class":"AVideoPlugin","type":"::"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM categories ORDER BY id ASC LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":321,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":349,"function":"getCategoryDefault","class":"Category","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":166,"function":"save","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM categories WHERE id = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":265,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":102,"function":"getCategory","class":"Category","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/category.php","line":97,"function":"load","class":"Category","type":"->"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":347,"function":"__construct","class":"Category","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM videos WHERE clean_title = 'reaproveitar-7'  AND id != 212  LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":2737,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":314,"function":"fixCleanTitle","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":166,"function":"save","class":"Video","type":"->"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2013) Lost connection to MySQL server during query (SELECT * FROM videos WHERE filename = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

 [16-Jun-2022 00:23:20 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/mysql_dal.php","line":231,"function":"log_error"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":1006,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/video.php","line":4447,"function":"getVideoFromFileNameLight","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/functions.php","line":1974,"function":"clearCacheFromFilename","class":"Video","type":"::"},{"file":"\/home\/storage\/e\/88\/c1\/guilhermeblanco\/public_html\/cnetv\/_beta30\/objects\/aVideoEncoder.json.php","line":138,"function":"decideMoveUploadedToVideos"}] SCRIPT_NAME: /objects/aVideoEncoder.json.php

[DanielnetoDotCom]

With this problem

MySQL server has gone away 
Lost connection to MySQL server during query

everything can happen.

I am not sure what type of server you have or what you are using, but this error does not happen here.

try this

https://github.com/WWBN/AVideo/wiki/Speed-up-your-page#mysqltuner-script

[gbrn]

@DanielnetoDotCom Due to the project being non-profit, I'm using a low cost server (Shared Server), whose storage and database are shared. This error has been happening for more than 1 year, it has always had this error, it has no direct relevance to the reported problem. It is probably due to other queries from other clients on the same server.

[DanielnetoDotCom]

I am pretty sure this is relevant.

[gbrn]

@DanielnetoDotCom I took a new test. The image capture is ok, the image is updated correctly.

Do you think this error is related to server response time?

[18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: updateFilesize: No need to update videos_id=213 filename=video_220601112439_v3cb6 filesize=0 0 bytes SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php

[18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: getUsageFromFilename: is Dir dirSize=0 0 bytes path/to/my/streamer/site/videos/video_220601112439_v3cb6/ SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: getDirSize: ERROR ON Command du -sb path/to/my/streamer/site/videos/video_220601112439_v3cb6/ SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: getDirSize: start path/to/my/streamer/site/videos/video_220601112439_v3cb6/ SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php

[18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: deleteVideoTags getVideoTags213 SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: Video:clearCache(213) SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: Video is done notified 213: REAPROVEITAR SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:01 America/Sao_Paulo] AVideoLog::DEBUG: updateFilesize: No need to update videos_id=213 filename=video_220601112439_v3cb6 filesize=0 0 bytes SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php

[18-Jun-2022 17:55:00 America/Sao_Paulo] AVideoLog::DEBUG: deleteVideoTags getVideoTags213 SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:00 America/Sao_Paulo] AVideoLog::DEBUG: Video:clearCache(213) SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:00 America/Sao_Paulo] AVideoLog::DEBUG: Video::save (REAPROVEITAR) Saved id = 213  SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:00 America/Sao_Paulo] AVideoLog::DEBUG: deleteVideoTags getVideoTags213 SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:00 America/Sao_Paulo] AVideoLog::DEBUG: Video:clearCache(213) SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php

[18-Jun-2022 17:55:00 America/Sao_Paulo] AVideoLog::DEBUG: deleteVideoTags getVideoTags213 SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:55:00 America/Sao_Paulo] AVideoLog::DEBUG: Video:clearCache(213) SCRIPT_NAME: /objects/aVideoEncoderNotifyIsDone.json.php
 [18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::DEBUG: aVideoEncoder.json: Success path/to/my/streamer/site/videos/video_220601112439_v3cb6/video_220601112439_v3cb6_HD.mp4  SCRIPT_NAME: /objects/aVideoEncoder.json.php
 [18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::DEBUG: aVideoEncoder.json: Files Received for video : REAPROVEITAR SCRIPT_NAME: /objects/aVideoEncoder.json.php
 [18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::DEBUG: Do not need update duration:  SCRIPT_NAME: /objects/aVideoEncoder.json.php
 [18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::DEBUG: Video::getSourceFile(video_220601112439_v3cb6, .mp4, 1) ERROR video not found (video_220601112439_v3cb6) SCRIPT_NAME: /objects/aVideoEncoder.json.php

[18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM videos WHERE filename = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

[18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM plugins WHERE status='active' AND uuid = '26570956-dc62-46e3-ace9-86c6e8f9c81b' ;) SCRIPT_NAME: /objects/aVideoEncoder.json.php

[18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2006) MySQL server has gone away (SELECT * FROM videos WHERE clean_title = 'reaproveitar-8' AND id != 213 LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

[18-Jun-2022 17:54:59 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (no mysqlnd) Prepare failed: (2013) Lost connection to MySQL server during query (SELECT * FROM videos WHERE filename = ? LIMIT 1) SCRIPT_NAME: /objects/aVideoEncoder.json.php

[gbrn]

@DanielnetoDotCom I verify that the duration is now correct and the description is correct. Only the long and short title are not being updated.

[DanielnetoDotCom]

If you mean when you swap videos. the titles and descriptions do not suppose to update.

the idea is to keep the original information.

[gbrn]

@DanielnetoDotCom I understand that the original idea is to keep the original information. But this is not very clear. I believe it would be better to have a selector to choose whether to change it or not.... Or that the information will only be changed if the fields are not blank.

[gbrn]

@DanielnetoDotCom I have verified that the titles and descriptions are not updated. But the images are undefined. 1- After requesting the video update through the encoder. Title and description are not updated, ok. 2- The portrait poster on the "Submission Form" has been removed, as well as the horizontal poster has also been removed and replaced.

I would like to know if the information (text and image) will be removed or kept?

[DanielnetoDotCom]

when you swap a video all files will be replaced.

video file and images, basically we change the whole folder, so all the uploaded images will be lost.

the original video metadata should remain (title, user groups, tags, etc).

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.