search

WWBN / AVideo

Create Your Own Broadcast Network With AVideo Platform Open-Source. OAVP OVP
https://avideo.tube/AVideo_OpenSource
Other
1.89k stars 970 forks source link

Lots of Errors Showing in Logfile, but cannot see any problems on site. Advise #9156

Closed kollossus55 closed 2 months ago

kollossus55 commented 2 months ago

Hi Just checking my logfile and the following error has come up:-

[24-Jun-2024 03:08:59 America/Los_Angeles] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /view/modeYoutube.php

[24-Jun-2024 03:08:59 America/Los_Angeles] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":322,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/objects\/Object.php","line":122,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AD_Server\/AD_Server.php","line":88,"function":"getAllActive","class":"ObjectYPT","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Plugin.abstract.php","line":202,"function":"getEmptyDataObject","class":"AD_Server","type":"->"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AD_Server\/AD_Server.php","line":233,"function":"getDataObject","class":"PluginAbstract","type":"->"}] SCRIPT_NAME: /view/modeYoutube.php

[24-Jun-2024 03:08:59 America/Los_Angeles] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (1054) (Unknown column 'suggested' in 'order clause') preparedStatement = "SELECT * FROM vast_campaigns WHERE status='a' ORDER BY suggested desc LIMIT 0, 10 " formats = "" values = [] refreshCache = false SCRIPT_NAME: /view/modeYoutube.php

[24-Jun-2024 03:08:59 America/Los_Angeles] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":310,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/objects\/Object.php","line":122,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AD_Server\/AD_Server.php","line":88,"function":"getAllActive","class":"ObjectYPT","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Plugin.abstract.php","line":202,"function":"getEmptyDataObject","class":"AD_Server","type":"->"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AD_Server\/AD_Server.php","line":233,"function":"getDataObject","class":"PluginAbstract","type":"->"}] SCRIPT_NAME: /view/modeYoutube.php

Also have 300 + errors.

Avideolog error Prepare failed. Please advise.

DanielnetoDotCom commented 2 months ago

can you please check if that update resolves it?

kollossus55 commented 2 months ago

just running updates now. There was a problem with the SQL key, but I think I fixed that. Update shortly..

kollossus55 commented 2 months ago

Done updates, still has 256 erros showing Avideolog error Prepare failed. Anything else I need to do ?

DanielnetoDotCom commented 2 months ago

Can you please share the new errors?

kollossus55 commented 2 months ago

[24-Jun-2024 15:54:08 Europe/London] PHP Fatal error: Uncaught RuntimeException: Failed to listen on "tcp://0.0.0.0:2053": Address already in use (EADDRINUSE) in path/to/my/streamer/site/vendor/react/socket/src/TcpServer.php:184

... [24-Jun-2024 15:54:05 Europe/London] PHP Fatal error: Uncaught RuntimeException: Failed to listen on "tcp://0.0.0.0:2053": Address already in use (EADDRINUSE) in path/to/my/streamer/site/vendor/react/socket/src/TcpServer.php:184

... [24-Jun-2024 15:54:05 Europe/London] PHP Fatal error: Uncaught RuntimeException: Failed to listen on "tcp://0.0.0.0:2053": Address already in use (EADDRINUSE) in path/to/my/streamer/site/vendor/react/socket/src/TcpServer.php:184

... [24-Jun-2024 15:56:33 Europe/Moscow] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /view/modeYoutube.php

[24-Jun-2024 15:56:33 Europe/Moscow] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":322,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/objects\/Object.php","line":122,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AD_Server\/AD_Server.php","line":88,"function":"getAllActive","class":"ObjectYPT","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Plugin.abstract.php","line":202,"function":"getEmptyDataObject","class":"AD_Server","type":"->"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AD_Server\/AD_Server.php","line":233,"function":"getDataObject","class":"PluginAbstract","type":"->"}] SCRIPT_NAME: /view/modeYoutube.php

I think this mught have repeated. Did update, Git pulls, rebooted...

DanielnetoDotCom commented 2 months ago

I need more logs regarding "VideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /view/modeYoutube.php"

kollossus55 commented 2 months ago

Ive got 80 errors now. Trying to see info in logfiles regarding modeYoutube.php

