Forum GLPI-Project

megabrain

Member

Registered: 2005-06-03

Posts: 35

Trouble with change internal devices

I've posted it as a bug, but maby someone meet same problem and have the "cure" for it

GLPI ver 6.0-RC2
While I trying to hange or delete internal device in computer view, it returns to empty computers grid, but I still can add a new internsl device. Anyone meet this problem yet ?

Greetings

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: Trouble with change internal devices

Please try with the CVS version and tell me what

http://cvs.gna.org/daily/glpi-snapshot.tar.gz

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

megabrain

Member

Registered: 2005-06-03

Posts: 35

Re: Trouble with change internal devices

I am afraid it doesn't work too - the same problem here. Because it is added debug info, ill post it here :

First I select desired computer :

TIME
0.153s
POST VARIABLE
GET VARIABLE
ID => 703

SESSION VARIABLE
dict => english
Test_session_GLPI => 1
glpiID => 6
glpipass => ******************************
glpiname => august
glpirealname => Krzysztof Augustyn
glpitype => super-admin
glpilanguage => english
tracking_order => no
authorisation => 1
extauth => 0
glpisearchcount => 1
glpi_onglet => 1

SQL REQUEST
Number of request: 26

Total Time: 0.015s

--------------------------------------------------------------------------------
N° 1 :
select ID
FROM glpi_computers
WHERE ID > 703 AND deleted='N'AND is_template='0'
ORDER BY ID
Time: 0.001s
--------------------------------------------------------------------------------
N° 2 :
select ID
FROM glpi_computers
WHERE ID < 703 AND deleted='N'AND is_template='0'
ORDER BY ID DESC
Time: 0.009s
--------------------------------------------------------------------------------
N° 3 :
SELECT *
FROM glpi_computers
WHERE (ID = '703') limit 0,1
Time: 0.001s
--------------------------------------------------------------------------------
N° 4 :
SELECT ID, device_type, FK_device, specificity
FROM glpi_computer_device
WHERE (FK_computers = '703')
ORDER BY device_type
Time: 0.001s
--------------------------------------------------------------------------------
N° 5 :
SELECT ID, name
FROM glpi_type_computers
WHERE '1'='1'
ORDER BY name
Time: 0.000s
--------------------------------------------------------------------------------
N° 6 :
SELECT ID, completename as name
FROM glpi_dropdown_locations
WHERE '1'='1'
ORDER BY completename
Time: 0.001s
--------------------------------------------------------------------------------
N° 7 :
SELECT ID, name
FROM glpi_dropdown_network
WHERE '1'='1'
ORDER BY name
Time: 0.000s
--------------------------------------------------------------------------------
N° 8 :
SELECT ID, name
FROM glpi_dropdown_model
WHERE '1'='1'
ORDER BY name
Time: 0.000s
--------------------------------------------------------------------------------
N° 9 :
SELECT ID, name
FROM glpi_dropdown_domain
WHERE '1'='1'
ORDER BY name
Time: 0.000s
--------------------------------------------------------------------------------
N° 10 :
SELECT *
FROM glpi_users
WHERE ( type ='super-admin' || type ='admin' || type ='normal')
ORDER BY name
Time: 0.001s
--------------------------------------------------------------------------------
N° 11 :
SELECT ID, name
FROM glpi_enterprises
WHERE '1'='1'
ORDER BY name
Time: 0.001s
--------------------------------------------------------------------------------
N° 12 :
SELECT *
FROM glpi_enterprises
WHERE (ID = '0')
Time: 0.000s
--------------------------------------------------------------------------------
N° 13 :
SELECT *
FROM glpi_state_item
WHERE (device_type='1' AND id_device = '703' AND is_template='0' )
Time: 0.000s
--------------------------------------------------------------------------------
N° 14 :
SELECT *
FROM glpi_computers
WHERE (ID = '703') limit 0,1
Time: 0.000s
--------------------------------------------------------------------------------
N° 15 :
SELECT ID, device_type, FK_device, specificity
FROM glpi_computer_device
WHERE (FK_computers = '703')
ORDER BY device_type
Time: 0.000s
--------------------------------------------------------------------------------
N° 16 :
SELECT ID, name
FROM glpi_dropdown_state
WHERE '1'='1'
ORDER BY name
Time: 0.000s
--------------------------------------------------------------------------------
N° 17 :
SELECT ID, name
FROM glpi_dropdown_os
WHERE '1'='1'
ORDER BY name
Time: 0.000s
--------------------------------------------------------------------------------
N° 18 :
select *
FROM glpi_reservation_item
WHERE (device_type='1' and id_device='703')
Time: 0.000s
--------------------------------------------------------------------------------
N° 19 :
SELECT *
FROM glpi_computers
WHERE (ID = '703') limit 0,1
Time: 0.000s
--------------------------------------------------------------------------------
N° 20 :
SELECT ID, device_type, FK_device, specificity
FROM glpi_computer_device
WHERE (FK_computers = '703')
ORDER BY device_type
Time: 0.000s
--------------------------------------------------------------------------------
N° 21 :
SELECT *
FROM glpi_device_hdd
WHERE (ID = '20') limit 0,1
Time: 0.000s
--------------------------------------------------------------------------------
N° 22 :
select *
FROM glpi_dropdown_hdd_type
WHERE ID = '1'
Time: 0.000s
--------------------------------------------------------------------------------
N° 23 :
SELECT *
FROM glpi_device_hdd
WHERE (ID = '16') limit 0,1
Time: 0.000s
--------------------------------------------------------------------------------
N° 24 :
select *
FROM glpi_dropdown_hdd_type
WHERE ID = '1'
Time: 0.000s
--------------------------------------------------------------------------------
N° 25 :
SELECT *
FROM glpi_device_iface
WHERE (ID = '3') limit 0,1
Time: 0.000s
--------------------------------------------------------------------------------
N° 26 :
SELECT *
FROM glpi_device_iface
WHERE (ID = '31') limit 0,1
Time: 0.000s

