GLPI 11 rc5 error updating database
Closed this issue · 5 comments
Code of Conduct
- I agree to follow this project's Code of Conduct
Is there an existing issue for this?
- I have searched the existing issues
Version
11.0.0-rc5
Bug description
When upgrading the database from version 10.0.19, it throws a table name error.
Relevant log output
An error occurred during the update. The error was: Unable to rename table glpi_computerantiviruses (ok) to glpi_itemantiviruses (not ok)!Page URL
No response
Steps To reproduce
No response
Your GLPI setup information
No response
Anything else?
No response
I tested it here by updating from 10.0.19 to 11 rc5 and it went smoothly. It took a little longer than usual, but after updating, I ran the recommended commands in the console through the initial interface and everything was normal, including the forms. However, there was an error when importing generic assets. I will open an issue as soon as I understand the log.
If you tried to update the version from an .sql backup, try updating again from a new, updated dump.
I have made another copy and this one has loaded correctly.
I have the same problem. I am working with a dump of the database from GLPI 10.0.20 to test the GLPI 11 docker. I restored the dump with docker exec -i glpi11test-db-1 mysql -u<user> -p<pasword> glpidb < ./glpi_dump.sql.
Could you please point me to the right direction?
This kind of error occurs on an already partially migrated database.
The way to go is to always first restore your initial backup you want to migrate; errors during update cause impossible to predict database state.