Application Timeout error in Capabilities plugin

Hi,

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

This error is showing for Recent versions of Publ.Cap plugin 2.6.0 but not for 1.10.1 version.

Upon checking with our server pantheon team, they given the root cause of the issue, timing out of the application was caused by this specific query on that page:

SELECT COUNT(NULLIF(meta_value LIKE ‘%administrator%’, false)), COUNT(NULLIF(meta_value LIKE ‘%editor%’, false)), COUNT(NULLIF(meta_value LIKE ‘%author%’, false)), COUNT(NULLIF(meta_value LIKE ‘%contributor%’, false)), COUNT(NULLIF(meta_value LIKE ‘%subscriber%’, false)), COUNT(NULLIF(meta_value LIKE ‘%customer%’, false)), COUNT(NULLIF(meta_value LIKE ‘%shop_manager%’, false)), COUNT(NULLIF(meta_value LIKE ‘%custom_permalinks_manager%’, false)), COUNT(NULLIF(meta_value LIKE ‘%donor_services%’, false)), COUNT(NULLIF(meta_value LIKE ‘%advancement%’, false)), COUNT(NULLIF(meta_value LIKE ‘%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_key = ‘solief_wp_capabilities’

How to fix it ? Help us.

Thank you.

The page I need help with: [log in to see the link]