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-01-09 17:42:16

cymro_glpi
Member
Registered: 2018-01-09
Posts: 1

IIS error 500 from Server after upgrade from 0.7.16 -> 9.2.1

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

Board footer

Powered by FluxBB