قائمة المترجمين فارغة في WPML 4.6.5 على التثبيتات متعددة المواقع

الحالة

محلولة

أُبلغ عنها لـ

WPML Multilingual CMS 4.6.5

تم حلها في

4.6.6

وسوم الموضوع

Bug

نظرة عامة على المشكلة

بعد التحديث إلى WPML 4.6.5 على تثبيتات WordPress متعدد المواقع، ستلاحظ أن قائمة المترجمين، التي يجب أن تكون متاحة ضمن WPML > إدارة الترجمة > المترجمون، فارغة.

حل بديل مؤقت

يُرجى التأكد من أخذ نسخة احتياطية كاملة لموقعك قبل المتابعة.

• افتح الملف …/wp-content/plugins/sitepress-multilingual-cms/classes/user/class-wpml-translation-roles-records.php.


• ابحث عن السطر 116.


• استبدل الطريقة: /WPML_Translation_Roles_Records::get_records:

  	private function get_records( $compare, $search = '', $limit = -1 ) {
  		$search = trim( $search );
  
  		$cache_key = md5( (string) wp_json_encode( [ get_class( $this ), $compare, $search, $limit ] ) );
  		$cache     = wpml_get_cache( self::CACHE_GROUP );
  		$found     = false;
  		$results   = $cache->get( $cache_key, $found );
  		if ( $found ) {
  			return $results;
  		}
  
  		$preparedUserQuery = $this->wpdb->prepare(
  			"SELECT u.id FROM {$this->wpdb->prefix}users u INNER JOIN {$this->wpdb->prefix}usermeta c ON c.user_id=u.ID AND CAST(c.meta_key AS BINARY)=%s AND c.meta_value {$compare} %s",
  			"{$this->wpdb->prefix}capabilities",
  			"%" . $this->get_capability() . "%"
  		);
  
  		if ( self::USERS_WITHOUT_CAPABILITY === $compare ) {
  			$required_wp_roles = $this->get_required_wp_roles();
  			foreach( $required_wp_roles as $required_wp_role ) {
  				$preparedUserQuery .= $this->wpdb->prepare( " AND c.meta_value LIKE %s", "%{$required_wp_role}%" );
  			}
  		}
  
  		if ( $search ) {
  			$preparedUserQuery .= $this->wpdb->prepare( " AND (u.user_login LIKE %s OR u.user_nicename LIKE %s OR u.user_email LIKE %s)", "%{$search}%", "%{$search}%", "%{$search}%" );
  		}
  
  		$preparedUserQuery .= ' ORDER BY user_login ASC';
  
  		if ( $limit > 0 ) {
  			$preparedUserQuery .= $this->wpdb->prepare(" LIMIT 0,%d", $limit );
  		}
  
  		$users      = $this->wpdb->get_col( $preparedUserQuery );
  
  		if ( $search && strlen( $search ) > self::MIN_SEARCH_LENGTH && ( $limit <= 0 || count( $users ) < $limit ) ) {
  			$users_from_metas = $this->get_records_from_users_metas( $compare, $search, $limit );
  			$users_with_dupes = array_merge( $users, $users_from_metas );
  			$users            = wpml_array_unique( $users_with_dupes, SORT_REGULAR );
  		}
  
  		$results = array();
  		foreach ( $users as $user_id ) {
  			$user_data = get_userdata( $user_id );
  			if ( $user_data ) {
  				$language_pair_records = new WPML_Language_Pair_Records( $this->wpdb, new WPML_Language_Records( $this->wpdb ) );
  				$language_pairs        = $language_pair_records->get( $user_id );
  
  				$result    = (object) array(
  					'ID'             => $user_data->ID,
  					'full_name'      => trim( $user_data->first_name . ' ' . $user_data->last_name ),
  					'user_login'     => $user_data->user_login,
  					'user_email'     => $user_data->user_email,
  					'display_name'   => $user_data->display_name,
  					'language_pairs' => $language_pairs,
  					'roles'          => $user_data->roles
  				);
  				$results[] = $result;
  			}
  		}
  
  		$cache->set( $cache_key, $results );
  
  		return $results;
  	}



• بـ:

  	private function get_records( $compare, $search = '', $limit = -1 ) {
  		$search = trim( $search );
  
  		$cache_key = md5( (string) wp_json_encode( [ get_class( $this ), $compare, $search, $limit ] ) );
  		$cache     = wpml_get_cache( self::CACHE_GROUP );
  		$found     = false;
  		$results   = $cache->get( $cache_key, $found );
  		if ( $found ) {
  			return $results;
  		}
  
  		$query_args = array(
  			'fields'     => 'ID',
  			'meta_query' => array(
  				array(
  					'key'     => "{$this->wpdb->prefix}capabilities",
  					'value'   => $this->get_capability(),
  					'compare' => $compare,
  				),
  			),
  			'number'     => $limit,
  		);
  
  		if ( 'NOT LIKE' === $compare ) {
  			$required_wp_roles = $this->get_required_wp_roles();
  			if ( $required_wp_roles ) {
  				$query_args['role__in'] = $required_wp_roles;
  			}
  		}
  
  		if ( $search ) {
  			$query_args['search']         = '*' . $search . '*';
  			$query_args['search_columns'] = array( 'user_login', 'user_nicename', 'user_email' );
  		}
  
  		$user_query = $this->user_query_factory->create( $query_args );
  		$users      = $user_query->get_results();
  
  		if ( $search && strlen( $search ) > self::MIN_SEARCH_LENGTH && ( $limit <= 0 || count( $users ) < $limit ) ) {
  			$users_from_metas = $this->get_records_from_users_metas( $compare, $search, $limit );
  			$users_with_dupes = array_merge( $users, $users_from_metas );
  			$users            = wpml_array_unique( $users_with_dupes, SORT_REGULAR );
  		}
  
  		$results = array();
  		foreach ( $users as $user_id ) {
  			$user_data = get_userdata( $user_id );
  			if ( $user_data ) {
  				$language_pair_records = new WPML_Language_Pair_Records( $this->wpdb, new WPML_Language_Records( $this->wpdb ) );
  				$language_pairs        = $language_pair_records->get( $user_id );
  
  				$result    = (object) array(
  					'ID'             => $user_data->ID,
  					'full_name'      => trim( $user_data->first_name . ' ' . $user_data->last_name ),
  					'user_login'     => $user_data->user_login,
  					'user_email'     => $user_data->user_email,
  					'display_name'   => $user_data->display_name,
  					'language_pairs' => $language_pairs,
  					'roles'          => $user_data->roles
  				);
  				$results[] = $result;
  			}
  		}
  
  		$cache->set( $cache_key, $results );
  
  		return $results;
  	}

جميع المشاكل المعروفة →