problème de version d'OS suite à màj Glpi+FI

[cedric677]

bonjour,

suite aux dernières màj Glpi et FusionInventory, j'ai des soucis avec les versions d'OS
certains postes sont doublés à cause d'une 2 version d'OS qui est généré mais je ne sais pas d'où vient l'info qui est erroné :

avez-vous une idée svp ?

[trasher]

See #2347 maybe

[cedric677]

I don't find where is the issue in this link
I'm sorry, i'm newbie with Github's forums

[trasher]

This one is a pull request (a fix proposal), not a n issue. Check 'files changed' tab to see the fix.

[cedric677]

Ok, i did the modifications into the file and uploaded into my FTP
I think i have to wait the next inventory of a computer which is concerned ?
Thanks

[cedric677]

Anyone ?

[ddurieux]

You need check the import rules, if you have 2 same computer, it's a problem with import rules

[cedric677]

Import rules hadn't change since update

[keyser75000]

It seems exactly the same problem we describe here : http://forum.glpi-project.org/viewtopic.php?id=159402.
Two ways to check it :

• Entries are duplicated in computers list (but it's the same computer => same id)
• We see two OS in Operating System Tab.

It happens after fusioninventory plugin migration from 9.1.x to 9.2.

[cedric677]

yes thanks, but it not indicates a way to solve this problem

[hartois]

I confirm this problem with Fusioninventory 9.2+1.0 after migration:

This computer never have AskaLinux or Windows.

[Rico29]

I confirm it too

[wawax]

Hello,

this has already been fixed. We're working on a plugin update for the coming days.

Thank you.

[cedric677]

Very nice, thank you :)

[cedric677]

Hi, no news about this update please ?

[cedric677]

Hi,
I found new patch for FusionInv and installed it
But now, some computers appeared 3 times :(

Is there any correction to do in database please ?
Thanks

[wawax]

Please try version 9.2+.2.0-RC1 that have just been released

[cedric677]

Yes, i tryed this patch yesterday and i have some computers which appears 3 times now

[cedric677]

[trasher]

The fix will prevent extra OS to be created; but this will not clean wrong existing data.

Take a look at glpi_items_operatingsystems and try to drop wrong entries (mostly, ones that does not have any arch, or version).

[trasher]

You should find duplicates using:

SELECT id FROM glpi_items_operatingsystems group by items_id having count(items_id) > 1

And you should be able to clean duplicates using (backup your database before trying that):

DELETE FROM glpi_items_operatingsystems
WHERE items_id IN (SELECT * FROM(SELECT items_id FROM glpi_items_operatingsystems as ios group by items_id having count(items_id) > 1) as ios2)
AND operatingsystemarchitectures_id = 0

[cedric677]

Thank you for this codes
I tested it and 30 rows have been deleted but the problem persists :/

Can i delete all the rows ?
OS will automatically update with FusionInventory no ?

[cedric677]

I found 67 computers which have duplicated OS
It's not a big work at all, i will delete rows manually , thank you 👍

[trasher]

Yes, if you delete all rows; they'll be created again on the next inventory; but everyone cannot drop all entries (especially on big databases).

The screenshot you've provided seems to be a search result; and results may be incorrect as well... Just to be sure: for one computer, you had 2 (or more) operating systems listed. When you run the "delete" query, only one should remain. Is that point OK?

[cedric677]

Some times i have 3 OS listed by computer :

I tryed to delete the 2 rows which have the bigger id and the right OS seems to be conserved