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 2018-04-13 00:03:17

machadomall
Guest
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 160

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

Offline

#2 2018-04-16 16:09:59

Langundo
Guest
Registered: 2016-07-21
Posts: 41

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


work: Debian 9.5 - PHP 7.0.30 - MariaDB 10.1.26 - GLPI 9.2.3
test: sometimes with bugfix / master

Offline

#3 2018-04-16 21:56:37

machadomall
Guest
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 160

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

Offline

#4 2018-04-17 11:01:27

orthagh
Administrator
From: Chartres
Registered: 2010-11-30
Posts: 484

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.

Offline

#5 2018-04-18 03:18:33

machadomall
Guest
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 160

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

Offline

Board footer

Powered by FluxBB