Forum GLPI-Project

prashantt

Member

Registered: 2022-06-03

Posts: 1

GLPI Upgrade from 9.5.7 to 10.0.1 throws "utf8mb4" support warning

Hello,

I was in the process of upgrading GLPI from 9.5.7 to 10.0.1

However on hitting the upgrade URL following is shown i.e :

"utf8mb4" support requires additional migration which can be performed via the "php bin/console glpi:migration:utf8mb4" command.

Also inside the admin panel following warnings are shown :

390 tables are using the deprecated utf8mb3 storage charset. Run the "php bin/console glpi:migration:utf8mb4" command to migrate them.
1302 primary or foreign keys columns are using signed integers. Run the "php bin/console glpi:migration:unsigned_keys" command to migrate them.

Since I am on a shared hosting I don't have access to the command line to execute the above commands.

Is there any other way to achieve the utf8mb4 and the foreign key migrations, i.e without the command line?.

Or is it possible that by making changes to the GLPI upgrade script , the migrations would be run by the GLPI script itself , so that users on shared hosting who don't have access to the command line also would be able to migrate successfully, without any hassle.

Kindly let me know the same.

Last edited by prashantt (2022-06-03 10:36:00)

Kaya84

Member

Registered: 2019-06-13

Posts: 217

Re: GLPI Upgrade from 9.5.7 to 10.0.1 throws "utf8mb4" support warning

For utf8mb4 this is the command:
ALTER TABLE `%s` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
I think u can use phpmyadmin and check tables to find which ones are not using the correct storage set

For unsigned keys, thisi is the query:
https://github.com/glpi-project/glpi/bl … l.php#L782
but then it will be a more complicated to fix:
https://github.com/glpi-project/glpi/bl … nd.php#L62

doesntMatter

Member

Registered: 2016-07-06

Posts: 108

Re: GLPI Upgrade from 9.5.7 to 10.0.1 throws "utf8mb4" support warning

Sometimes you can ask the webhosting-company to run the comands for you.