caractére étranges dans le mode debug de glpi

jm.cierniewski · 2006-04-20 17:03:02

salut ,
quand je suis en mode debug, j'ai des problémes de caractéres dans le mode debug en lui méme
pour information, j'ai effectué une maj d'ocs, et je sais qu'au départ, les tables étaient en swidich

SERVEUR_SQL => localhost
COMPTE_BASE => ocs
PSWD_BASE => ocs
SERVER_READ => localhost
SERVER_WRITE => localhost
langueFich => languages/french.txt
writeServer => 0
readServer => 0
availFieldList => Array
h.ipaddr => Adresse IP
h.processors => CPU(MHz)
h.lastdate => Dernier inventaire
lastcome => Derni貥 visite
h.description => Description
h.workgroup => Domaine
a.Etat => Etat
b.smanufacturer => Fabricant
b.bmanufacturer => Fabricant du BIOS
h.fidelity => Fid鬩t鼢r> h.name => Machine
b.smodel => Mod謥
h.processorn => Nombre de processeurs
b.ssn => Num鲯 de s鲩e
h.winowner => Propri鴡ire
h.quality => Qualit鼢r> h.memory => Ram(MO)
h.oscomments => Service pack
h.wincompany => Soci鴩
h.swap => Swap
h.osname => Syst譥
h.useragent => Type d'agent

MoYo · 2006-04-20 17:22:26

heu c'est la session OCS qu'il affiche pas celle de GLPI là

jm.cierniewski · 2006-04-20 17:24:57

ba ptetre, j'avais bien lu OCS, mais chui dans le mode debug de glpi.....

jm.cierniewski · 2006-04-20 17:26:47

en mode debug sur la fenetre d'inventaire des machines ça donne ça...

GLPI MODE DEBUG
TIME
0.146s
POST VARIABLE
GET VARIABLE
start => 0
order => ASC
deleted => Y
distinct => N
link => Array
field => Array
                    0 => view
contains => Array
                    0 => 
link2 => Array
field2 => Array
                    0 => view
contains2 => Array
                    0 => 
type2 => 
sort => 1

SESSION VARIABLE
SERVEUR_SQL => localhost
COMPTE_BASE => ocs
PSWD_BASE => ocs
SERVER_READ => localhost
SERVER_WRITE => localhost
langueFich => languages/french.txt
writeServer => 0
readServer => 0
availFieldList => Array
                    h.ipaddr => Adresse IP
                    h.processors => CPU(MHz)
                    h.lastdate => Dernier inventaire
                    lastcome => Derni&#36005; visite
                    h.description => Description
                    h.workgroup => Domaine
                    a.Etat => Etat
                    b.smanufacturer => Fabricant
                    b.bmanufacturer => Fabricant du BIOS
                    h.fidelity => Fid&#39721;t&#40738;r>                    h.name => Machine
                    b.smodel => Mod&#35621;
                    h.processorn => Nombre de processeurs
                    b.ssn => Num&#40111; de s&#40105;e
                    h.winowner => Propri&#40225;ire
                    h.quality => Qualit&#40738;r>                    h.memory => Ram(MO)
                    h.oscomments => Service pack
                    h.wincompany => Soci&#40233;
                    h.swap => Swap
                    h.osname => Syst&#35685;
                    h.useragent => Type d'agent
                    h.processort => Type de processeur
                    h.userid => Utilisateur
                    b.bversion => Version BIOS
                    h.osversion => Version du syst&#35685;
currentFieldList => Array
                    h.lastdate => Dernier inventaire
                    h.name => Machine
                    h.userid => Utilisateur
                    h.osname => Syst&#35685;
                    h.memory => Ram(MO)
loggeduser => admin
lvluser => 1
pcparpage => 100
pageCur => 1
first => 1
query => SELECT a.TAG AS "Tag",h.deviceid, h.lastdate AS "Dernier inventaire", h.name AS "Machine", h.userid AS "Utilisateur", h.osname AS "Syst&#35685;", h.memory AS "Ram(MO)" FROM hardware h,accountinfo a,bios b WHERE a.deviceid=h.deviceid AND b.deviceid=h.deviceid GROUP BY h.deviceid
queryC => SELECT COUNT(h.deviceid) FROM hardware h,accountinfo a WHERE a.deviceid=h.deviceid 
lareq => Toutes les machines
c => 3
glpiID => 7
glpipass => d41d8cd98f00b204e9800998ecf8427e
glpiname => e_jmcier
glpirealname => Jean-marc CIERNIEWSKI
glpitype => super-admin
glpilanguage => french
glpitracking_order => no
glpiauthorisation => 1
glpiextauth => 1
glpisearchcount => Array
                    1 => 1
                    13 => 1
