1

Topic: 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.1.2; [test] - GLPI 9.1.2

2

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.1.2; [test] - GLPI 9.1.2

3

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.1.2 /Ubuntu 14.04.4 LTS
Apache/2.4.7 (Ubuntu) - PHP 5.5.9-1ubuntu4.16 - MySQL: 5.5.49-0ubuntu0.14.04.1

4

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.

5

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 - PHP 5.6 - PHP 7 - MySQL 5.6  + APC + memcached
GLPI 0.90.5 SVN - GLPI 9.1.3 SVN
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

6

Re: GLPI 9.1 tp 9.1.1 update

I got just for a moment in trouble smile
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.1.2 /Ubuntu 14.04.4 LTS
Apache/2.4.7 (Ubuntu) - PHP 5.5.9-1ubuntu4.16 - MySQL: 5.5.49-0ubuntu0.14.04.1