Forum GLPI-Project

c.morrison

Member

Registered: 2016-07-28

Posts: 2

Error when upgrading GLPI

I am attempting to copy an older version of GLPI to a new machine and upgrade it. I've used mysqldump to export the database and imported it. However when I run the upgrade I get the following error

  *** MySQL query error:
  SQL: UPDATE `glpi_tickets`
                   SET `status` = \'6\'
                   WHERE `status` = \'closed\'
  Error: Unknown column 't.ticketcategories_id' in 'on clause'
  Backtrace :
  inc/dbmysql.class.php:205
  install/update_0831_084.php:176                    DBmysql->queryOrDie()
  install/update.php:743                             update0831to084()
  install/update.php:944                             updateDbUpTo031()

I'm not sure where to go with this one. A Desc of glpi_tickets shows 37 columns but nothing like t.ticketcategories_id.

c.morrison

Member

Registered: 2016-07-28

Posts: 2

Re: Error when upgrading GLPI

I've managed to get past the error above but now I'm getting a new error.

0.84 status in glpi_tickets closed to 6 - Error during the database query: UPDATE `glpi_tickets` SET `status` = '6' WHERE `status` = 'closed' - Error is Table 'helpdesk.c' doesn't exist

This helpdesk.c table doesn't exist in the original installation either, so I'm very confused where it is coming from.

2016-07-28 12:05:38 [@fbsdws2]
  *** MySQL query error:
  SQL: UPDATE `glpi_tickets`
                   SET `status` = \'6\'
                   WHERE `status` = \'closed\'
  Error: Table 'helpdesk.c' doesn't exist
  Backtrace :
  inc/dbmysql.class.php:205
  install/update_0831_084.php:176                    DBmysql->queryOrDie()
  install/update.php:743                             update0831to084()
  install/update.php:944                             updateDbUpTo031()

This occured when migrating to the 0.84 version

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Error when upgrading GLPI

Your error in during the upgrade from 0.83.1 version

I don't see field (https://forge.glpi-project.org/issues/5507) or table ('helpdesk.c') in the error.
Can you give me the complete error log (sql and php error.log)?

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)