glpisearchcount2 => Array
                    1 => 0
                    13 => 0
glpiroot => /glpi
glpilist_limit => 30
glpisearch => Array
                    1 => Array
                                        contains => Array
                                                            0 => 
                                        field => Array
                                                            0 => view
                                        sort => 1
                                        deleted => Y
                                        start => 0
search => 
all => 
rg => 0
lareqpages => Toutes les machines
glpi_onglet => -1

SQL REQUEST
Number of request: 4

Total Time: 0.021s


--------------------------------------------------------------------------------
N° 1 : 
SELECT * 
FROM glpi_display 
WHERE type='1' 
ORDER BY rank
Time: 0.002s
--------------------------------------------------------------------------------
N° 2 : 
SELECT count(ID) 
FROM glpi_computers 
WHERE glpi_computers.deleted='Y' AND glpi_computers.is_template='0' 
Time: 0.002s
--------------------------------------------------------------------------------
N° 3 : 
SET SESSION group_concat_max_len = 9999999;
Time: 0.000s
--------------------------------------------------------------------------------
N° 4 : 
SELECT glpi_computers.name AS ITEM_0, glpi_dropdown_domain.name AS ITEM_1, glpi_dropdown_locations.completename AS ITEM_2, GROUP_CONCAT( DISTINCT glpi_networking_ports.ifaddr SEPARATOR '$$$$') AS ITEM_3, glpi_dropdown_state.name AS ITEM_4, glpi_dropdown_os.name AS ITEM_5, glpi_enterprises.name AS ITEM_6, glpi_enterprises.website AS ITEM_6_2, glpi_enterprises.ID AS ITEM_6_3, glpi_dropdown_model.name AS ITEM_7, glpi_type_computers.name AS ITEM_8, glpi_computers.date_mod AS ITEM_9, glpi_computers.ID AS ID 
FROM glpi_computers 
LEFT JOIN glpi_dropdown_domain ON (glpi_computers.domain = glpi_dropdown_domain.ID) 
LEFT JOIN glpi_dropdown_locations ON (glpi_computers.location = glpi_dropdown_locations.ID) 
LEFT JOIN glpi_computer_device AS DEVICE_5 ON (glpi_computers.ID = DEVICE_5.FK_computers AND DEVICE_5.device_type='5') 
LEFT JOIN glpi_networking_ports ON (glpi_computers.ID = glpi_networking_ports.on_device AND glpi_networking_ports.device_type='1') 
LEFT JOIN glpi_state_item ON (glpi_computers.ID = glpi_state_item.id_device AND glpi_state_item.device_type='1') 
LEFT JOIN glpi_dropdown_state ON (glpi_state_item.state = glpi_dropdown_state.ID) 
LEFT JOIN glpi_dropdown_os ON (glpi_computers.os = glpi_dropdown_os.ID) 
LEFT JOIN glpi_enterprises ON (glpi_computers.FK_glpi_enterprise = glpi_enterprises.ID) 
LEFT JOIN glpi_dropdown_model ON (glpi_computers.model = glpi_dropdown_model.ID) 
LEFT JOIN glpi_type_computers ON (glpi_computers.type = glpi_type_computers.ID) 
WHERE glpi_computers.deleted='Y' AND glpi_computers.is_template='0' GROUP BY ID 
ORDER BY glpi_computers.name ASC LIMIT 0, 30
Time: 0.017s
--------------------------------------------------------------------------------

bonne soirée et a demain...

OSS117 me voilaaaaa

Forum GLPI-Project

Announcement

#1 2006-04-20 17:03:02

caractére étranges dans le mode debug de glpi

#2 2006-04-20 17:22:26

Re: caractére étranges dans le mode debug de glpi

#3 2006-04-20 17:24:57

Re: caractére étranges dans le mode debug de glpi

#4 2006-04-20 17:26:47

Re: caractére étranges dans le mode debug de glpi

Board footer