Can I have permission to delete the unpublished video on your site?

The reason why I asking this is that once the system deletes video successfully, these unpublish videos no longer exist on your site.

Hello. Yes, you can try to delete Unpublish videos.
I hope it also will delete related stream items, comments, reactions and other Database lines.
Thanks.

Yes, it will delete the following related data from the database :

1. comment
2. reaction
3. author point
4. system notification
5. associated tag,
6. video file
7. indexed data from smart search

So I can see the error when I trying to delete 20 videos from the backend.

And I also noticed that when I hit this error "504 Gateway Time-out", the script actually still running behind, which means when you access the video listing page from the backend after you hit that error, you will realize that the video will delete one by one until it deleted 20 videos as what you selected just now.

I suspect you hit this error is most likely is because your server restricts the script can't proceed so long, perhaps you can consult with your Webhosting provider and see whether possible to increase this timeout limit to longer?

You can check this reference link : https://asdqwe.net/blog/solutions-504-gateway-timeout-nginx/

Hello. max_execution_time was changed from 120 to 360. Now there is no error when I try to delete 20 unpublished videos.
But it still takes lot of time (few minutes). Is it OK? Thanks.

It seems not normal and I found out one of the delete queries might cause this slow process, I will log into the issue tracker and see if we can optimize this.

Can I test to delete your site video which is under the unpublished state?

Hello. Yes, you can. Thanks.

Alright thanks, we need to apply the fix and test the delete performance issue.

Thks Arlex for helping your customers

Hey User,

We already applied the final fix to your site under this file JoomlaFolder/administrator/components/com_easysocial/models/stream.php .

1. Original code + delete 20 unpublished videos
Result: need to wait for 4 ~ 4.5 minutes

2. With the fixed code + delete 20 unpublished videos
Result: need to wait for 1.5 ~ 2 minutes

So far we only can be optimized because the system trying to clear each of the following records related to the single video item.

1. comment
2. reaction
3. author point
4. system notification
5. associated tag
6. video file
7. indexed data from smart search

=================================================================
Hey Ssnobben,

You're welcome.