diff --git a/core/modules/comment/src/Plugin/views/argument/UserUid.php b/core/modules/comment/src/Plugin/views/argument/UserUid.php index 6e15d66..5e104bd 100644 --- a/core/modules/comment/src/Plugin/views/argument/UserUid.php +++ b/core/modules/comment/src/Plugin/views/argument/UserUid.php @@ -59,7 +59,7 @@ function title() { $title = \Drupal::config('user.settings')->get('anonymous'); } else { - $title = $this->database->query('SELECT u.name FROM {users} u WHERE u.uid = :uid', array(':uid' => $this->argument))->fetchField(); + $title = $this->database->query('SELECT name FROM {users_field_data} WHERE uid = :uid AND default_langcode = 1', array(':uid' => $this->argument))->fetchField(); } if (empty($title)) { return t('No user'); diff --git a/core/modules/node/src/Plugin/Action/AssignOwnerNode.php b/core/modules/node/src/Plugin/Action/AssignOwnerNode.php index b2ead47..598410f 100644 --- a/core/modules/node/src/Plugin/Action/AssignOwnerNode.php +++ b/core/modules/node/src/Plugin/Action/AssignOwnerNode.php @@ -83,13 +83,13 @@ public function buildConfigurationForm(array $form, FormStateInterface $form_sta $count = $this->connection->query("SELECT COUNT(*) FROM {users}")->fetchField(); $owner_name = ''; if (is_numeric($this->configuration['owner_uid'])) { - $owner_name = $this->connection->query("SELECT name FROM {users} WHERE uid = :uid", array(':uid' => $this->configuration['owner_uid']))->fetchField(); + $owner_name = $this->connection->query("SELECT name FROM {users_field_data} WHERE uid = :uid AND default_langcode = 1", array(':uid' => $this->configuration['owner_uid']))->fetchField(); } // Use dropdown for fewer than 200 users; textbox for more than that. if (intval($count) < 200) { $options = array(); - $result = $this->connection->query("SELECT uid, name FROM {users} WHERE uid > 0 ORDER BY name"); + $result = $this->connection->query("SELECT uid, name FROM {users_field_data} WHERE uid > 0 AND default_langcode = 1 ORDER BY name"); foreach ($result as $data) { $options[$data->name] = $data->name; } @@ -119,7 +119,7 @@ public function buildConfigurationForm(array $form, FormStateInterface $form_sta * {@inheritdoc} */ public function validateConfigurationForm(array &$form, FormStateInterface $form_state) { - $exists = (bool) $this->connection->queryRange('SELECT 1 FROM {users} WHERE name = :name', 0, 1, array(':name' => $form_state['values']['owner_name']))->fetchField(); + $exists = (bool) $this->connection->queryRange('SELECT 1 FROM {users_field_data} WHERE name = :name AND default_langcode = 1', 0, 1, array(':name' => $form_state['values']['owner_name']))->fetchField(); if (!$exists) { form_set_error('owner_name', $form_state, t('Enter a valid username.')); } @@ -129,7 +129,7 @@ public function validateConfigurationForm(array &$form, FormStateInterface $form * {@inheritdoc} */ public function submitConfigurationForm(array &$form, FormStateInterface $form_state) { - $this->configuration['owner_uid'] = $this->connection->query('SELECT uid from {users} WHERE name = :name', array(':name' => $form_state['values']['owner_name']))->fetchField(); + $this->configuration['owner_uid'] = $this->connection->query('SELECT uid from {users_field_data} WHERE name = :name AND default_langcode = 1', array(':name' => $form_state['values']['owner_name']))->fetchField(); } } diff --git a/core/modules/simpletest/src/WebTestBase.php b/core/modules/simpletest/src/WebTestBase.php index e0b6858..89ff9db 100644 --- a/core/modules/simpletest/src/WebTestBase.php +++ b/core/modules/simpletest/src/WebTestBase.php @@ -722,7 +722,7 @@ protected function drupalUserIsLoggedIn($account) { } // The session ID is hashed before being stored in the database. // @see \Drupal\Core\Session\SessionHandler::read() - return (bool) db_query("SELECT sid FROM {users} u INNER JOIN {sessions} s ON u.uid = s.uid WHERE s.sid = :sid", array(':sid' => Crypt::hashBase64($account->session_id)))->fetchField(); + return (bool) db_query("SELECT sid FROM {users_field_data} u INNER JOIN {sessions} s ON u.uid = s.uid AND u.default_langcode = 1 WHERE s.sid = :sid", array(':sid' => Crypt::hashBase64($account->session_id)))->fetchField(); } /** diff --git a/core/modules/user/config/install/views.view.who_s_new.yml b/core/modules/user/config/install/views.view.who_s_new.yml index 0abe6e5..f04489f 100644 --- a/core/modules/user/config/install/views.view.who_s_new.yml +++ b/core/modules/user/config/install/views.view.who_s_new.yml @@ -54,7 +54,7 @@ display: fields: name: id: name - table: users + table: users_field_data field: name label: '' plugin_id: user_name @@ -90,7 +90,7 @@ display: filters: status: value: true - table: users + table: users_field_data field: status id: status expose: @@ -99,7 +99,7 @@ display: plugin_id: boolean access: id: access - table: users + table: users_field_data field: access relationship: none group_type: group @@ -140,7 +140,7 @@ display: sorts: created: id: created - table: users + table: users_field_data field: created relationship: none group_type: group diff --git a/core/modules/user/config/install/views.view.who_s_online.yml b/core/modules/user/config/install/views.view.who_s_online.yml index 6040d38..748538f 100644 --- a/core/modules/user/config/install/views.view.who_s_online.yml +++ b/core/modules/user/config/install/views.view.who_s_online.yml @@ -61,7 +61,7 @@ display: fields: name: id: name - table: users + table: users_field_data field: name label: '' plugin_id: user_name @@ -97,7 +97,7 @@ display: filters: status: value: true - table: users + table: users_field_data field: status id: status expose: @@ -106,7 +106,7 @@ display: plugin_id: boolean access: id: access - table: users + table: users_field_data field: access relationship: none group_type: group @@ -149,7 +149,7 @@ display: sorts: access: id: access - table: users + table: users_field_data field: access order: DESC relationship: none diff --git a/core/modules/user/src/Tests/UserBlocksTest.php b/core/modules/user/src/Tests/UserBlocksTest.php index c0f4a3a..a4e19d8 100644 --- a/core/modules/user/src/Tests/UserBlocksTest.php +++ b/core/modules/user/src/Tests/UserBlocksTest.php @@ -105,7 +105,7 @@ function testWhosOnlineBlock() { * Updates the access column for a user. */ private function updateAccess($uid, $access = REQUEST_TIME) { - db_update('users') + db_update('users_field_data') ->condition('uid', $uid) ->fields(array('access' => $access)) ->execute(); diff --git a/core/modules/user/src/Tests/UserCancelTest.php b/core/modules/user/src/Tests/UserCancelTest.php index a84927b..5c81034 100644 --- a/core/modules/user/src/Tests/UserCancelTest.php +++ b/core/modules/user/src/Tests/UserCancelTest.php @@ -78,7 +78,7 @@ function testUserCancelUid1() { ); // We cannot use $account->save() here, because this would result in the // password being hashed again. - db_update('users') + db_update('users_field_data') ->fields($account) ->condition('uid', 1) ->execute(); diff --git a/core/modules/user/src/Tests/UserInstallTest.php b/core/modules/user/src/Tests/UserInstallTest.php index 7a96df3..6b5ddd4 100644 --- a/core/modules/user/src/Tests/UserInstallTest.php +++ b/core/modules/user/src/Tests/UserInstallTest.php @@ -38,8 +38,10 @@ protected function setUp() { * Test that the initial users have correct values. */ public function testUserInstall() { - $anon = db_query('SELECT * FROM {users} WHERE uid = 0')->fetchObject(); - $admin = db_query('SELECT * FROM {users} WHERE uid = 1')->fetchObject(); + $result = db_query('SELECT u.uid, u.uuid, u.langcode, uf.status FROM {users} u INNER JOIN {users_field_data} uf ON u.uid=uf.uid ORDER BY u.uid') + ->fetchAllAssoc('uid'); + $anon = $result[0]; + $admin = $result[1]; $this->assertFalse(empty($anon->uuid), 'Anon user has a UUID'); $this->assertFalse(empty($admin->uuid), 'Admin user has a UUID'); diff --git a/core/modules/user/src/Tests/UserPasswordResetTest.php b/core/modules/user/src/Tests/UserPasswordResetTest.php index bd919a8..2c1919d 100644 --- a/core/modules/user/src/Tests/UserPasswordResetTest.php +++ b/core/modules/user/src/Tests/UserPasswordResetTest.php @@ -37,7 +37,7 @@ public function setUp() { // Set the last login time that is used to generate the one-time link so // that it is definitely over a second ago. $account->login = REQUEST_TIME - mt_rand(10, 100000); - db_update('users') + db_update('users_field_data') ->fields(array('login' => $account->getLastLoginTime())) ->condition('uid', $account->id()) ->execute();