Getting unexpected Under Maintenance message after reboot.

[gregk63]

Describe the question A clear and concise description of what is your question.

Screenshots Provide some screenshots to help us understand and explain your problem.

Below is a screen shot:

https://snipboard.io/29MhNk.jpg

[DanielnetoDotCom]

First make a git pull, your code is different than mine

[gregk63]

Hmm...not sure how to do that?

[DanielnetoDotCom]

https://github.com/WWBN/AVideo/wiki/How-to-Update-your-AVideo-Platform

[gregk63]

Thank you! I am able to sign-in after forcing an update.

Do I need to update the database? If so, I am not seeing the below as the instructions mention as to how to update the database.

AVideo menu -> Update version

[gregk63]

Is there a database update from the command line I can run?

I was able to sign-in but that is all. When I try doing anything else I get Under Maintenance page. Sorry, I shouldn't say sign-in as I am only get to the Home Page. It is displaying fine thought.

[DanielnetoDotCom]

I am not sure what you are facing , please provide some logs and screenshots

[gregk63]

Here is a screen shot of what I am calling the Home page. This was not showing up before I did the git pull.

https://snipboard.io/ENvn2w.jpg

This is what happens when I click on Login

https://snipboard.io/yo9LMG.jpg

[DanielnetoDotCom]

Go to the plugins page and install and enable the videotags plugin

[gregk63]

I am unable to sign-in. When I click on Login I get the below response.

https://snipboard.io/yo9LMG.jpg

[DanielnetoDotCom]

Make a git pull

I sent a fix for that yesterday

[gregk63]

Ok. Thank you! I missed that!

I ran all the update scripts and everything seems to be functioning but all the videos statuses are Broken links. The videos are still there and I don't think I change the location manually. Did the location of the videos change with the upgrade? See screen shot

https://snipboard.io/OStfnH.jpg

[DanielnetoDotCom]

It did not change, you may need to check it closer.

[gregk63]

They are currently stored in /var/www/html/AVideo/videos. Is that correct? If so, what could be causing the Broken Missing Files?

[DanielnetoDotCom]

not sure, check if the file really exists inside the videos folder.

if does not exist check the logs at the time you encode the files and they are transferred.

[gregk63]

The videos directory contains a lot of files with similar names like below. How do I determine the video this file belongs to?

_YPTuniqid_641383598d0b42.29335848_480.mp4

[gregk63]

I re-read one of your prior responses. Do the videos have to encoded again after the upgrade?

[DanielnetoDotCom]

First you will need to check the Filename of a video in the database, then you will know what folder you should check

But usually broken missing files is a problem in the encode process

[gregk63]

Don't I need the database info like database name, user-id/password?

[gregk63]

I now have access to the database. What table holds the filenames?

[gregk63]

Sorry, just found the logs in the Admin panel. Here are some.

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":288,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":42,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":26,"function":"getFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Scheduler.php","line":178,"function":"isActiveFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/objects\/video.php","line":794,"function":"isActiveFromVideosId","class":"Scheduler","type":"::"}] SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (1146) (Table 'myMySQLDatabase.scheduler_commands' doesn't exist) preparedStatement = "SELECT * FROM scheduler_commands WHERE videos_id = ? LIMIT 1" formats = "i" values = [284] refreshCache = false SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":280,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":42,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":26,"function":"getFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Scheduler.php","line":178,"function":"isActiveFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/objects\/video.php","line":794,"function":"isActiveFromVideosId","class":"Scheduler","type":"::"}] SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[DanielnetoDotCom]

Update all your plugins

https://github.com/WWBN/AVideo/wiki/How-to-Update-your-AVideo-Platform#3-update-plugins

[gregk63]

Ok. I ensured they were all updated but, I am still seeing Broken Missing Files and yesterday when I use the encoder to add a video it seems to upload .mp4 file but the encoding process never starts.

See https://snipboard.io/I0JgU8.jpg

[DanielnetoDotCom]

check you encoder and streamer log files

[gregk63]

Here are the most recent log entries. I think they are the same ones I sent before. I was reading other issues and one mentioned something about time zone. I don't know why the log messages are saying Africa/Abidjan as I am in the Central/Mexico time zone. Could that be the problem? If so, I do I change it to Central/Mexico?

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":288,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":42,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":26,"function":"getFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Scheduler.php","line":178,"function":"isActiveFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/objects\/video.php","line":794,"function":"isActiveFromVideosId","class":"Scheduler","type":"::"}] SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (1146) (Table 'myMySQLDatabase.scheduler_commands' doesn't exist) preparedStatement = "SELECT * FROM scheduler_commands WHERE videos_id = ? LIMIT 1" formats = "i" values = [284] refreshCache = false SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[29-Apr-2023 17:10:51 Africa/Abidjan] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":280,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":42,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Objects\/Scheduler_commands.php","line":26,"function":"getFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/Scheduler\/Scheduler.php","line":178,"function":"isActiveFromVideosId","class":"Scheduler_commands","type":"::"},{"file":"\/var\/www\/html\/AVideo\/objects\/video.php","line":794,"function":"isActiveFromVideosId","class":"Scheduler","type":"::"}] SCRIPT_NAME: /AVideo/objects/myMySQLDatabaseEncoder.json.php

[DanielnetoDotCom]

due to this error I can see your plugins still not updated

(Table 'myMySQLDatabase.scheduler_commands' doesn't exist)

[gregk63]

When I click on Edit on the Scheduler plugin it appears there is not commands. Is this suppose to be the case. I did add the suggested crontab -e command. Is this enough?

Here is what appears to be the empty command screen.

https://snipboard.io/UgY8jM.jpg

[DanielnetoDotCom]

If you install the tables properly you should not see this error anymore

(Table 'myMySQLDatabase.scheduler_commands' doesn't exist)

[gregk63]

The install of the plugin does this, correct? Is there a way to re-install the plugin?

[gregk63]

Ok. I think I have everything working again that I need/use. I can re-create the videos with the Broken Missing Files message but I really do not want to do that as there are a couple hundred videos. Is that the only way around this? It seems to me a pointer of some sort is off?

[DanielnetoDotCom]

The video is typically considered lost due to broken or missing files. However, in rare cases, it may be possible to recover the video

[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.

[gregk63]

I ended up re-creating all or most of the videos. A long process. Is there something I should be doing to prevent this from happening again? I am still confused as to what caused it?