[Q&A] for key 'glpi_items_softwareversions.unicity' in C:\wamp64\www\glpi\src\DBmysql.php

[yoyohand]

Documentation & bug reporting acknowledgment

Yes, I read it

Describe your problem

Hello,

After updating my GLPI server to 10.0.6, I am migrating from fusion inventory 2.6 to GLPI Agent 1.4 on my computers.
On some workstations, the connection between the agent and the computer on GLPI is not made. After enabling debug, I get the following error:

[Mon Feb 6 15:16:40 2023][debug2] [http client] received message:

<br />
<font size='1'><table class='xdebug-error xe-fatal-error' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Duplicate entry 'Computer-1662-350724' for key 'glpi_items_softwareversions.unicity' in C:\wamp64\www\glpi\src\DBmysql.php on line <i>1969</i></th></tr>

On my php error log, I see this:

[06-Feb-2023 15:16:40 Europe/Paris] PHP Fatal error:  Duplicate entry 'Computer-1662-350724' for key 'glpi_items_softwareversions.unicity' in C:\wamp64\www\glpi\src\DBmysql.php on line 1969
[06-Feb-2023 15:16:40 Europe/Paris] PHP Stack trace:
[06-Feb-2023 15:16:40 Europe/Paris] PHP   1. {main}() C:\wamp64\www\glpi\plugins\glpiinventory\index.php:0
[06-Feb-2023 15:16:40 Europe/Paris] PHP   2. include_once() C:\wamp64\www\glpi\plugins\glpiinventory\index.php:45
[06-Feb-2023 15:16:40 Europe/Paris] PHP   3. include_once() C:\wamp64\www\glpi\plugins\glpiinventory\front\communication.php:72
<<.........>> (I erased the information from the collection) <<........>>
[06-Feb-2023 15:16:40 Europe/Paris] PHP  19. trigger_error($message = 'Duplicate entry \'Computer-1662-350724\' for key \'glpi_items_softwareversions.unicity\'', $error_level = 256) C:\wamp64\www\glpi\src\DBmysql.php:1969
[06-Feb-2023 14:17:10 UTC] PHP Parse error:  syntax error, unexpected '?', expecting function (T_FUNCTION) or const (T_CONST) in C:\wamp64\www\glpi\src\Features\Inventoriable.php on line 53

And for other positions, I have no error, the inventory works every time.
An idea?
Sorry for my english, Thanks for your help,

[leoetlea]

Hello, i have same problem.
GLPI server 10.0.6
i try with GLPI-Agent 1.4 and 1.5.
error
php-errors.log:[2023-02-10 14:47:07] glpiphplog.ERROR: *** PHP User Error (256): Duplicate entry 'Computer-1843-53225' for key 'glpi_items_softwareversions.unicity' in /var/www/html/sami/src/DBmysql.php at line 1969

it's OK for the first computer agent , all software comes to GLPI and the agent link on computer is OK.
But at the second no software import and no link on computer for agent. And no increase for counter for all second computer software.

It seem a bug.
Best regards

[g-bougard]

This anyway seems to be a server-side issue.
Check glpi project issues, maybe one matches your problem and check if a fix has still been prepared.

[leoetlea]

Tanks.
I Am agree is server-side issue.
I found solution with glpi-project/glpi#14016
I replace all src/Inventory dir 10.0.06 with 10.0.5 dir src/Inventory

But what else in next release ?

For me is a temporaire solution.

To be continu.

[yoyohand]

Hello,

I try this morning this solution, it's work.
For me too, it's temporary solution but replace folder let it work again inventory/

Thank you for your reply ;)

[leoetlea]

Hello,
i go back to the 10.0.06 dir and i just replace the file software.php with 10.0.05 file Software.php.

And i have no problem.

Thanks.