Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

plugin generates phperrors in phplogfile : Invalid relations declared for "glpi_ticketcategories" table. #123

Open
ladenree76000 opened this issue Jul 7, 2023 · 3 comments

Comments

@ladenree76000
Copy link

ladenree76000 commented Jul 7, 2023

  • Version of the plugin : 3.0.8

  • Version of your GLPI : 10.0.8 + glpi-agent 1.4
    it happens on 2 configs :
    GLPI10.0.8 (ubuntu 22.04 PHP8.1 Mariadb10.6)
    Glpi 10.0.7 / IIS (w2012r2) / Php 8.1.7 / MariaDB 10.5.4

  • Steps to reproduce (which actions have you made) :
    install plugin .
    wait for some glpi-agent to update computer (it looks like if inventory triggers the error message)
    look php error log

  • Expected result :
    plugin should not return error message

  • Actual result :
    [2023-07-06 11:15:59] glpiphplog.WARNING: *** PHP User Warning (512): Invalid relations declared for "glpi_ticketcategories" table. Table does not correspond to a known itemtype. in /var/www/glpi/src/DbUtils.php at line 2032
    Backtrace :
    src/DbUtils.php:2032 trigger_error()
    inc/db.function.php:585 DbUtils->getDbRelations()
    src/CommonDBTM.php:866 getDbRelations()
    src/CommonDBTM.php:788 CommonDBTM->cleanRelationData()
    src/CommonDBTM.php:2064 CommonDBTM->deleteFromDB()
    src/CommonDBTM.php:4610 CommonDBTM->delete()
    src/Inventory/Asset/MainAsset.php:783 CommonDBTM->deleteByCriteria()
    src/RuleImportAsset.php:969 Glpi\Inventory\Asset\MainAsset->rulepassed()
    src/Rule.php:1525 RuleImportAsset->executeActions()
    src/RuleCollection.php:1625 Rule->process()
    src/Inventory/Asset/MainAsset.php:575 RuleCollection->processAllRules()
    src/Inventory/Inventory.php:710 Glpi\Inventory\Asset\MainAsset->handle()
    src/Inventory/Inventory.php:341 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()
    public/index.php:73 require()

  • URL of the page :
    this happens silently

  • Screenshot of the problem (if pertinent) :
    more infos on glpi's forum https://forum.glpi-project.org/viewtopic.php?id=287368

it stops when plugin is deactivated

@Giudy
Copy link

Giudy commented Aug 29, 2023

I can confirm the issue with glpi 10.0.9 and plugin 3.0.4

@NeueMedienBecker
Copy link

can confirm the problem

[2023-10-12 08:40:44] glpiphplog.WARNING: *** PHP User Warning (512): Invalid relations declared for "glpi_ticketcategories" table. Table does not correspond to a known itemtype. in /home/users/glpi/www/src/DbUtils.php at line 2064
Backtrace :
src/DbUtils.php:2064 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:865 RuleMatchedLog->cleanOlddata()
src/RuleImportAsset.php:969 Glpi\Inventory\Asset\MainAsset->rulepassed()
src/Rule.php:1533 RuleImportAsset->executeActions()
src/RuleCollection.php:1640 Rule->process()
src/Inventory/Asset/MainAsset.php:574 RuleCollection->processAllRules()
src/Inventory/Inventory.php:722 Glpi\Inventory\Asset\MainAsset->handle()
src/Inventory/Inventory.php:353 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:332 Glpi\Inventory\Request->handleAction()
src/Agent/Communication/AbstractRequest.php:269 Glpi\Agent\Communication\AbstractRequest->handleXMLRequest()
front/inventory.php:94 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()

GLPI 10.0.10

@Rom1-B
Copy link

Rom1-B commented Jan 24, 2024

@tsmr has already corrected the case on the master branch, but this is not included in version 3.0.4.

You just need to comment this line to get rid of the warning:

image

9c68b5d

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants