Forum GLPI-Project

matteo.pelucchi

Member

Registered: 2018-06-18

Posts: 2

help me please

Hello everyone.
In our company we decide to upgrade our old GLPI to th new version.
This is the actually situation:
- Centos 7 server
- Maria Db
I export the old db from old GLPI (0.78) and when all in my new server I import to the new and launch the upgrade.
Now I see this error:

Update to 9.1

Change of the database layout - glpi_tickets (2 seconds)
9.1 multiple alter in glpi_tickets - Error during the database query: ALTER TABLE `glpi_tickets` ADD `slts_tto_id` INT(11) NOT NULL DEFAULT '0' AFTER `slts_ttr_id` , ADD INDEX `slts_tto_id` (`slts_tto_id`) - Error is Unknown column 'slts_ttr_id' in 'glpi_tickets'

Can anyone give me a hand to solve this issue????

Many thanks to all!..

Matteo

Jean-Christophe

Moderator

Registered: 2007-08-22

Posts: 734

Re: help me please

I'm not sure it is possible to upgrade the DB from 0.78 to 9.1.
I would upgrade to 0.8x first.
Did you check the doc? Anything about the upgrade path?

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,167

Re: help me please

whatever the version you come from there's a known bug in migration script :  see here :
http://forum.glpi-project.org/viewtopic.php?id=155990

make sure your 0.78 dump is ok
delete tables from glpi database
restore 0.78 dump

modifiy migration script

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

rerun migration.

---

Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

matteo.pelucchi

Member

Registered: 2018-06-18

Posts: 2

Re: help me please

Hello guys!
So this is the situation:
In glpi/install/ I don't have update_091_911.php but I have have update_0905_91.php (before update0901_0905.php and after update911_913.php) that contain the file that you tell me to remove.
I remove it from that script that I found but nothing change: I have the same problem.. :-(

Any ideas?

Regards