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
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

Offline

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

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

Offline

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

KKAdmin
Member
From: Germany
Registered: 2010-03-05
Posts: 959

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.3.3

Offline

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

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

Offline

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

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

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)

Offline

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

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 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.3.3

Offline

#7 2017-10-19 15:38:01

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 ?

Offline

#8 2017-10-23 15:42:52

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

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)

Offline

Board footer

Powered by FluxBB