You are not logged in.
I have attempted to upgrade an installation of 0.7.16 -> 9.2.1.
1) Backed up MySQL using dump via application. Also I have backed up DB using mysqldump.
2) Backed up and moved existing GLPI application files.
3) Ensured all dependencies were met before the upgrade.
4) Ran update script and encountered following SQL errors below.
5) I then added DROP permission for this db_user.
6) Attempted the update again and now I am presented with a 500 Internal Server Error
Please can you assist in diagnose the issue?
Do I need to GRANT SQL create permission to the user?
Or should I create the table glpi_plugins manually?
What should I look for in the IIS logs?
-------------------8<SNIP -------------------------------------------------------------
Output from installation log file
*** MySQL query error:
SQL: UPDATE `glpi_plugins`
SET `state` = 4
WHERE `state` = 1
Error: Table 'glpi.glpi_plugins' doesn't exist
Backtrace :
inc\plugin.class.php:898
inc\update.class.php:169 Plugin->unactivateAll()
install\update.php:457 Update->doUpdates()
install\update.php:564 doUpdateDb()
2018-01-09 15:04:39 [@PRETENDVM]
*** MySQL query error:
SQL: DROP TABLE `glpi_licenses`
Error: DROP command denied to user 'user'@'anipaddress' for table 'glpi_licenses'
Backtrace :
inc\dbmysql.class.php:215
install\update_0713_072.php:445 DBmysql->queryOrDie()
inc\update.class.php:249 update0713to072()
install\update.php:457 Update->doUpdates()
install\update.php:564 doUpdateDb()
2018-01-09 15:09:04 [@PRETENDVM]
*** MySQL query error:
SQL: UPDATE `glpi_plugins`
SET `state` = 4
WHERE `state` = 1
Error: Table 'glpi.glpi_plugins' doesn't exist
Backtrace :
inc\plugin.class.php:898
inc\update.class.php:169 Plugin->unactivateAll()
install\update.php:457 Update->doUpdates()
install\update.php:564 doUpdateDb()
2018-01-09 15:09:05 [@PRETENDVM]
*** MySQL query error:
SQL: RENAME TABLE `glpi_softwarelicenses`
TO `glpi_softwarelicenses_backup`
Error: DROP command denied to user 'user'@'anipaddress' for table 'glpi_softwarelicenses'
Backtrace :
inc\dbmysql.class.php:215
install\update_0713_072.php:182 DBmysql->queryOrDie()
inc\update.class.php:249 update0713to072()
install\update.php:457 Update->doUpdates()
install\update.php:564 doUpdateDb()
2018-01-09 15:09:53 [@PRETENDVM]
*** MySQL query error:
SQL: SELECT TABLE_NAME FROM information_schema.`TABLES`
WHERE TABLE_SCHEMA = 'glpi'
AND TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME LIKE '%glpi_config%'
Error:
Backtrace :
inc\dbmysql.class.php:383
inc\dbmysql.class.php:731 DBmysql->list_tables()
inc\config.class.php:2670 DBmysql->tableExists()
inc\session.class.php:584 Config::getCache()
install\update.php:498 Session::loadLanguage()
Offline