Forum GLPI-Project

pescardo

Member

Registered: 2009-04-07

Posts: 2

Can't select entity

Hi, we have a problem with or GLPI installation. Whe have several entities on GLPI however, we can't select them, and just get a blank entities list when trying to list them.

Our entities are there, we can see them in Administration-->Entities, and we can create new entities also, it is just that we can not select them form the list.

I think we have this problem after migrating GLPI to a new server.

I'm not sure how to add images on this post, but when using GLPI in Debug mode, we get this

GLPI MODE DEBUG
SQL REQUEST : 10 Queries took 0.002s
N°  Queries Time Errors
1 SELECT *
FROM glpi_display
WHERE type='1' AND FK_users='2'
ORDER BY rank 0.000   
2 SELECT *
FROM glpi_display
WHERE type='1' AND FK_users='0'
ORDER BY rank 0.000   
3 SELECT count(*)
FROM glpi_computers
WHERE glpi_computers.deleted='0' AND glpi_computers.is_template='0'  0.000   
4 SET SESSION group_concat_max_len = 9999999; 0.000   
5 SELECT glpi_computers.name AS ITEM_0, glpi_computers.ID AS ITEM_0_2, glpi_entities.completename AS ITEM_1, glpi_entities.ID AS ITEM_1_2, glpi_dropdown_state.name AS ITEM_2, glpi_dropdown_manufacturer.name AS ITEM_3, glpi_computers.serial AS ITEM_4, glpi_type_computers.name AS ITEM_5, glpi_dropdown_model.name AS ITEM_6, glpi_dropdown_os.name AS ITEM_7, glpi_dropdown_locations.completename AS ITEM_8, glpi_computers.date_mod AS ITEM_9, glpi_computers.contact AS ITEM_10, glpi_computers.ID AS ID
FROM glpi_computers
LEFT JOIN glpi_entities ON (glpi_computers.FK_entities = glpi_entities.ID)
LEFT JOIN glpi_dropdown_state ON (glpi_computers.state = glpi_dropdown_state.ID)
LEFT JOIN glpi_dropdown_manufacturer ON (glpi_computers.FK_glpi_enterprise = glpi_dropdown_manufacturer.ID)
LEFT JOIN glpi_type_computers ON (glpi_computers.type = glpi_type_computers.ID)
LEFT JOIN glpi_dropdown_model ON (glpi_computers.model = glpi_dropdown_model.ID)
LEFT JOIN glpi_dropdown_os ON (glpi_computers.os = glpi_dropdown_os.ID)
LEFT JOIN glpi_dropdown_locations ON (glpi_computers.location = glpi_dropdown_locations.ID)
WHERE glpi_computers.deleted='0' AND glpi_computers.is_template='0'
ORDER BY ITEM_0 ASC LIMIT 0, 20 0.002   
6 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'applicatifs') 0.000   
7 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'appweb') 0.000   
8 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'certificates') 0.000   
9 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'domain') 0.000   
10 SELECT *
FROM `glpi_plugins`
WHERE (directory = 'sgbd') 0.000   

POST VARIABLE
GET VARIABLE
KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link => 
field => KEY => VALUE
0 => view

contains => KEY => VALUE
0 => 

link2 => 
field2 => KEY => VALUE
0 => view

contains2 => KEY => VALUE
0 => 

type2 => 
sort => 1

SESSION VARIABLE
KEY => VALUE
glpi_currenttime => 2010-02-17 18:40:13
glpi_use_mode => 2
glpiID => 2
glpiname => glpi
glpirealname => 
glpifirstname => 
glpidefault_entity => 0
glpiauthorisation => 1
glpiextauth => 0
glpiauth_method => 1
glpisearchcount => KEY => VALUE
1 => 1
15 => 1
28 => 1

glpisearchcount2 => KEY => VALUE
1 => 0
15 => 0
28 => 0

glpiroot => /main
glpicrontimer => 1266442604
glpi_tab => 1
glpilanguage => en_GB
glpilist_limit => 20
glpidateformat => 1
glpinumberformat => 0
glpiview_ID => 0
glpidropdown_limit => 50
glpiflat_dropdowntree => 0
glpinum_of_events => 10
glpinextprev_item => name
glpijobs_at_login => 0
glpipriority_1 => #fff2f2
glpipriority_2 => #ffe0e0
glpipriority_3 => #ffcece
glpipriority_4 => #ffbfbf
glpipriority_5 => #ffadad
glpiexpand_soft_categorized => 1
glpiexpand_soft_not_categorized => 1
glpitracking_order => 1
glpifollowup_private => 0
glpiprofiles => KEY => VALUE
4 => KEY => VALUE
name => super-admin
entities => KEY => VALUE
2 => KEY => VALUE
ID => 0
name => 
recursive => 1

