Question 504 time out when "Purge items" (Trash Manager)

Hi,

Let's check my issue,

Thanks,

click on all fix, or delete.


Then try again

I did click and delete all issues, but it's not fixed,

I tried test cleaning up users, then I'm possible delete about 30 topics it's ok,

But if at the same time i delete bigger 40 topics I still have old issue,

I was wondering if maybe the cause is big data or another?

Thanks,

While delete topics,

I check slow logs mysql:

# Time: 150409 17:03:18
# User@Host: root[root] @ localhost []
# Query_time: 10.560684 Lock_time: 0.000164 Rows_sent: 0 Rows_examined: 131640422
SET timestamp=1428573798;
UPDATE u3gbc_kunena_users AS u
LEFT JOIN (
SELECT userid, MAX(expiration) AS banned FROM u3gbc_kunena_users_banned GROUP BY userid
) AS b ON u.userid=b.userid
SET u.banned=b.banned;

I dont know why Query_time large?

monosnap.com/image/q4IxVC1izPtUqTfGODCl4fFA1QCEli

Please review it,

Thanks,

On your image if you look the rows examined value, you will see that it's bigger for the query which take more time

So what do I have to do to optimize it?

I carried out optimize mysql but it's not fixed,

do you have any idea?

Thanks,

I will look how to optimize that slow query

Yeah, I'm looking forward,

so with my issue, I need have to what to do to fix now, my forum is not working,

I'm going to wait you present next version, aren't I?

Thanks,

I hope to have found a fix for it for the next Kunena version, the query which is too slow is located here : github.com/Kunena/Kunena-Forum/blob/mast...user/helper.php#L332

Yeah, I did comment $query = "UPDATE in file helper, my forum is ok now,

Hoping it's not affect to anything, I will monitor it and inform for you,

Thankyou for your helping,