1 (edited by ITCPOLAND 2017-05-15 17:23:22)

Topic: Issue with SLT after upgrade from 0.90.5 to 9.1.3

Hello

After I upgraded GLPI from 0.90.5 to 9.1.3 version I saw that i cannot modify my SLT. From debug mode I know that:
Fatal error: Call to a member function fetch_assoc() on a non-object in /usr/share/glpi/inc/dbmysql.class.php on line 308

In sql_errors.log I found:
*** MySQL query error:
  SQL: SELECT COUNT(*) AS cpt
             FROM `glpi_slalevels` WHERE `slts_id` = \'1\'
  Error: Unknown column 'slts_id' in 'where clause'
  Backtrace :
  inc/db.function.php:319
  inc/slalevel.class.php:494                         countElementsInTable()
  inc/commonglpi.class.php:208                       SlaLevel->getTabNameForItem()
  inc/slt.class.php:81                               CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       SLT->defineTabs()
  inc/commonglpi.class.php:618                       CommonGLPI->defineAllTabs()
  inc/commonglpi.class.php:1149                      CommonGLPI->showPrimaryForm()
  front/slt.form.php:81                              CommonGLPI->display()

Before upgrade I modified files 'update_91_911.php' and 'update_0905_91.php' according to forum: http://forum.glpi-project.org/viewtopic.php?id=155990 and http://forum.glpi-project.org/viewtopic.php?id=156816 but it not helped.

Could anyone help to solve the problem?

2

Re: Issue with SLT after upgrade from 0.90.5 to 9.1.3

Anyone can help me? this is the test before production implementation, so i have to resolve any issues before start in production.

3

Re: Issue with SLT after upgrade from 0.90.5 to 9.1.3

Make this changes:

- in glpi_slalevels
    if you have field slas_id change it by slts_id

- in glpi_tickets
    if you have field slas_id change it by slts_ttr_id
    if you have field slalevels_id change it by ttr_slalevels_id
    if you don't have field slts_tto_id, add it (integer)
    if you don't have field time_to_own, add it (datetime)

CentOS 6.5 - PHP 5.6 - PHP 7 - MySQL 5.6  + APC + memcached
GLPI 0.90.5 SVN - GLPI 9.1.3 SVN
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

4

Re: Issue with SLT after upgrade from 0.90.5 to 9.1.3

yllen wrote:

Make this changes:

- in glpi_slalevels
    if you have field slas_id change it by slts_id

- in glpi_tickets
    if you have field slas_id change it by slts_ttr_id
    if you have field slalevels_id change it by ttr_slalevels_id
    if you don't have field slts_tto_id, add it (integer)
    if you don't have field time_to_own, add it (datetime)

It's working. Thank you for support.