Forum GLPI-Project

potential

Member

Registered: 2011-10-19

Posts: 2

0.80 upgrade problem

Hi!
While upgrading from 0.78.2 to 0.80.4 had a problem in updating mysql database.
Then tried to make smaller upgrades 0.78.2 - 0.78.5 went fine
But when upgrading 0.78.5 -> 0.80 the error repeated:

0.80 change autoclose ticket in glpi_configs  Incorrect key file for table 'glpi_configs'; try to repair it

Repaired table 'glpi_configs' (dropped and created from backup) - it didn't help - the error appeares again when upgrading (and table 'glpi_configs' looking good before upgrade, looks like 'view' and need repairing after upgrade)
Any clues? Is it mysql or some other error?

Webserver: FreeBSD 7.0, memory_limit in php.ini = 128M, Apache2.2.9
DB server: FreeBSD 7.2, MySQL 6.0.10-alpha

MySQL error messages begin with:
2011-10-20 10:43
*** MySQL query error :
***
SQL: SELECT `smtp_password`
                FROM `glpi_configs`
                WHERE `id` = \'1\'
Error: Incorrect key file for table 'glpi_configs'; try to repair it
Backtrace :
/usr/local/www/glpi/install/update_0782_080.php :1057              DBmysql-
>query()
/usr/local/www/glpi/install/update.php :717                update0782to080(
)
/usr/local/www/glpi/install/update.php :896                updateDbUpTo031(
)
/usr/local/www/glpi/install/update.php

Last edited by potential (2011-10-20 08:48:30)

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: 0.80 upgrade problem

It's not a glpi problem but a mysql server problem.

Your table seems to be corrupted. Did you try to repair it with  myisamchk ?

Also the problem come back again and again, you have to find why your mysql server crash. Make some search on google about this.

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

potential

Member

Registered: 2011-10-19

Posts: 2

Re: 0.80 upgrade problem

Thank you for your answer
I made new server on centos, moved glpi there and successfully upgraded.
Thanks for your attention and for things you do!

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: 0.80 upgrade problem

OK. I close

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)