glpiactiveprofile => KEY => VALUE
ID => 4
name => super-admin
interface => central
is_default => 0
computer => w
monitor => w
software => w
networking => w
printer => w
peripheral => w
cartridge => w
consumable => w
phone => w
notes => w
contact_enterprise => w
document => w
contract => w
infocom => w
knowbase => w
faq => w
reservation_helpdesk => 1
reservation_central => w
reports => r
ocsng => w
view_ocsng => r
sync_ocsng => w
dropdown => w
entity_dropdown => w
device => w
typedoc => w
link => w
config => w
rule_tracking => w
rule_ocs => w
rule_ldap => w
rule_softwarecategories => w
search_config => w
search_config_global => w
check_update => r
profile => w
user => w
user_auth_method => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_public => w
backup => w
create_ticket => 1
delete_ticket => 1
comment_ticket => 1
comment_all_ticket => 1
update_ticket => 1
own_ticket => 1
steal_ticket => 1
assign_ticket => 1
show_all_ticket => 1
show_assign_ticket => 1
show_full_ticket => 1
observe_ticket => 1
update_followups => 1
show_planning => 1
show_group_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_hardware_type => 8388674
show_group_ticket => 0
show_group_hardware => 0
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
entities => KEY => VALUE
2 => KEY => VALUE
ID => 0
name => 
recursive => 1

glpiactiveentities => KEY => VALUE
0 => 0
16 => 16
37 => 37
9 => 9
18 => 18
3 => 3
7 => 7
5 => 5
6 => 6
10 => 10
11 => 11
12 => 12
15 => 15
17 => 17
19 => 19
20 => 20
21 => 21
22 => 22
23 => 23
24 => 24
25 => 25
26 => 26
27 => 27
28 => 28
29 => 29
30 => 30
31 => 31
32 => 32
33 => 33
34 => 34
35 => 35
36 => 36
39 => 39
40 => 40
41 => 41
42 => 42
43 => 43
44 => 44
45 => 45
46 => 46

glpiactiveentities_string => '0','16','37','9','18','3','7','5','6','10','11','12','15','17','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','39','40','41','42','43','44','45','46'
glpiparententities => 
glpiparententities_string => 
glpiactive_entity => 0
glpiactive_entity_name => Root entity (Show all)
glpiactive_entity_shortname => Root entity (Show all)
glpishowallentities => 1
glpigroups => 
glpi_plugin_pdf_profile => KEY => VALUE
ID => 4
profile => 
use => 1

glpi_plugin_manageentity_profile => KEY => VALUE
ID => 4
name => super-admin
manageentity => w
cri => 

glpi_plugin_treeview_profile => KEY => VALUE
ID => 4
name => super-admin
treeview => r

glpi_plugin_compte_profile => KEY => VALUE
ID => 4
name => super-admin
compte => w
all_users => r
my_groups => r
open_ticket => 1

glpi_plugins => KEY => VALUE
13 => pdf
28 => manageentity
29 => treeview
33 => compte

MESSAGE_AFTER_REDIRECT => 
glpi_multientitiesmode => 1
glpisearch => KEY => VALUE
1 => KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link => 
field => KEY => VALUE
0 => view

contains => KEY => VALUE
0 => 

link2 => 
field2 => KEY => VALUE
0 => view

contains2 => KEY => VALUE
0 => 

type2 => 
sort => 1

15 => KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link => 
field => KEY => VALUE
0 => view

contains => KEY => VALUE
0 => 

link2 => 
field2 => KEY => VALUE
0 => view

contains2 => KEY => VALUE
0 => 

type2 => 
sort => 1

28 => KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link => 
field => KEY => VALUE
0 => view

contains => KEY => VALUE
0 => 

link2 => 
field2 => KEY => VALUE
0 => view

contains2 => KEY => VALUE
0 => 

type2 => 
sort => 1

glpilisttitle => KEY => VALUE
1 => List
15 => List
28 => List

glpilistitems => KEY => VALUE
1 => KEY => VALUE
0 => 33
1 => 58
2 => 59
3 => 60
4 => 61
5 => 62
6 => 32
7 => 5
8 => 38
9 => 21
10 => 4
11 => 57
12 => 12
13 => 40
14 => 45
15 => 20
16 => 17
17 => 18
18 => 19
19 => 42

15 => KEY => VALUE
0 => 7
1 => 2
2 => 5
3 => 8
4 => 6
5 => 3
6 => 4

28 => KEY => VALUE
0 => 41
1 => 25
2 => 32
3 => 42
4 => 18
5 => 6
6 => 31
7 => 19
8 => 22
9 => 39
10 => 20
11 => 29
12 => 27
13 => 24
14 => 40
15 => 3
16 => 36
17 => 17
18 => 23
19 => 16

glpilisturl => KEY => VALUE
1 => /main/front/computer.php
15 => /main/front/user.php
28 => /main/front/entity.php

glpimassiveactionselected => 

That's all.

Any idea?

Thanks for your help.

Regards,

Pablo.-

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Can't select entity

Our entities are there, we can see them in Administration-->Entities, and we can create new entities also, it is just that we can not select them form the list.

You can select entities on which you have rights.
Have you selected Root Entity (Show all) ?

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

pescardo

Member

Registered: 2009-04-07

Posts: 2

Re: Can't select entity

It's solved now. The problem was that after server migration pho-json was not working, the result is a blank entities list when trying to select other entities other than default (root entity).

After reinstalling php-json, we did an httpd restart and logon again on GLPI, everything working fine after that.

Unfortunally, there was not any error to find out the problem. So, we decided to start with a new fresh glpi install, where the install wizard test all required components and json was not working.

Thanks for your help.

Pablo.-

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: Can't select entity

Ok i close.

---

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