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 2016-11-16 13:01:58

andrew.k2
Guest
From: Latvia
Registered: 2014-05-07
Posts: 57

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

Offline

#2 2016-11-16 13:20:37

andrew.k2
Guest
From: Latvia
Registered: 2014-05-07
Posts: 57

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

Offline

#3 2016-11-16 19:30:04

KKAdmin
Guest
From: Germany
Registered: 2010-03-05
Posts: 459

Re: GLPI 9.1 tp 9.1.1 update


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

Offline

#4 2016-11-16 19:38:24

machadomall
Guest
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 48

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
Analista de Suporte
Brasília-DF / Brasil

Offline

#5 2016-11-17 21:58:52

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 13,360

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)

Offline

#6 2016-11-17 22:52:32

KKAdmin
Guest
From: Germany
Registered: 2010-03-05
Posts: 459

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

Offline

Board footer

Powered by FluxBB