WWBN / AVideo

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

Various issues with the new cache #8519

Open para2022 opened 1 year ago

para2022 commented 1 year ago

Since the cache update there is still a few issues.

  1. Likes don’t work as you have to keep pressing it over and over again and it may or may not register. If I refresh the page then the like will register the next time I press it.
  2. Comments won’t work, there is just the loading spinner and goes on forever. Usually a page refresh and repeat the comment will work.
  3. Cache fails on mobile device as it loads a white messed up page, looks like a broken style sheet. If I refresh 3 times then the page loads correctly. Mainly affects Google chrome but I’ve seen it on safari also.

So there seems to be a refresh issue involved here as refreshing the page seems to get the functions to work. If I turn cache off everything returns to normal. And also if I turn off the bot function in cache settings, the cache doesn’t work and if it is on then the cache starts working. Also suggested videos do no change on homepage with cache on until cache next updates then the videos change.

para2022 commented 1 year ago

maybe exclude likes from being cached as it is a live function as well as comments. Also exclude suggested from being cached as they are random and should change on each refresh and the cache disables this function.

para2022 commented 1 year ago

actually the likes problem and comments issue is happening with the cache off as well. No errors in logs or dev tools.

DanielnetoDotCom commented 1 year ago

So in summary likes and comments are cached and only appear after clear the cache?

para2022 commented 1 year ago

Yes I believe so

DanielnetoDotCom commented 1 year ago

Can you please check if this update resolves it?

para2022 commented 1 year ago

Its exactly the same. I have cleared the cache also.

para2022 commented 1 year ago

Their is some weird issue with the number 3. If i click like 3 times then it registers on the third click. If i get a blank load screen on mobile devices and i refresh 3 times then it loads the page correctly on the 3rd try. If i go to my site on firefox the site only loads the page properly on the 3rd page load. Its as if the cache doesnt load until the page has loaded 3 times. So their defo is some issue with the number 3. Strange coincidence? Comments just loads the loading bars continuously, but if i refresh the page the comment is there. All this never used to happen obviously. Also the same is happening when i try to add a promotion, i get the loading bars and nothing happens. So im guessing this is affecting so many functions cos capcha is also not working so money transfer complains that the captcha is wrong when it is not.

DanielnetoDotCom commented 1 year ago

I'm uncertain about the issue you're experiencing, as everything seems functional from my end.

I've just sent over my most recent updates. Please try updating with these, and hopefully, that resolves the problem. If not, it might be beneficial to drop your 'CachesInDB' table and reinstall it. It's possible some indexes were missed.

If these solutions don't rectify the situation, I'm at a loss for further recommendations.

para2022 commented 1 year ago

I have done everything above and sadly it’s still the same. It is also the same on another site which is on another server.

DanielnetoDotCom commented 1 year ago

I only can fix it if I can reproduce it. sorry I could not reproduce it here.

try the demo site, and see if you can reproduce it there.

para2022 commented 1 year ago

Well i have no clue all i know is the site was working fine, this same bug is affecting my backup server/site in the exact same way. Just had this message:

hello mate not moaning but is bugs for likes on vids takes 3 attempts....and if you want place comment you have to click refresh otherwise gets stuck....and oppy was using duckduckgo as browser to use OT but has issues now...had few say about same issues

also:

Remember how you said to report anomalies? Dya think well have commenting back up by tmro? It just goes into a spin cycle if I try and then have to come out. Thing is if I drop one and then don't answer the comments they'll think I've abandoned them and I'll lose even more than I am doing. 🙄Likes are a bit dodgy to get to work da noo too btw. 😍

para2022 commented 1 year ago

I have done the following:

Restarted all services. Changed PHP version Deleted cache table and reinstalled it, but the problem is the same with the cache turned off. Checked all permissions Cleared out tmp dir Cleared out cache DIR Check apache config and php for errors No relevant errors in php log, apache log, mariadb log, avideo log Turned off all plugins to see if one was causing the problem Made sure no other caching systems are active Restored an old database to see if my DB was bugged

Nothing works

DanielnetoDotCom commented 1 year ago

Without logs or be able to reproduce I cannot help you

para2022 commented 1 year ago

exact same problem on demo site. Spinner on comments and 3 clicks before a like registers just as stated in the comment from a user i just posted

para2022 commented 1 year ago

Screenshot 2023-10-14 at 20 30 11

DanielnetoDotCom commented 1 year ago

Comments are fixed, and the likes are working for me. please test on demo site again

para2022 commented 1 year ago

Nope still spinning wheel of death on your demo site after making a comment, this time im using firefox. First screenshot is in Brave browser, so its not a browser issue either. The wheel spins forever. If i refresh the page the comment is there. Same thing happening on my sites. Developer tools show no clues.

DanielnetoDotCom commented 1 year ago

The browser does not matter

But I just tested and it works for me.

Are you trying with any specific user?

para2022 commented 1 year ago

i am using the test:test account on your demo site. I am admin on my own site but my users are also reporting the same issues to me.

para2022 commented 1 year ago

Screenshot 2023-10-14 at 21 33 36

Thats off your demo site after fix, its still doing it.

DanielnetoDotCom commented 1 year ago

The comment was working, but I found something that may be an issue for the likes

chrome-capture-2023-9-14

para2022 commented 1 year ago

you need to move through the site and make comments on lots of random videos to properly replicate this bug because if it works on a page it will keep working and you can make as many comments as you like but Moving on to other videos will replicate it eventually because if a page is refreshed manually the comments and likes will work.

para2022 commented 1 year ago

Good news as the likes are working now after the socket update. Im just testing comments now also. But thanks for the likes fix and the spinner on the likes is a nice touch now as it lets users know its doing something. :)

para2022 commented 1 year ago

Comments are working now also. Genius. Thanks for your hard work mate.