Forum GLPI-Project

andrew.k2

Member

From: Latvia

Registered: 2014-05-07

Posts: 60

GLPI 9.1 tp 9.1.1 update

Hello,
Trying to update GLPI and get this error:

9.1.1 multiple alter in glpi_tickets - Error during the database query: ALTER TABLE `glpi_tickets` ADD INDEX `slts_ttr_id` (`slts_ttr_id`) , DROP INDEX `slalevels_id` , ADD INDEX `ttr_slalevels_id` (`ttr_slalevels_id`) - Error is Key column 'ttr_slalevels_id' doesn't exist in table

sql-errors.log:

2016-11-16 12:50:12 [@helpdesktest]
  *** MySQL query error:
  SQL: ALTER TABLE `glpi_tickets` ADD INDEX `slts_ttr_id` (`slts_ttr_id`) ,
DROP INDEX `slalevels_id` ,
ADD INDEX `ttr_slalevels_id` (`ttr_slalevels_id`) 
  Error: Key column 'ttr_slalevels_id' doesn't exist in table
  Backtrace :
  inc/dbmysql.class.php:208                          
  inc/migration.class.php:579                        DBmysql->queryOrDie()
  install/update_91_911.php:90                       Migration->migrationOneTable()
  install/update.php:800                             update91to911()
  install/update.php:958                             updateDbUpTo031()
2016-11-16 12:51:00 [@helpdesktest]
  *** MySQL query error:
  SQL: ALTER TABLE `glpi_tickets` ADD INDEX `slts_ttr_id` (`slts_ttr_id`) ,
DROP INDEX `slalevels_id` ,
ADD INDEX `ttr_slalevels_id` (`ttr_slalevels_id`) 
  Error: Key column 'ttr_slalevels_id' doesn't exist in table
  Backtrace :
  inc/dbmysql.class.php:208                          
  inc/migration.class.php:579                        DBmysql->queryOrDie()
  install/update_91_911.php:90                       Migration->migrationOneTable()
  install/update.php:800                             update91to911()
  install/update.php:958                             updateDbUpTo031()

---

[prod] - GLPI 9.3; [test] - GLPI 9.3.1

andrew.k2

Member

From: Latvia

Registered: 2014-05-07

Posts: 60

Re: GLPI 9.1 tp 9.1.1 update

resolved, thx!

Changeg column name in glpi_tickets from "slalevels_id" to "ttr_slalevels_id".

---

[prod] - GLPI 9.3; [test] - GLPI 9.3.1

KKAdmin

Member

From: Germany

Registered: 2010-03-05

Posts: 959

Re: GLPI 9.1 tp 9.1.1 update

https://github.com/glpi-project/glpi/issues/1296

---

You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: GLPI 9.1 tp 9.1.1 update

Hello
It was the same problem as mine, I made the fix and update occurred normally.

Thank you.

---

Márcio Machado
Brasília-DF / Brasil

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: GLPI 9.1 tp 9.1.1 update

There is an error in the file to update.
In glpi/install/update_091_911.php, delete these lines

  // rectify indexes in 9.1 update
   $migration->addKey('glpi_tickets', 'slts_ttr_id');
   $migration->dropKey('glpi_tickets', 'slalevels_id');
   $migration->addKey('glpi_tickets', 'ttr_slalevels_id');
   $migration->migrationOneTable('glpi_tickets');

Theses modifications were alredy done in the previous update

---

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)

KKAdmin

Member

From: Germany

Registered: 2010-03-05

Posts: 959

Re: GLPI 9.1 tp 9.1.1 update

I got just for a moment in trouble
The file is glpi/install/update_91_911.php

---

You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3

elyout

Member

From: Strasbourg

Registered: 2006-08-07

Posts: 3

Website

Re: GLPI 9.1 tp 9.1.1 update

I had this error today when upgrading from 0.90.5 to 9.2

I delete those lines and upgrade works !

So I think install/update_91_911.php should be upgraded with those lines removed ?

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: GLPI 9.1 tp 9.1.1 update

We can't change file in a release version

---

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)