Forum GLPI-Project

gradinaruvasile

Member

Registered: 2018-03-20

Posts: 7

Upgraded to 10.0.9, cannot install glpiinventory plugin

Recently we upgraded from 9.5.7 to 10.0.9 and i need the glpiinventory plugin's functionality (deploy).
I downloaded and extracted the installer, it shows up on the plugins list, but if i click the install button, it shows a list of actions related to db updates and it stops there with an error if i am in debug mode.
In the database i see populated tables with the name of "glpi_plugin_glpiinventory_whatever", migrated stuff from fusion inventory (i had fusion inventory plugin there first time i tried it).
https://imgur.com/a/pDLZRwB

After clicking in the install button, in debug mode i see this:

https://imgur.com/BYwrbS1

This is the error code on the bottom:

SQL Error "1054": Unknown column 'taskjob.restrict_to_task_entity' in 'field list' in query "SELECT `task`.*, `taskjob`.`id` AS `taskjob_id`, `taskjob`.`plugin_glpiinventory_tasks_id` AS `taskjob_plugin_glpiinventory_tasks_id`, `taskjob`.`entities_id` AS `taskjob_entities_id`, `taskjob`.`name` AS `taskjob_name`, `taskjob`.`date_creation` AS `taskjob_date_creation`, `taskjob`.`method` AS `taskjob_method`, `taskjob`.`targets` AS `taskjob_targets`, `taskjob`.`actors` AS `taskjob_actors`, `taskjob`.`comment` AS `taskjob_comment`, `taskjob`.`rescheduled_taskjob_id` AS `taskjob_rescheduled_taskjob_id`, `taskjob`.`statuscomments` AS `taskjob_statuscomments`, `taskjob`.`enduser` AS `taskjob_enduser`, `taskjob`.`restrict_to_task_entity` AS `taskjob_restrict_to_task_entity` FROM `glpi_plugin_glpiinventory_tasks` AS `task` LEFT JOIN `glpi_plugin_glpiinventory_taskjobs` AS `taskjob` ON (`task`.`id` = `taskjob`.`plugin_glpiinventory_tasks_id`) WHERE (`task`.`is_active` = '1') AND ( NOT (`taskjob`.`id` IS NULL)) AND (((`taskjob`.`targets` LIKE '%"PluginGlpiinventoryDeployPackage":"3"%')))"

There is no column restrict_to_task_entity.glpi_plugin_glpiinventory_tasks in the database.
Where can i look for further data? I have a test env that updated fine but that did not have the fusioninventory plugin anymore.

gradinaruvasile

Member

Registered: 2018-03-20

Posts: 7

Re: Upgraded to 10.0.9, cannot install glpiinventory plugin

So i looked around and it seems the 'restrict_to_task_entity' column was missing from the 'glpi_plugin_glpiinventory_tasks' table.
I had a test server set up previously, that one had it. The actual production server did not had it created for some reason.
I created the column with the format from the test server's database and the plugin works now.