Forum GLPI-Project

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Upgrade from version 0.90.5 to 9.1.

Hello good day,

- Error updating from version 0.90.5 to 9.1.

9.1 add right for softwarelicense - Erro na consulta ao banco de dados: INSERT INTO `glpi_profilerights` (`id`, `profiles_id`, `name`, `rights`) VALUES (NULL, '1', 'license', '0') - Erro é Duplicate entry '1-license' for key 'unicity'

Thank you.

---

Márcio Machado
Brasília-DF / Brasil

t.tsoukas

Member

Registered: 2010-07-19

Posts: 3

Re: Upgrade from version 0.90.5 to 9.1.

Hi all,
Second this: 0.90.5 upgrade to 0.91, php 5.6, mysql 5.6

LOCATION - Error during the database query: CREATE TABLE `glpi_dropdown_locations_new` ( `ID` INT NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL , `parentID` INT NOT NULL , `comments` TEXT NULL , PRIMARY KEY (`ID`), UNIQUE KEY (`name`,`parentID`), KEY(`parentID`)) TYPE=MyISAM - Error is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

Thanks,
ted

EDIT:
My bad, not enough space avaible on the server and everything collapsed.
New installation went fine, with one warning but I cannot seem to find new license management menu.

Last edited by t.tsoukas (2016-09-24 01:06:25)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Upgrade from version 0.90.5 to 9.1.

machadomall: this error appeared when you play migration several times
Corrected: https://github.com/glpi-project/glpi/issues/1079

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: Upgrade from version 0.90.5 to 9.1.

Hello good day
Thank Yllen perfectly ran 0.90.5 update to 9.1.
No known error.

Grateful.

---

Márcio Machado
Brasília-DF / Brasil