[25-Jun-2024 09:30:23 UTC] AVideoLog::DEBUG: Return value: 0 SCRIPT_NAME: /view/modeYoutube.php [25-Jun-2024 09:30:23 UTC] AVideoLog::DEBUG: Command output: [] SCRIPT_NAME: /view/modeYoutube.php [25-Jun-2024 09:30:23 UTC] AVideoLog::DEBUG: execAsync Linux: nohup sh -c "/usr/bin/php path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php 366 & echo \$!" > /dev/null 2>&1 & SCRIPT_NAME: /view/modeYoutube.php [25-Jun-2024 10:28:13 Europe/London] AVideoLog::DEBUG: transcribe subtitle: mp3 was a dummy file and we could not download it from false SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:28:13 Europe/London] AVideoLog::DEBUG: url_get_contents Cannot download SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:28:13 Europe/London] AVideoLog::DEBUG: transcribe subtitle: SRT will be created srtFile=path/to/my/streamer/site/videos//.srt mp3File=path/to/my/streamer/site/videos//.mp3 SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:28:13 Europe/London] AVideoLog::DEBUG: transcribe subtitle: mp3 does not exists mp3File=path/to/my/streamer/site/videos//.mp3, creatign it SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:28:13 Europe/London] AVideoLog::DEBUG: gotToLoginAndComeBackHere(We could not load the video, please login) 114.119.149.65 [{"file":"\/var\/www\/html\/AVideo\/objects\/functions.php","line":4391,"function":"gotToLoginAndComeBackHere","args":["We could not load the video, please login"]},{"file":"\/var\/www\/html\/AVideo\/view\/modeYoutube.php","line":291,"function":"forbiddenPage","args":["We could not load the video, please login"]}] SCRIPT_NAME: /view/modeYoutube.php [25-Jun-2024 09:28:13 UTC] AVideoLog::DEBUG: Return value: 0 SCRIPT_NAME: /view/modeYoutube.php [25-Jun-2024 09:28:13 UTC] AVideoLog::DEBUG: Command output: [] SCRIPT_NAME: /view/modeYoutube.php [25-Jun-2024 09:28:13 UTC] AVideoLog::DEBUG: execAsync Linux: nohup sh -c "/usr/bin/php path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php 186 & echo \$!" > /dev/null 2>&1 & SCRIPT_NAME: /view/modeYoutube.php [25-Jun-2024 10:16:31 Europe/London] AVideoLog::DEBUG: Plugin Not Found 2: page SCRIPT_NAME: /view/info.php [25-Jun-2024 10:16:31 Europe/London] AVideoLog::DEBUG: Plugin Not Found 2: install SCRIPT_NAME: /view/info.php [25-Jun-2024 10:16:31 Europe/London] AVideoLog::DEBUG: Plugin Not Found 2: Objects SCRIPT_NAME: /view/info.php [25-Jun-2024 10:15:27 Europe/London] AVideoLog::DEBUG: transcribe subtitle: done videos_id=366 path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.vtt SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:15:27 Europe/London] AVideoLog::DEBUG: transcribe subtitle: exec vosk-transcriber -i 'path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.mp3' -t srt -o 'path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.srt' > 'path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.srt.log' 2>&1 SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:15:27 Europe/London] AVideoLog::DEBUG: transcribe subtitle: SRT will be created srtFile=path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.srt mp3File=path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.mp3 SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 09:15:26 UTC] AVideoLog::DEBUG: Return value: 0 SCRIPT_NAME: /plugin/PlayerSkins/mediaSession.json.php [25-Jun-2024 09:15:26 UTC] AVideoLog::DEBUG: Command output: [] SCRIPT_NAME: /plugin/PlayerSkins/mediaSession.json.php [25-Jun-2024 09:15:26 UTC] AVideoLog::DEBUG: execAsync Linux: nohup sh -c "/usr/bin/php path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php 366 & echo \$!" > /dev/null 2>&1 & SCRIPT_NAME: /plugin/PlayerSkins/mediaSession.json.php [25-Jun-2024 10:15:25 Europe/London] AVideoLog::DEBUG: transcribe subtitle: done videos_id=366 path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.vtt SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:15:25 Europe/London] AVideoLog::DEBUG: transcribe subtitle: exec vosk-transcriber -i 'path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.mp3' -t srt -o 'path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.srt' > 'path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.srt.log' 2>&1 SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php [25-Jun-2024 10:15:25 Europe/London] AVideoLog::DEBUG: transcribe subtitle: SRT will be created srtFile=path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.srt mp3File=path/to/my/streamer/site/videos/video_230320142627_vaf29/video_230320142627_vaf29.mp3 SCRIPT_NAME: path/to/my/streamer/site/plugin/SubtitleSwitcher/transcribe.php

DanielnetoDotCom commented 2 months ago

I am not seeing any error on it.

kollossus55 commented 2 months ago

Ok..

Will monitor...

Sent from Outlook for Androidhttps://aka.ms/AAb9ysg

From: Daniel Neto @.> Sent: Tuesday, June 25, 2024 1:36:38 PM To: WWBN/AVideo @.> Cc: kollossus55 @.>; Author @.> Subject: Re: [WWBN/AVideo] Lots of Errors Showing in Logfile, but cannot see any problems on site. Advise (Issue #9156)

I am not seeing any error on it.

— Reply to this email directly, view it on GitHubhttps://github.com/WWBN/AVideo/issues/9156#issuecomment-2188820019, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AM24UONZWNBGDAD7VC7YRPTZJFP5NAVCNFSM6AAAAABJZVIH7GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOBYHAZDAMBRHE. You are receiving this because you authored the thread.Message ID: @.***>