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 2019-04-19 14:29:38

stueydoins87
Member
Registered: 2019-04-19
Posts: 2

What Happened to the Table glpi_ticketfollowups

Hi all,

We have recently upgraded to GLPI 9.4.2 and I create a number of dashboards and utilities from the GLPI database. One of them was to do with followups and this is now failing as the table glpi_ticketfollowups doesn't seem to exist anymore!? I can see glpi_tickettasks but not followups?

Any help would be greatly appreciated smile

Regards

Offline

#2 2019-04-19 14:43:39

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,142

Re: What Happened to the Table glpi_ticketfollowups

tables is now called :
glpi_itilfollowups


Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

Online

#3 2019-04-19 14:53:38

stueydoins87
Member
Registered: 2019-04-19
Posts: 2

Re: What Happened to the Table glpi_ticketfollowups

Awesome! Thank you so much smile

Offline

#4 2019-07-26 05:25:47

fresnine
Member
Registered: 2019-07-26
Posts: 1

Re: What Happened to the Table glpi_ticketfollowups

thanks it works

Offline

#5 2019-08-22 13:31:50

pepeimpulso
Member
From: Spain
Registered: 2019-04-08
Posts: 14

Re: What Happened to the Table glpi_ticketfollowups

LaDenrée wrote:

tables is now called :
glpi_itilfollowups

Hello. Should I make any manual modification or apply a patch to correct the problem? I have the sql-errors.log that grows eternally with a bunch of errors to the fact that the glpi_ticketfollowups doesn't seem to exist anymore.

I'm running GLPI 9.4.3

Thanks.

Offline

#6 2019-08-22 14:05:39

pepeimpulso
Member
From: Spain
Registered: 2019-04-08
Posts: 14

Re: What Happened to the Table glpi_ticketfollowups

pepeimpulso wrote:
LaDenrée wrote:

tables is now called :
glpi_itilfollowups

Hello. Should I make any manual modification or apply a patch to correct the problem? I have the sql-errors.log that grows eternally with a bunch of errors to the fact that the glpi_ticketfollowups doesn't seem to exist anymore.

I'm running GLPI 9.4.3

Thanks.

I answer myself, which I don't know if it is a valid solution. I saw somewhere in this forum that maybe the problem was due to the fact of an error during the upgrade. I don't remember seeing anything.

What I did to start off is to create a view with the old table name and the ID field that should be called tickets_id. Here is the SQL that I run on MySQL

CREATE VIEW glpi_ticketfollowups_test AS
SELECT *, id as tickets_id FROM glpi_itilfollowups;

Offline

#7 2019-09-05 12:08:15

rreglpimc
Member
Registered: 2018-02-09
Posts: 95

Re: What Happened to the Table glpi_ticketfollowups

Hello, got the same error after upgrading to 9.4.3, appear when adding or editing a followup on any opened ticket.

glpisqllog.ERROR: DBmysql::query() in /var/www/glpi/inc/dbmysql.class.php line 188
  *** MySQL query error:
  SQL: SELECT DISTINCT `glpi_users`.`id` AS `users_id`, `glpi_users`.`language` AS `language` FROM `glpi_ticketfollowups` INNER JOIN `glpi_users` ON (`glpi_ticketfollowups`.`users_id` = `glpi_users`.`id`) INNER JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id`) WHERE (`glpi_profiles_users`.`entities_id` = '26' OR (`glpi_profiles_users`.`is_recursive` = '1' AND `glpi_profiles_users`.`entities_id` IN ('0'))) AND `glpi_ticketfollowups`.`id` = '34567'
  Error: Table 'glpi.glpi_ticketfollowups' doesn't exist
  Backtrace :
  inc/dbmysqliterator.class.php:95
  inc/dbmysql.class.php:580                          DBmysqlIterator->execute()
  ...otificationtargetcommonitilobject.class.php:483 DBmysql->request()
  ...otificationtargetcommonitilobject.class.php:840 NotificationTargetCommonITILObject->addFollowupAuthor()
  inc/notificationtarget.class.php:1123              NotificationTargetCommonITILObject->addSpecificTargets()
  inc/notificationeventabstract.class.php:91         NotificationTarget->addForTarget()
  inc/notificationevent.class.php:163                NotificationEventAbstract::raise()
  inc/itilfollowup.class.php:275                     NotificationEvent::raiseEvent()
  inc/commondbtm.class.php:1142                      ITILFollowup->post_addItem()
  front/itilfollowup.form.php:49                     CommonDBTM->add()
  {"user":"493@vslglpi1pr031","mem_usage":"0.013\", 3.92Mio)"}



Seems the files /var/www/glpi/inc/dbmysql.class.php call the wrong table (the files was logically updated with the package glpi 9.4.2 and the edit/build date of the files is 20 june 2019 @15h06

Should I manually edit this files ?

Offline

#8 2019-09-05 12:12:56

rreglpimc
Member
Registered: 2018-02-09
Posts: 95

Re: What Happened to the Table glpi_ticketfollowups

also there were no errors during migration.

Offline

#9 2019-09-05 12:13:17

pepeimpulso
Member
From: Spain
Registered: 2019-04-08
Posts: 14

Re: What Happened to the Table glpi_ticketfollowups

rreglpimc wrote:

Hello, got the same error after upgrading to 9.4.3, appear when adding or editing a followup on any opened ticket.

Should I manually edit this files ?

I solved the problem like I mentioned in my post.

Offline

#10 2019-09-05 12:28:36

rreglpimc
Member
Registered: 2018-02-09
Posts: 95

Re: What Happened to the Table glpi_ticketfollowups

after taking wiht my dba, we applied the same solution as pepeimpulso by adding a view :

CREATE VIEW glpi_ticketfollowups as select * from glpi_itilfollowups;

=> Seems to work correctly, no more errors in sql-errors.log when adding or editing followups.

Maybe there a fix on github but not being a developers i really don't understand how to find something on it.

Offline

Board footer

Powered by FluxBB