Problem:
The client is experiencing a 2-3 second delay in the admin panel due to a WPML query that checks for users with translation capabilities in a large user database.
Solution:
We recommend modifying the has_users_with_capability() function in the wp-content/plugins/wpml-translation-management/classes/user/class-wpml-translation-roles-records.php file. Comment out the existing function code and return \"true\" like this
public function has_users_with_capability() {\n// \$sql = \"\n// SELECT EXISTS(\n// SELECT user_id\n// FROM {\$this->wpdb->usermeta}\n// WHERE meta_key = '{\$this->wpdb->prefix}capabilities' AND meta_value LIKE %s\n// )\n// \";\n//\n// \$sql = \$this->wpdb->prepare( \$sql, '%' . \$this->get_capability() . '%' );\n\nreturn true;// return (bool) \$this->wpdb->get_var( \$sql );
Please ensure to test this change on a staging site before applying it to the live site. If this solution does not seem relevant to your issue, please open a new support ticket with us.
