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 2017-05-15 17:11:44

ITCPOLAND
Member
Registered: 2015-12-10
Posts: 21

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?

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

Offline

#2 2017-05-22 13:27:46

ITCPOLAND
Member
Registered: 2015-12-10
Posts: 21

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.

Offline

#3 2017-05-22 15:40:35

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

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 - 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)

Offline

#4 2017-05-25 14:22:14

ITCPOLAND
Member
Registered: 2015-12-10
Posts: 21

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.

Offline

#5 2017-06-01 19:51:27

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Issue with SLT after upgrade from 0.90.5 to 9.1.3

Thanks for news. I close


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)

Offline

Board footer

Powered by FluxBB