WARNING: *** PHP Warning (2): Undefined array key

[tattami]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

GLPI Version

10.0.11

Plugin version

1.5.3

Bug description

Help me understand why the error occurs and how to fix it, please
Here is a screenshot of the table if needed: https://prnt.sc/uYNZKTTe6Pnv

Relevant log output

[2025-05-21 13:39:01] glpiphplog.WARNING:   *** PHP Warning (2): Undefined array key "id" in /var/www/glpi/marketplace/glpiinventory/inc/taskview.class.php at line 860
  Backtrace :
  marketplace/glpiinventory/inc/task.class.php:635   PluginGlpiinventoryTaskView->prepareTaskjobs()
  src/CronTask.php:1027                              PluginGlpiinventoryTask::cronTaskscheduler()
  front/cron.php:87                                  CronTask::launch()
 ------------------
[2025-05-21 13:49:02] glpisqllog.ERROR: DBmysql::doQuery() in /var/www/glpi/src/DBmysql.php line 403
  *** MySQL query error:
  SQL: INSERT INTO `glpi_plugin_glpiinventory_taskjobstates` (`state`, `itemtype`, `items_id`, `plugin_glpiinventory_taskjobs_id`, `agents_id`, `uniqid`) VALUES ('0', 'Printer', '177', NULL, '302', '682daf9e7c619')
  Error: Column 'plugin_glpiinventory_taskjobs_id' cannot be null
  Backtrace :
  src/DBmysql.php:1380                               DBmysql->doQuery()
  src/CommonDBTM.php:729                             DBmysql->insert()
  src/CommonDBTM.php:1342                            CommonDBTM->addToDB()
  ...tplace/glpiinventory/inc/taskview.class.php:944 CommonDBTM->add()
  marketplace/glpiinventory/inc/task.class.php:635   PluginGlpiinventoryTaskView->prepareTaskjobs()
  src/CronTask.php:1027                              PluginGlpiinventoryTask::cronTaskscheduler()
  front/cron.php:87                                  CronTask::launch()
  {"user":"@glpi","mem_usage":"0.002\", 19.16Mio)"}

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

[trasher]

SHould be fixed with #696 Doesn't work.

This code part is covered from unit tests, I have no idea how to reproduce.

[stonebuzz]

Hi @tattami

Could you please check if each of your tasks has at least one associated job? I have the impression that, when the plugin retrieves the tasks, there is at least one task without any associated job.

[tattami]

Hi @tattami

Could you please check if each of your tasks has at least one associated job? I have the impression that, when the plugin retrieves the tasks, there is at least one task without any associated job.

Everything is there, but the plugin still can't get Id, now temporarily made an assignment of id through the database trigger. This error occurs only when automatically launched, when manually forcing it, there is no such thing.

[trasher]

Seems like there is an issue in your database data; and this may come from an older version, a bug during any update, ... Difficult to say. The real issue may be fixed already.
In order to propose a fix, we need a way to reproduce from a fresh install since we do not have (obviously) your data.

[ffreu]

We had a similar problem that might be related. It prevented querying of deployment tasks:

glpiphplog.WARNING: *** PHP Warning (2): Undefined array key "json" in /var/www/html/glpi/marketplace/glpiinventory/inc/deploycommon.class.php at line 334 Backtrace : marketplace/glpiinventory/b/deploy/index.php:93 PluginGlpiinventoryDeployCommon->run() public/index.php:82 require()

The underlying issue was that we had at some point deleted a deploy package but some tasks that referenced it still existed. One of those tasks wasn't even showing in the GUI anymore but still appeared in the database.

We were able to fix the issue by manually deleting the relevant entries in glpi_plugin_glpiinventory_tasks, glpi_plugin_glpiinventory_taskjobs and glpi_plugin_glpiinventory_taskjobstates.

@tattami Do you perhaps also have some references in glpi_plugin_glpiinventory_taskjobs.targets that point to no longer existing entries?