Forum GLPI-Project

mps

Member

Registered: 2022-10-04

Posts: 32

Can't add new answers or tasks to ticket; existing tasks are missing

Hello!

After upgrading from 10.0.7 to 10.0.8 we have a big issue which breaks the ticket functionality. No new item kann be added to a ticket. Regardless of the type. After submitting the new answer or task, the page is reloaded but the new entry is not saved. Strange enough, also existing tasks are also missing in the timeline.

Seems there must be an issue with database. During the migration scripts there was an error which could be solved using the workaround from github #15045: "10.0.8 dev : The shema differs for table "glpi_queuednotifications when i execute php bin/console database:check_schema_integrity · Issue #15045 · glpi-project/glpi"

Issue is posted on github: issues #15173

We see a lot of database related errors in php-errors.log

[2023-07-10 09:57:40] glpiphplog.WARNING:   *** PHP User Warning (512): Invalid relations declared for "glpi_plugin_accounts_accountstates" table. Target table "glpi_plugin_accounts_mailingstates" does not correspond to a known itemtype. in /u01/glpi/html/src/DbUtils.php at line 2111
  Backtrace :
  src/DbUtils.php:2111                               trigger_error()
  inc/db.function.php:585                            DbUtils->getDbRelations()
  src/CommonDBTM.php:866                             getDbRelations()
  src/CommonDBTM.php:788                             CommonDBTM->cleanRelationData()
  src/CommonDBTM.php:2068                            CommonDBTM->deleteFromDB()
  src/RuleMatchedLog.php:183                         CommonDBTM->delete()
  src/Inventory/Asset/MainAsset.php:861              RuleMatchedLog->cleanOlddata()
  src/RuleImportAsset.php:969                        Glpi\Inventory\Asset\MainAsset->rulepassed()
  src/Rule.php:1525                                  RuleImportAsset->executeActions()
  src/RuleCollection.php:1640                        Rule->process()
  src/Inventory/Asset/MainAsset.php:573              RuleCollection->processAllRules()
  src/Inventory/Inventory.php:709                    Glpi\Inventory\Asset\MainAsset->handle()
  src/Inventory/Inventory.php:340                    Glpi\Inventory\Inventory->handleItem()
  src/Inventory/Request.php:360                      Glpi\Inventory\Inventory->doInventory()
  src/Inventory/Request.php:90                       Glpi\Inventory\Request->inventory()
  src/Agent/Communication/AbstractRequest.php:359    Glpi\Inventory\Request->handleAction()
  src/Agent/Communication/AbstractRequest.php:271    Glpi\Agent\Communication\AbstractRequest->handleJSONRequest()
  front/inventory.php:92                             Glpi\Agent\Communication\AbstractRequest->handleRequest()
  ...tplace/glpiinventory/front/communication.php:72 include_once()
  marketplace/glpiinventory/index.php:45             include_once()
  public/index.php:82                                require() 
 

Last edited by mps (2023-07-10 10:11:21)

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,811

Website

Re: Can't add new answers or tasks to ticket; existing tasks are missing

It looks like an issue with the Accounts plugin.
You may want to report the bug on their GitHub.
https://github.com/InfotelGLPI/accounts

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.

mps

Member

Registered: 2022-10-04

Posts: 32

Re: Can't add new answers or tasks to ticket; existing tasks are missing

Problem is solved with the PR github.com/glpi-project/glpi/pull/15138

anis002

Member

Registered: 2023-09-06

Posts: 8

Re: Can't add new answers or tasks to ticket; existing tasks are missing

Hello, are you sure that the PR you mentioned has resolved the issue? I'm currently experiencing the same problem with GLPI 10.0.10

Last edited by anis002 (2023-10-13 09:52:42)

Tofz80

Member

Registered: 2023-12-12

Posts: 3

Re: Can't add new answers or tasks to ticket; existing tasks are missing

Hi

I have the same problem with GPI 10.0.11

---

GLPI 10.0.11
Debian 12 / PHP 8.3