Forum GLPI-Project

willianmgrocha

Member

From: Brazil

Registered: 2014-10-22

Posts: 75

Error to Upgrade GLPI 9.1.6 to GLPI 9.2.1

Hi Guys,

Could you help me?

when I try to upgrade the version GLPi 9.1.6 to 9.2.1 is show the error about one table, someone of you have one tip to solve it?
Below i send the error.

Change of the database layout - glpi_problems (1 minutes 17 seconds)

9.2 migrate notifications templates - Error during the database query: INSERT INTO `glpi_notifications_notificationtemplates` (`notifications_id`, `mode`, `notificationtemplates_id`) SELECT `id`, `mode`, `notificationtemplates_id` FROM `glpi_notifications` - Error is Duplicate entry '1-mail-6' for key 'unicity'

Thanks for your help.

Best REgards

joaoprietos

Member

From: Porto Alegre - RS / Brazil

Registered: 2008-08-19

Posts: 31

Re: Error to Upgrade GLPI 9.1.6 to GLPI 9.2.1

I had a similar problem when I did the upgrade.

You have a duplicate name in the table glpi_notifications, as you have 2 items with the '1-mail-6'.

If you have access to the original glpi and are working in a test server you can change that in the production GLPI and export the DB again to the test server.

Or you can change it directly in the DB if you are familiar with SQL or tools like MySQL Workbench.

---

GLPI 9.1.6
4500+ computers / 2000 tickets month