Forum GLPI-Project

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

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

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