Duplicate usernames cause update issue/es: Difference between revisions

Revision as of 17:19, 10 March 2020

En ciertos sitios web, actualizar a Joomla 3.9.16 provoca un error en la base de datos debido a nombres de usuarios duplicados. Si eso pasa, no entrar en pánico - la actualización ha sido mayormente completada sin problemas, y el cambio restante de la base de datos puede realizarse después de seguir las instrucciones que figuran a continuación.

Errores reportados

Los usuarios reciben un error de actualización en relación con una consulta fallida de la base de datos debido a una clave duplicada en una tabla de su sitio web #__users al actualizar a Joomla 3.9.15 o posterior.

Versiones afectadas

Información General

Cuál es la causa

El sitio web tiene más de un usuario en la #__users tabla con el mismo nombre de usuario, lo cual es una amenaza para la seguridad, ya que el dueño equivocado puede acceder a la la cuenta incorrecta.

Cómo solucionarlo

Es necesario revisar la #__users table in your database and fix any duplicated usernames by either removing old user accounts or changing the username until all usernames are unique. Once this is finished, if you have already upgraded to 3.9.16 run the database schema fixer tool to finish the upgrade (this step is not required if you do this review prior to upgrading).

Joomla is unable to automatically determine the correct action to take and as a result is unable to perform this step for you - it has to be fixed by you as the site owner.

The following SQL Query can be run on your database to view which usernames are duplicated:

SELECT username FROM #__users GROUP BY username HAVING COUNT(*) > 1

@@ Line 13: / Line 13: @@
 ==Cómo solucionarlo==
-You will need to review your <source lang="sql" inline>#__users</source> table in your database and fix any duplicated usernames by either removing old user accounts or changing the username until all usernames are unique. Once this is finished, if you have already upgraded to 3.9.16 run the database schema fixer tool to finish the upgrade (this step is not required if you do this review prior to upgrading).
+Es necesario revisar la <source lang="sql" inline>#__users</source> table in your database and fix any duplicated usernames by either removing old user accounts or changing the username until all usernames are unique. Once this is finished, if you have already upgraded to 3.9.16 run the database schema fixer tool to finish the upgrade (this step is not required if you do this review prior to upgrading).
 Joomla is unable to automatically determine the correct action to take and as a result is unable to perform this step for you - it has to be fixed by you as the site owner.

J3.x