And i try to updare internal device (devicevalue_1094 => 80 GB
) :

TIME
0.121s
POST VARIABLE
devicevalue_1091 => 40 GB
devicevalue_1094 => 80 GB
devicevalue_1092 => 00:04:75:D8:42:C7
devicevalue_1093 => 00:0A:5E:1B:42:2A
update_device_x => 8
update_device_y => 5

GET VARIABLE
SESSION VARIABLE
dict => english
Test_session_GLPI => 1
glpiID => 6
glpipass => 288bc223553a1374b0224fd3af7eea25
glpiname => august
glpirealname => Krzysztof Augustyn
glpitype => super-admin
glpilanguage => english
tracking_order => no
authorisation => 1
extauth => 0
glpisearchcount => 1
glpi_onglet => 1

SQL REQUEST
Number of request: 1

Total Time: 0s

--------------------------------------------------------------------------------
N° 1 :
SELECT *
FROM glpi_computers
WHERE (ID = '') limit 0,1
Time: 0.000s

Afrer update button it show debug report like this, but screen is empty (it doesn;t show any computer), and after search again this computer the device is unchanged -in this case device_id=16

If you need any more info - just say a word
And thank you for your great work people - outstanding IRM system !

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: Trouble with change internal devices

I don't understand it works for me.

I can add, delete, update internal device.

Please give me a maximum of information about  the configuration you use.

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

megabrain

Member

Registered: 2005-06-03

Posts: 35

Re: Trouble with change internal devices

Hmm, I wondering one thing - for utf enabled database, i've updated mysql to development relase 5.0.10, so maby it is my problem. I try back to 4.0.25 and then to 4.1.13 relases and check it. I'll post results soon

EDIT 1 :
after reemrge mysql 4.1.13, situation doesn't change, I still can't change intenal devices in computers. Now I'll try mysql 4.0.25

EDIT 2:
with 4.0.25 it is the same problem Now I don't have idea what kind of problem it is

I can provide any info about my config, just say what you need to look at and where post this info

Last edited by megabrain (2005-08-25 13:27:25)

megabrain

Member

Registered: 2005-06-03

Posts: 35

Re: Trouble with change internal devices

Find a clue ..
With firefox it works lika a charm but with IE (or maxton) it doesn't. For now i think i change web browser till somebody confirm that is it, and eventually solve problem.

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: Trouble with change internal devices

I will try also on evening.

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

emir

Member

Registered: 2005-09-15

Posts: 3

Re: Trouble with change internal devices

Hi,
so far I have also had this problem with IE, but FireFox works like a charm. I think it might be a form posting problem, since there's only one form for the whole delete/update of the internal devices. Before 0.6 every button had it's own form and hidden value.

greetings,

Emir

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: Trouble with change internal devices

Correct in the CVS.

available tomorrow in the daily tarball

---

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