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 2019-09-10 21:09:53

mcsoto
Member
Registered: 2019-09-06
Posts: 9

tables not migrated to the InnoDB engi ( 9.4 not innodb_migration.php)

Since in version 9.4 there is no file to correct, can you tell me how I make the correction so that this alarm does not appear?

as a procedure, remove all the plug-ins that you had installed but the message still appears

Thank you

Offline

#2 2019-09-10 23:01:59

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 4,650

Re: tables not migrated to the InnoDB engi ( 9.4 not innodb_migration.php)

read this
https://glpi-install.readthedocs.io/en/ … -line.html and migration Tools section


Trouver la panne avant de réparer...
*GLPI 9.1.6+fusion9.1+1.1+behaviours1.5.0+reports+fields+appliances+pdf+badges+formcreator2.5.2 PHP7.0 Mariadb10
*GLPI 9.4.3(behaviours2.2.1+fusioninventoty 9.4+1.1+applicatifs2.5.0+fields 1.9.1)hebergé sur serveur mutualisé.

Offline

#3 2019-09-10 23:09:09

mcsoto
Member
Registered: 2019-09-06
Posts: 9

Re: tables not migrated to the InnoDB engi ( 9.4 not innodb_migration.php)

Hello.

But here it only comes out for version 9.3
As I said, I have version 9.4
----------------------------------------------------

Migration tools
From MyISAM to InnoDB

    New in version 9.3.0.

Since version 9.3.0, GLPI uses the InnoDB engine instead of previously used MyISAM engine.

The php bin / console glpi: migration: myisam_to_innodb command can be used to migrate exiting tables to InnoDB engine.

--->

Is there any method to help me detect the TABLE that is in trouble and be able to correct it?


I don't see the file in question in 9.4 :

-rwxr-xr-x. 1 apache apache 3497 Jun 20 09:06 compute_dictionnary.php
-rwxr-xr-x. 1 apache apache 1435 Jun 20 09:06 glpi_cron_curl.sh
-rwxr-xr-x. 1 apache apache 1434 Jun 20 09:06 glpi_cron_lynx.sh
-rwxr-xr-x. 1 apache apache 7450 Jun 20 09:06 ldap_mass_sync.php
drwxr-xr-x. 2 apache apache   29 Jun 20 09:06 migrations
-rwxr-xr-x. 1 apache apache 2017 Jun 20 09:06 softcat_mass_compute.php

Last edited by mcsoto (2019-09-10 23:11:46)

Offline

#4 2019-09-10 23:14:32

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 4,650

Re: tables not migrated to the InnoDB engi ( 9.4 not innodb_migration.php)

"since 9.3 version"  means for 9.3 and Following versions including 9.4.x

check, it works

cd /var/www/glpi/

php bin/console glpi:migration:myisam_to_innodb


Trouver la panne avant de réparer...
*GLPI 9.1.6+fusion9.1+1.1+behaviours1.5.0+reports+fields+appliances+pdf+badges+formcreator2.5.2 PHP7.0 Mariadb10
*GLPI 9.4.3(behaviours2.2.1+fusioninventoty 9.4+1.1+applicatifs2.5.0+fields 1.9.1)hebergé sur serveur mutualisé.

Offline

#5 2019-09-11 08:21:05

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 4,650

Re: tables not migrated to the InnoDB engi ( 9.4 not innodb_migration.php)

Is there any method to help me detect the TABLE that is in trouble and be able to correct it?

use MySQL or phpMyAdmin :

SELECT
    TABLE_NAME, ENGINE
  FROM INFORMATION_SCHEMA.TABLES
  WHERE table_schema = 'glpi'


Trouver la panne avant de réparer...
*GLPI 9.1.6+fusion9.1+1.1+behaviours1.5.0+reports+fields+appliances+pdf+badges+formcreator2.5.2 PHP7.0 Mariadb10
*GLPI 9.4.3(behaviours2.2.1+fusioninventoty 9.4+1.1+applicatifs2.5.0+fields 1.9.1)hebergé sur serveur mutualisé.

Offline

#6 2019-09-11 14:39:22

mcsoto
Member
Registered: 2019-09-06
Posts: 9

Re: tables not migrated to the InnoDB engi ( 9.4 not innodb_migration.php)

LaDenrée wrote:

Is there any method to help me detect the TABLE that is in trouble and be able to correct it?

use MySQL or phpMyAdmin :

SELECT
    TABLE_NAME, ENGINE
  FROM INFORMATION_SCHEMA.TABLES
  WHERE table_schema = 'glpi'



---------------------------------------- smile ----------------------------------------------------------



SELECT
    TABLE_NAME, ENGINE
  FROM INFORMATION_SCHEMA.TABLES
  WHERE table_schema = 'glpi' and ENGINE <> 'InnoDB'

Thank you

Offline

#7 2019-09-11 14:41:41

mcsoto
Member
Registered: 2019-09-06
Posts: 9

Re: tables not migrated to the InnoDB engi ( 9.4 not innodb_migration.php)

LaDenrée wrote:

"since 9.3 version"  means for 9.3 and Following versions including 9.4.x

check, it works

cd /var/www/glpi/

php bin/console glpi:migration:myisam_to_innodb


---------------------------------- smile ----------------------------------------


[root@ Server glpi]# php bin/console glpi:migration:myisam_to_innodb
Found 1 table(s) using MyISAM engine.
Do you want to continue ? [Yes/no]Yes
Migration done.

Thank You smile

Offline

Board footer

Powered by FluxBB