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 2014-11-18 12:30:37

TySu
Member
Registered: 2014-03-04
Posts: 32

[GLPI 0.85, 0.84.6] Assets are updated after being disconected

Server: Ubuntu Server 14.x, PHP 5.3.10-1ubuntu3.15 with Sushosin-Patch (cli), Apache 2.2.22, MySQL 5.5.4.
GLPI Version: 0.85, 0.84.8
OCS NG Plugin: Yes, version 1.0.3

I have 1 computer and two monitors connected to it. After I'll disconnect monitors from PC and then update "User" field the same change is applied to monitors. It shouldn't work like that. After items being disconnected from each other changes in one asset shouldn't be propagated to other assets (even if they were connected in past).

EDIT:
I've noticed that if I will trigger "Disconnect" the row in appropriate table is not deleted.

Last edited by TySu (2014-12-03 21:06:21)

Offline

#2 2014-11-19 11:02:18

TySu
Member
Registered: 2014-03-04
Posts: 32

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected

How those two assets are connected in database maybe we are able to disconnect them in DB so we can avoid this kind of problems?

Offline

#3 2014-11-28 20:24:01

TySu
Member
Registered: 2014-03-04
Posts: 32

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected

Any clue why it happens?

Offline

#4 2014-12-01 22:09:09

TySu
Member
Registered: 2014-03-04
Posts: 32

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected

It's quite big blocker for me at the moment. Any ideas?

Offline

#5 2014-12-09 22:30:13

TySu
Member
Registered: 2014-03-04
Posts: 32

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected

It seems that only solution for now is to remove rows from glpi_computers_items (it seems that this table contains only 1:N between PCs and monitors/devices, no triggers).

After disconnecting rows in that table aren't removed only flag is deleted is set up what causes updating monitors data along with computer.

If I connect monitors again and disconnect them then rows are removed.

Last edited by TySu (2014-12-09 22:30:29)

Offline

#6 2014-12-11 16:59:51

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#7 2014-12-11 17:03:14

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#8 2014-12-12 19:49:52

TySu
Member
Registered: 2014-03-04
Posts: 32

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected

I'll have to test it (restore DB and set up GLPI).

Offline

#9 2015-06-23 07:24:53

TySu
Member
Registered: 2014-03-04
Posts: 32

Re: [GLPI 0.85, 0.84.6] Assets are updated after being disconected

Seems to be working as assumed smile.

Offline

Board footer

Powered by FluxBB