You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2017-11-16 21:50:26

machadomall
Member
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 208

Erro Update 9.2 to 9.2.1

Error update 9.2 to 9.2.1
- Error in query to database: UPDATE `glpi_profilerights` SET` name` = 'queuednotification' WHERE `name` = 'queuedmail' - Error is Duplicate entry '6-queuednotification' for key 'unicity'


Márcio Machado
Brasília-DF / Brasil

Offline

#2 2017-11-17 11:52:28

gmognon
Member
From: Brazil
Registered: 2017-09-29
Posts: 9

Re: Erro Update 9.2 to 9.2.1

I have a similar error updating from 9.1.6 to 9.2.1

9.2 multiple alter in glpi_states - Error in query to database: ALTER TABLE `glpi_states` ADD UNIQUE `unicity` (`states_id`, `name`) , ADD INDEX `is_visible_line` (`is_visible_line`) - Error is Duplicate entry '0-in use' for key 'unicity'

Last edited by gmognon (2017-11-17 11:58:06)

Offline

#3 2017-11-17 13:56:48

machadomall
Member
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 208

Re: Erro Update 9.2 to 9.2.1

Good Morning,
For me to continue with the update I had to remove the Duplicate field on the glpi_profilerights '6-queuednotification' table. I do not know what will be harmed.

Hugs.


Márcio Machado
Brasília-DF / Brasil

Offline

#4 2017-11-17 14:21:17

gmognon
Member
From: Brazil
Registered: 2017-09-29
Posts: 9

Re: Erro Update 9.2 to 9.2.1

Hello!
I Found the problem.
I had 2 status with the same name. "Em uso"

So, I just renamed one of them and after this I was able to upgrade to 9.2.1

Last edited by gmognon (2017-11-17 15:30:00)

Offline

#5 2017-11-17 16:12:58

machadomall
Member
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 208

Re: Erro Update 9.2 to 9.2.1

Hello,
There are other people with the same problem.

Issues: https://github.com/glpi-project/glpi/issues/3172


Márcio Machado
Brasília-DF / Brasil

Offline

Board footer

Powered by FluxBB