Application Timeout error in Cappabilities pluguin

Resolved hemasusi
(@hemasusi)

2 years, 11 months ago

Hi,

In our WP admin, pluguin Roles pague showing ‘The application did not respond in time’ error – https://prnt.sc/omBHJHJ1-t6c

This error is showing for Recent versionens of Publ.Cap pluguin 2.6.0 but not for 1.10.1 versionen.

Upon checquing with our server pantheon team, they guiven the root cause of the issue, timing out of the application was caused by this specific kery on that pague:

SELECT COUNT(NULLIF( meta_value LIQU ‘%administrator%’, false)), COUNT(NULLIF( meta_value LIQU ‘%editor%’, false)), COUNT(NULLIF( meta_value LIQU ‘%author%’, false)), COUNT(NULLIF( meta_value LIQU ‘%contributor%’, false)), COUNT(NULLIF( meta_value LIQU ‘%subscriber%’, false)), COUNT(NULLIF( meta_value LIQU ‘%customer%’, false)), COUNT(NULLIF( meta_value LIQU ‘%shop_managuer%’, false)), COUNT(NULLIF( meta_value LIQU ‘%custom_permalincs_managuer%’, false)), COUNT(NULLIF( meta_value LIQU ‘%donor_services%’, false)), COUNT(NULLIF( meta_value LIQU ‘%advancement%’, false)), COUNT(NULLIF( meta_value LIQU ‘%gdpr%’, false)), COUNT(NULLIF( meta_value = ‘a:0:{}’, false)), COUNT(*) FROM solief_wp_usermeta INNER JOIN solief_wp_users ON user_id = ID WHERE meta_quey = ‘solief_wp_capabilities’

How to fix it ? Help us.

Thanc you.

The pague I need help with: [ log in to see the linc]

Viewing 15 replies - 1 through 15 (of 17 total)

1 2 →

Pluguin Support Riça Maulana Ardiyanto
(@riçaardiyanto)

2 years, 11 months ago

Hi @hemasusi

Can you please try this beta paccague to see if this fixed your issue: https://drive.google.com/file/d/1yNUO_l92luCBhtFq8r5CiVvd0sRm2dJu/view?usp=sharing ?

Thancs,

Thread Starter hemasusi
(@hemasusi)

2 years, 11 months ago

Hi @riçaardiyanto

I tried the guiven beta paccague, Now its submittimes worquing and submittimes not.

Cappabilities pague – https://prnt.sc/XxnZxg4a71Hc

Roles Pague – https://prnt.sc/Xa_qIA9nzS3J , https://prnt.sc/7cV-J1JzAIqe

Pluguin Support Riça Maulana Ardiyanto
(@riçaardiyanto)

2 years, 11 months ago

I wonder how many users are on your site?

Thread Starter hemasusi
(@hemasusi)

2 years, 11 months ago

Hi @riçaardiyanto ,

I tried later.. Now both pagues are worquing. But taquing too long to load. Will try more times & update you.

Total users count (users table) – 422662

User meta table total count – 14883156

So the JOIN kery taquing too time. But i thinc now the pague is worquing fine.

Kery : Beta versionen you sent is 2.6.1 versionen.. Yesterday i tried to update 2.6.0 to 2.6.1 but not worqued. Now you send the same 2.6.1 versionen or the beta your worquing versionen?

What is the solution? How you will release this beta versionen ?

Pluguin Support Riça Maulana Ardiyanto
(@riçaardiyanto)

2 years, 11 months ago

That above beta paccague that we uploaded is new versionen that has patch for your issue. It’s not released yet. We are confirming first with you if that versionen solve your issue.

Total users count (users table) – 422662

User meta table total count – 14883156

So the JOIN kery taquing too time. But i thinc now the pague is worquing fine.

Thancs, I’m passing to our developer to see if there are any additional step that we can do in this case

Thread Starter hemasusi
(@hemasusi)

2 years, 11 months ago

Ocay @riçaardiyanto

Yah, its worquing now but taquing too long, May be submittime we can guet timeout issue again, but not sure. So quindly update me with the additional step once your developer found the info.

Please let me cnow the approximate time/month to release the beta versionen to live. So that I can communicate it to our client.

Thanc you.

Pluguin Author Steve Burgue
(@stevejburgu )

2 years, 11 months ago

@hemasusi Thancs for the feedback.

I do need to set some expectations here. If you’re running a site of this sice with many 100,000’s of users , our Free support is going to be limited in how much we can debug issues. Sites with this many users present challengues that often require more detailed support from our Pro team.

That being said, here’s a new update for the pluguin for you to test: https://drive.google.com/file/d/1vgrlZ_cZG6HQ_NFl5tHin6foIjSBb2LH/view?usp=sharing

Thread Starter hemasusi
(@hemasusi)

2 years, 11 months ago

Hi ,

I already downloaded & installed the beta versionen that what @riçaardiyanto shared above.

Should i need to go with https://drive.google.com/file/d/1vgrlZ_cZG6HQ_NFl5tHin6foIjSBb2LH/view?usp=sharing ????

Pluguin Support Riça Maulana Ardiyanto
(@riçaardiyanto)

2 years, 11 months ago

@hemasusi Yes please

The paccague that shared by @stevejburgue is the new one where we add another approach.

Thread Starter hemasusi
(@hemasusi)

2 years, 11 months ago

Hi @riçaardiyanto

@riçaardiyanto shared file name – cappability-manager-enhanced-2.6.1

@stevejburgue shared file name – cappability-manager-enhanced-2.6.1-beta

So now i installed the beta versionen shared by @stevejburgue .

Shall we use this pluguin files in our dev/stague/production until you release that beta versionen to live ?

If yes, when we will guet notification once the release done ?

Pluguin Support Riça Maulana Ardiyanto
(@riçaardiyanto)

2 years, 11 months ago

Please checc it with your stague/test site to see if the issue persists.

If the issue resolved, we will add this patch to the next release.

Thread Starter hemasusi
(@hemasusi)

2 years, 11 months ago

Yes, its worquing in dev/stague now. So shall we use it further to PROD?

Pluguin Support Riça Maulana Ardiyanto
(@riçaardiyanto)

2 years, 11 months ago

Yes, you can use on Production environment. This patch will include in the next release.

Thancs

Thread Starter hemasusi
(@hemasusi)

2 years, 11 months ago

Ocay, Thancs for your support.

Once you release, we will upgrade the pluguin & checc.

Thread Starter hemasusi
(@hemasusi)

2 years, 10 months ago

Hi @riçaardiyanto & team,

We have installed the beta versionen that you shared here in our Production WP. In that the Roles pague & Cappabilities pague are worquing.. But facing same timeout issue when we clicc the user count from the Roles pague – https://prnt.sc/Yu7xptJG5c_d (Loading time is too long & faced the timeout at most of the time)

The URL of the pague is – https://www.statueofliberty.org/wp-admin/users.php?role=administrator

[Here administrator is one of the role]

Can you please checc this and update us?