Forum GLPI-Project

acollante

Member

Registered: 2023-04-13

Posts: 2

Problems to migrate to GLPI 10 SQL Warnings: 1146

Hello dear community, there is a problem that I have been trying to solve for weeks, and I have not found any solution on the internet.

I have GLPI 9.5 and have upgraded successfully between subversions, but I have not been able  to upgrade to version 10.0,

I have tried versions from 9.5.7 to 9.5.13, 10.0.0 to 10.0.7 and even though the migration seems to work, it is full of database errors,

the first error is SQL Warnings: 1146: Table 'mysql.index_stats' doesn't exist and so it repeats with many tables.

I also tried to update via php bin/console db:update but it says the database cannot be accessed.

If i tried to upgrade from previous versions, to this version that i have, there was no problem.

Any ideas???

cedric-anne

Administrator

Registered: 2018-07-02

Posts: 85

Re: Problems to migrate to GLPI 10 SQL Warnings: 1146

Hi,

It looks that you have a problem with your MySQL server. Indeed, this is a base table of MySQL, not a GLPI table.

IMHO, you should dump all your application databases and reinstall the MySQL server from scratch.

acollante

Member

Registered: 2023-04-13

Posts: 2

Re: Problems to migrate to GLPI 10 SQL Warnings: 1146

Thanks a lot, I do this and it works, i had to do in another server, because in the server that i tried to update i have already working with ocs inventory, maybe, this cause some modification in mysql tables. Best regards!