Avideo: Cannot add autoplay next video after update to latest version

[guitarpound]

Describe the bug
I can't add autoplay next video after update AVideo to the latest version.

To Reproduce
Steps to reproduce the behavior:

1. cd /var/www/html/YouPHPTube/
2. sudo git fetch --all && sudo git reset --hard origin/master
3. go to update menu and continue update to version 9.4
4. open browser & try to put some video name in the autoplay next video text box. But no any data popup.

I tried testing on the AVideo demo site. It's the same problem.

Screenshots

Desktop (please complete the following information):

• OS: Mac OS 10.12.6
• Browser : Chrome
• Version : 84.0.4147.135

Additional context
I found the problem happen after use this command-> sudo git fetch --all && sudo git reset --hard origin/master
Even not goto click update button in the update menu.

[akhilleusuggo]

I confirm ( I've tested it on clear installation )
Too many bugs on the latest version , from 9.2 to 9.4 , that's why , I'm not updating anymore .

[DanielnetoDotCom]

You are right, I am sending a fix for it

[akhilleusuggo]

@DanielnetoDotCom I don't know what you've done , but this update is killing the database .

filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............
filesize(): stat failed for /var/www/html/..............

Is looping basically . Like 10k lines per second . Everytime when checking my videos's section .
Not only that , this does not fix the issue .

[DanielnetoDotCom]

Sorry, do you know what exactly script is doing that?

[akhilleusuggo]

[22-Aug-2020 12:17:30 UTC] PHP Warning: filesize(): stat failed for /var/www/html/AVideo/videos/ID/blabla.mp4 in /var/www/html/AVideo/objects/video.php on line 2592

[akhilleusuggo]

I wanna give a feedback . Maybe this occur only the first time , trying to fetch all the videos , and then wont do it anymore . I'll give it a try .

[DanielnetoDotCom]

I see

but there is a specific page you access to this happen?
or just right after the update?

[DanielnetoDotCom]

Please keep the eye open and let me know

[akhilleusuggo]

on MY VIDEOS ( where you can edit your videos )
BTW , 127MB of log files created during this update .

[akhilleusuggo]

Ok , it's not exactly on MY VIDEOS , but when trying to search for the video you wanna add for ''autoplay next video''

AVideoLog::DEBUG: Warning: Slow process detected [[SELECT u.*, v.*, c.iconClass, c.name as category, c.clean_name as clean_category,c.description as category_description, v.created as videoCreation, v.modified as videoModified, (SELECT count(id) FROM likes as l where l.videos_id = v.id ANDlike= 1 ) as likes, (SELECT count(id) FROM likes as l where l.videos_id = v.id ANDlike= -1 ) as dislikes FROM videos as v LEFT JOIN categories c ON categories_id = c.id LEFT JOIN users u ON v.users_id = u.id WHERE 1=1 AND u.status = 'a' LIMIT 0, 25000 ], , [], ] On Line mysql_dal takes 3.842 seconds to complete. /var/www/html/AVideo/objects/videos.json.php SCRIPT_NAME: /objects/videos.json.php

[DanielnetoDotCom]

Try this

[akhilleusuggo]

Looks like fixed !
That was a dangerous stuff , literally the server was crashing at the speed of light . Never seen the swap getting that much used . 400mb of logs in 2mn xD

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