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 2024-07-22 15:20:51

KMY
Member
Registered: 2024-07-12
Posts: 4

Migration GLPI v9.1.1 > 10.0.16

Hello,

I would like to migrate my GLPI server version 9.1.1 (Windows server, web part done with Wamp) to a new Windows server where I have installed GLPI version 10.0.16. I've tried to migrate by exporting my DB and re-importing it on the new GLPI, but I'm getting a lot of errors like this :


An index must be added in the 'id_search_option' field of the 'glpi_logs table'; but your glpi_logs table is too huge. You'll have to add it on your database with the following query: 'ALTER TABLE glpi_logs ADD INDEX id_search_option(id_search_option);'

PHP User Warning (512): Usage of signed integers in primary or foreign keys is discouraged, please use unsigned integers instead in `glpi_changetasks`.`groups_id_tech`. in C:\wamp64\www\glpi\src\DBmysql.php at line 2174

PHP User Warning (512): Usage of "utf8" charset/collation detected, should be "utf8mb4" in C:\wamp64\www\glpi\src\DBmysql.php at line 2136

9.3 multiple alter in glpi_items_disks - Erreur durant l'éxecution de la requête : ALTER TABLE `glpi_items_disks` DROP INDEX `computers_id` , CHANGE `computers_id` `items_id` INT NOT NULL DEFAULT '0' , ADD INDEX `items_id` (`items_id`) , ADD `itemtype` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `entities_id` , ADD INDEX `itemtype` (`itemtype`) , ADD INDEX `item` (`itemtype`, `items_id`) - L'erreur est La clé est trop longue. Longueur maximale: 1000



Before re-importing my DB, I deleted all the tables created by the new GLPI to be able to import those of version 9.1.1.


Do you have any recommendations for migrating my GLPI server? Should I do it gradually?

Thank you for yours help smile

Offline

#2 2024-07-23 11:04:17

Kaya84
Member
Registered: 2019-06-13
Posts: 217

Re: Migration GLPI v9.1.1 > 10.0.16

You don't need to installa on the new server.

Move the database between old to new server, and then launch the installation process.

REF: https://forum.glpi-project.org/viewtopic.php?id=288572
https://glpi-install.readthedocs.io/en/ … pdate.html

Offline

#3 2024-07-23 13:43:39

KMY
Member
Registered: 2024-07-12
Posts: 4

Re: Migration GLPI v9.1.1 > 10.0.16

Hi, that's what I tried to do, but I got a lot of errors as indicated in my first message sad

Offline

#4 2024-07-24 15:46:05

Kaya84
Member
Registered: 2019-06-13
Posts: 217

Re: Migration GLPI v9.1.1 > 10.0.16

Tell me if i'm right

New WAMP SERVER, DB CLEAN
Created db (eg glpi)
imported old db in new db

opened glpi on new server.
Did the upgrade process started?

BTW looking your log, I suppose you havbe to convert the database in utf8mb4 (bin/console.php is your friend)

And as written above : ALTER TABLE glpi_logs ADD INDEX id_search_option(id_search_option)
in mysql.
Try again and let me know

Offline

Board footer

Powered by FluxBB