Forum GLPI-Project

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Update GLPI 9.2.2 to 9.2 Beta

Hello,

The glpi_knowbaseitems and glpi_knowbaseitemtranslations tables are not migrated to the InnoDB engine.

SQL Error (1214): The used table type doesn't support FULLTEXT indexes

Att.

---

Márcio Machado
Brasília-DF / Brasil

Langundo

Member

Registered: 2016-07-21

Posts: 75

Re: Update GLPI 9.2.2 to 9.2 Beta

Hello machadomall,
I don't know if it's the correct way but after update from 9.2.2 to 9.3 beta and import old database I have this error "303 tables not migrated to InnoDB engine"

I convert all tables with heidiSQL to InnoDB. (mass-table-editor).

Hope this will work for you to.

Greetz

---

Debian 11.7 - PHP 7.4.33 - MariaDB 10.5.19 - 10.0.8-dev

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: Update GLPI 9.2.2 to 9.2 Beta

Hello,

I had already done this, manually converted in heidiSQL to InnoDB.
Only these two tables glpi_knowbaseitems and glpi_knowbaseitemtranslations, which I can not translate, gives the error below.

SQL Error (1214): The table type does not support FULLTEXT indexes

Thankful.

---

Márcio Machado
Brasília-DF / Brasil

orthagh

Administrator

From: TECLIB - CAEN

Registered: 2010-11-30

Posts: 662

Website

Re: Update GLPI 9.2.2 to 9.2 Beta

Hello.

in the glpi archive of the 9.3 beta, you'll find a script name scripts/innodb_migration.php to achieve the migration.

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: Update GLPI 9.2.2 to 9.2 Beta

Hello,

Error scripts/innodb_migration.php

Tables found: 2 - Error during the database query: ALTER TABLE glpi_knowbaseitems ENGINE = InnoDB - Error is The used table type doesn't support FULLTEXT indexes

---

Márcio Machado
Brasília-DF / Brasil