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 2014-11-12 11:03:02

elliot01
Member
From: England
Registered: 2010-03-23
Posts: 206

Upgrading v0.84.8 to 0.85 RC2.1

When I run this upgrade against a copy of our GLPI system, it fails with:

"
- Error during the database query: ALTER TABLE `glpi_users` DROP PRIMARY KEY - Error is Incorrect table definition; there can be only one auto column and it must be defined as a key
"


1500+ Computers / 1100+ users

Offline

#2 2014-11-12 12:42:23

elliot01
Member
From: England
Registered: 2010-03-23
Posts: 206

Re: Upgrading v0.84.8 to 0.85 RC2.1

sql-errors.log contents:

"
  *** MySQL query error:
  SQL: ALTER TABLE `glpi_users`
                DROP PRIMARY KEY
  Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
  Backtrace :
  inc/dbmysql.class.php:201
  install/update_031_04.php:161                      DBmysql->queryOrDie()
  install/update.php:769                             update031to04()
  install/update.php:914                             updateDbUpTo031()
"


1500+ Computers / 1100+ users

Offline

#3 2014-11-19 09:09:22

lexx015
Member
From: Russia, Perm
Registered: 2012-06-29
Posts: 45

Re: Upgrading v0.84.8 to 0.85 RC2.1

Same thing.

But you can make a dump of 0.84.8 and restore it on 0.85 with GLPI and update after.

I just done this without any issues.

Last edited by lexx015 (2014-11-19 09:09:50)


Debian Sid + GLPI 0.84.8 + Apache 2.4.10 + nginx 1.6.2 + PHP 5.6.0 + mysql 5.5.39
12000+ users

Offline

Board footer

Powered by FluxBB