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 2018-01-12 12:03:07

Sgs
Guest
Registered: 2016-02-02
Posts: 4

Wrong operating systems link automatically created during update 9.2.1

Hi,

After updating from 9.1.6 to 9.2.1 it automatically have created on several computers a new entry in the "operating system" adding a second link to another OS. for example, I have a windows server 2018 R2 that now also have CentOS in the Operating system list.

I've tried to select the wrong entry and press "Delete permanently the relation with selected items" but it does nothing. It shows Operation successful on the bottom but it does not get deleted. If I go to historically it says first "Operating system    Add a link with an item: CentOS (46) at the time I did the version update and latter when I tried to delete the link it says "Operating system    Lock a link with an item: CentOS (46)".

I did not get any error during the version upgrade but I guess this was caused by some errors I have on my database as this glpi installation was originally 0.84 updated to 9.1 and latter to 9.1.6.

I have the fusioninventory plugin installed but the actions from the history where done under my user, not the fusion inventory.

I've been looking arround the SQL database and I can see that in the table "glpi_items_operatingsystems" two entries have been created for some servers

mysql> SELECT *  FROM `glpi_items_operatingsystems`  WHERE `itemtype` = 'Computer' AND `items_id` = 411;
+------+----------+----------+---------------------+----------------------------+--------------------------------+---------------------------------+----------------------------------+----------------+-------------------------+----------------------------+---------------------+---------------------+------------+------------+-------------+--------------+
| id   | items_id | itemtype | operatingsystems_id | operatingsystemversions_id | operatingsystemservicepacks_id | operatingsystemarchitectures_id | operatingsystemkernelversions_id | license_number | license_id              | operatingsystemeditions_id | date_mod            | date_creation       | is_deleted | is_dynamic | entities_id | is_recursive |
+------+----------+----------+---------------------+----------------------------+--------------------------------+---------------------------------+----------------------------------+----------------+-------------------------+----------------------------+---------------------+---------------------+------------+------------+-------------+--------------+
|  408 |      411 | Computer |                  44 |                         68 |                              4 |                               1 |                              111 |                | 55041-262-1086132-84779 |                          0 | NULL                | NULL                |          0 |          0 |           0 |            0 |
| 1523 |      411 | Computer |                  46 |                         85 |                              0 |                               2 |                              582 | NULL           | NULL                    |                          0 | 2018-01-10 09:44:11 | 2018-01-10 09:44:11 |          0 |          1 |           0 |            0 |
+------+----------+----------+---------------------+----------------------------+--------------------------------+---------------------------------+----------------------------------+----------------+-------------------------+----------------------------+---------------------+---------------------+------------+------------+-------------+--------------+

Any idea how to fix this? Can I do some pre-task before the update to 9.2.1 to fix this?

Last edited by Sgs (2018-01-12 12:23:47)

Offline

#2 2018-01-15 08:16:04

yustas
Guest
Registered: 2018-01-11
Posts: 4

Re: Wrong operating systems link automatically created during update 9.2.1

+1. the same qestion

Offline

Board footer

Powered by FluxBB