You are not logged in.
Pages: 1
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
Offline
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?
Offline
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
Offline
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
Offline
Pages: 1