Hi,
In our WP admin, publishpress 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.
NOTE: This error still show after update the recent version 2.6.1. But not in old version 1.10. How to optimize query, we cant touch plugin files. Need your support.
Thank you.
The page I need help with: [log in to see the link]