You are not logged in.
Pages: 1
Topic closed
Just updated to version .80. I can't get the user's list to display therefor cannot add users. When I click add user, it halts and I have to stop and start xampp to get the server to respond again.
memory_limit is set to 512
Offline
So the add user page does come up, after an hour of waiting. Any ideas ?!
Offline
I will do my best at facilitating the info you requested.
-- Verify that the bug has already been submitted on the forum or in the bugtrack of the project by making a research using keywords.
DONT SEE IT
-- Be as precise as possible and give :
* The version of GLPI you use (version number) and if you have done an update give the version of departure and arrival.
I UPDATED TO VER .8 FROM THE LATEST VER OF .78. WHEN RUNNING .78 I NEVER EXPERIENCED THIS ISSUE.
* How do you install it (expanded software for Windows), manipulation etc....
* The system informations of your platform (platform, versions of apache, php, mysql ...) and the configuration of GLPI. You will find them in General configuration / Information Systems Tab which may be copied easily.
* Browser used (IE, Moz ...), and version.
FIREFOX 4.0.1
* For notifications by e-mail or mail gateways: Full details of servers and clients used.
WE USE GMAIL FOR NOTIFICATIONS VIA SSL CONNECTION
* The manipulation you have made.
* Error messages GLPI in debug mode : Explanations
I WENT INTO DEBUG MODE. WHEN I WENT TO ADMINISTRATION --> USERS --> IT TOOK ABOUT 45 MINUTES FOR THE DEBUG INFORMATION TO DISPLAY AT THE BOTTOM OF THE PAGE. I DIDN'T SEE ANY ERRORS COME UP, BUT DID SEE SOMETHING IN THE LOG THAT STOOD OUT.
13 SELECT 'pchasse' AS currentuser, GROUP_CONCAT(DISTINCT CONCAT(`glpi_users`.`name`, '$$' , `glpi_users`.`id`) SEPARATOR '$$$$') AS ITEM_0, `glpi_users`.`realname` AS ITEM_1, `glpi_users`.`firstname` AS ITEM_2, `glpi_users`.`email` AS ITEM_3, `glpi_users`.`is_active` AS ITEM_4, `glpi_users`.`authtype` AS ITEM_5, `glpi_users`.`auths_id` AS ITEM_5_2, `glpi_authldaps_auths_id_87a71a8930394def944f9b3ce6beda6e`.`name` AS ITEM_5_3, `glpi_authmails_auths_id_7025ea259d268a37a4afef2aa1a42bfb`.`name` AS ITEM_5_4, COUNT(DISTINCT `glpi_tickets_c5035a08220b6a9ed38eff74a2963c19`.`id`) AS ITEM_6, `glpi_users`.`date_mod` AS ITEM_7, `glpi_users`.`last_login` AS ITEM_8, `glpi_users`.`id` AS id
FROM `glpi_users`
LEFT JOIN `glpi_profiles_users` ON (`glpi_users`.`id` = `glpi_profiles_users`.`users_id` )
LEFT JOIN `glpi_authldaps` AS glpi_authldaps_auths_id_87a71a8930394def944f9b3ce6beda6e ON (`glpi_users`.`auths_id` = `glpi_authldaps_auths_id_87a71a8930394def944f9b3ce6beda6e`.`id` AND `glpi_users`.`authtype` = 3 )
LEFT JOIN `glpi_authmails` AS glpi_authmails_auths_id_7025ea259d268a37a4afef2aa1a42bfb ON (`glpi_users`.`auths_id` = `glpi_authmails_auths_id_7025ea259d268a37a4afef2aa1a42bfb`.`id` AND `glpi_users`.`authtype` = 2 )
LEFT JOIN `glpi_tickets_users` ON (`glpi_users`.`id` = `glpi_tickets_users`.`users_id` )
LEFT JOIN `glpi_tickets` AS glpi_tickets_c5035a08220b6a9ed38eff74a2963c19 ON (`glpi_tickets_users`.`tickets_id` = `glpi_tickets_c5035a08220b6a9ed38eff74a2963c19`.`id` OR `glpi_tickets_c5035a08220b6a9ed38eff74a2963c19`.`users_id_recipient` = `glpi_tickets_users`.`users_id` )
WHERE `glpi_users`.`is_deleted` = '0' GROUP BY `glpi_users`.`id`
ORDER BY `glpi_users`.`name` ASC LIMIT 0, 200 2 532.099
* All information which may help us to determine the causes of the dysfunction of GLPI on your installation.
I LOOKED IN PHP-ERRORS.LOG AND FOUND NO ENTRIES.
Offline
Also note that we have GLPI running on Ubuntu 9.10 and XAMPP running our Apache PHP and SQL
Offline
Could you give us the copy/paste of the information system tab in glpi
And also the entire debug mode (we need to see all query).
JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au projet GLPI : Soutenir
Offline
Log Level : Maximal number of automatic actions (run by CLI) :
Logs in files (SQL, email, automatic action...) : Enable the MySQL replicate :
Check for upgrade - Proxy configuration
Server : Port :
Login : Password :
Information about system installation and configuration
GLPI 0.80 (/glpi => /opt/lampp/htdocs/glpi)
Server
Operating Systems : Linux moodle 2.6.31-23-generic #75-Ubuntu SMP Fri Mar 18 18:08:39 UTC 2011 i686
PHP 5.2.8 (PDO, Reflection, SPL, SQLite, SimpleXML, apache2handler, bcmath, bz2, calendar, ctype, curl, date, dba, dbase, dbx,
dom, exif, filter, ftp, gd, gettext, hash, iconv, imap, json, ldap, libxml, mbstring, mcrypt, mhash, mime_magic, ming, mssql,
mysql, mysqli, openssl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, posix, radius, session, shmop, soap, sockets, standard,
sybase, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib)
Setup: memory_limit="256M" max_execution_time="30" safe_mode="" session.save_handler="files" post_max_size="8M"
upload_max_filesize="2M"
Software: Apache/2.2.11 (Unix) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.8 mod_apreq2-20051231/2.6.0 mod_perl/2.0.4
Perl/v5.10.0 (Apache/2.2.11 (Unix) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.8 mod_apreq2-20051231/2.6.0 mod_perl/2.0.4
Perl/v5.10.0 Server at 64.45.76.27 Port 80)
Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
MySQL: 5.1.30 (root@localhost/glpidatabase)
../config : OK
../files : OK
../files/_dumps : OK
../files/_sessions : OK
../files/_cron : OK
../files/_cache/ : OK
../files/_graphs : OK
../files/_log : OK
Mysql replicate
Active : No
Notifications / Mail Receiver
Way of sending emails: SMTP+SSL (tech@madawaskaschools.org@smtp.gmail.com)
Mail Receiver
OCS Inventory NG
Host for the OCSNG database : 'localhost', Connection to OCSNG database successful, Use the OCSNG software dictionary : 1
Plugins list
To copy/paste in your support request
Offline
Here's a copy of the SQL Request
SQL REQUEST : 15 Queries took 2.077s
N° Queries Time Errors
1 SELECT COUNT(*)
FROM `glpi_authldaps` 0.000
2 SELECT count(*)
FROM `glpi_authmails` 0.000
3 SELECT COUNT(*)
FROM `glpi_authldaps` 0.000
4 SELECT `bookmarks_id`
FROM `glpi_bookmarks_users`
WHERE `users_id`='8' AND `itemtype` = 'User' 0.010
5 SHOW COLUMNS
FROM `glpi_users` 0.002
6 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'User' AND `users_id` = '8'
ORDER BY `rank` 0.016
7 SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'User' AND `users_id` = '0'
ORDER BY `rank` 0.008
8 SHOW COLUMNS
FROM `glpi_users` 0.003
9 SELECT COUNT(*) AS cpt
FROM `glpi_entities` 0.000
10 SHOW COLUMNS
FROM `glpi_users` 0.002
11 SELECT count(DISTINCT `glpi_users`.`id`), 'pchasse' AS currentuser
FROM `glpi_users`
LEFT JOIN `glpi_profiles_users` ON (`glpi_users`.`id` = `glpi_profiles_users`.`users_id` )
WHERE `glpi_users`.`is_deleted` = '0' 0.001
12 SET SESSION group_concat_max_len = 4096; 0.008
13 SELECT 'pchasse' AS currentuser, GROUP_CONCAT(DISTINCT CONCAT(`glpi_users`.`name`, '$$' , `glpi_users`.`id`) SEPARATOR '$$$$') AS ITEM_0, `glpi_users`.`realname` AS ITEM_1, `glpi_users`.`firstname` AS ITEM_2, `glpi_users`.`email` AS ITEM_3, `glpi_users`.`is_active` AS ITEM_4, `glpi_users`.`authtype` AS ITEM_5, `glpi_users`.`auths_id` AS ITEM_5_2, `glpi_authldaps_auths_id_87a71a8930394def944f9b3ce6beda6e`.`name` AS ITEM_5_3, `glpi_authmails_auths_id_7025ea259d268a37a4afef2aa1a42bfb`.`name` AS ITEM_5_4, COUNT(DISTINCT `glpi_tickets_c5035a08220b6a9ed38eff74a2963c19`.`id`) AS ITEM_6, `glpi_users`.`date_mod` AS ITEM_7, `glpi_users`.`last_login` AS ITEM_8, `glpi_users`.`id` AS id
FROM `glpi_users`
LEFT JOIN `glpi_profiles_users` ON (`glpi_users`.`id` = `glpi_profiles_users`.`users_id` )
LEFT JOIN `glpi_authldaps` AS glpi_authldaps_auths_id_87a71a8930394def944f9b3ce6beda6e ON (`glpi_users`.`auths_id` = `glpi_authldaps_auths_id_87a71a8930394def944f9b3ce6beda6e`.`id` AND `glpi_users`.`authtype` = 3 )
LEFT JOIN `glpi_authmails` AS glpi_authmails_auths_id_7025ea259d268a37a4afef2aa1a42bfb ON (`glpi_users`.`auths_id` = `glpi_authmails_auths_id_7025ea259d268a37a4afef2aa1a42bfb`.`id` AND `glpi_users`.`authtype` = 2 )
LEFT JOIN `glpi_tickets_users` ON (`glpi_users`.`id` = `glpi_tickets_users`.`users_id` )
LEFT JOIN `glpi_tickets` AS glpi_tickets_c5035a08220b6a9ed38eff74a2963c19 ON (`glpi_tickets_users`.`tickets_id` = `glpi_tickets_c5035a08220b6a9ed38eff74a2963c19`.`id` OR `glpi_tickets_c5035a08220b6a9ed38eff74a2963c19`.`users_id_recipient` = `glpi_tickets_users`.`users_id` )
WHERE `glpi_users`.`is_deleted` = '0' GROUP BY `glpi_users`.`id`
ORDER BY `glpi_users`.`name` ASC LIMIT 0, 200 2 717.366
14 SHOW WARNINGS 0.024
15 SHOW COLUMNS
FROM `glpi_users` 0.003
AUTOLOAD
Offline
Here's the rest of it, just in case you need it:
AUTOLOAD
Plugin, Bookmark, User, Auth, AuthLdap, AuthMail, Search, CommonDropdown, CommonTreeDropdown, Location, Dropdown, DisplayPreference, CommonDBChild, Infocom, Document
POST VARIABLE
KEY => VALUE
itemtype => User
num => 0
field => view
searchtype => contains
value =>
meta => 0
GET VARIABLE
KEY => VALUE
start => 0
order => ASC
is_deleted => 0
distinct => N
link =>
field =>
KEY => VALUE
0 => view
contains =>
KEY => VALUE
0 =>
searchtype =>
KEY => VALUE
0 => contains
link2 =>
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
SESSION VARIABLE
KEY => VALUE
glpi_plugins =>
glpicookietest => testcookie
glpi_use_mode => 2
glpiID => 8
glpiname => pchasse
glpirealname => Chasse
glpifirstname => Paul
glpidefault_entity => 0
glpiusers_idisation => 1
glpiextauth => 0
glpiauthtype => 1
glpiroot => /glpi
glpicrontimer => 1307358387
glpi_tabs =>
KEY => VALUE
central => 1
glpicsv_delimiter => ;
glpidate_format => 2
glpidefault_requesttypes_id => 1
glpidropdown_chars_limit => 100
glpifollowup_private => 0
glpiis_categorized_soft_expanded => 0
glpiis_ids_visible => 0
glpiis_not_categorized_soft_expanded => 1
glpilanguage => en_GB
glpilist_limit => 200
glpinames_format => 0
glpinumber_format => 1
glpipriority_1 => #12E1D7
glpipriority_2 => 1e90ff
glpipriority_3 => 00ff7f
glpipriority_4 => ffd700
glpipriority_5 => ffa500
glpipriority_6 => ff0000
glpishow_jobs_at_login => 1
glpitask_private => 0
glpiuse_flat_dropdowntree => 0
glpiprofiles =>
KEY => VALUE
4 =>
KEY => VALUE
name => super-admin
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_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 =>
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_ticket => r
entity_rule_ticket => 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_authtype => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_public => w
backup => w
create_ticket => 1
delete_ticket => 1
add_followups => 1
group_add_followups => 1
global_add_followups => 1
global_add_tasks => 1
update_ticket => 1
update_priority => 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
update_tasks => 1
show_planning => 1
show_group_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 2
helpdesk_item_type =>
KEY => VALUE
0 => Computer
1 => NetworkEquipment
2 => Printer
3 => Monitor
4 => Peripheral
5 => Software
6 => Phone
helpdesk_status =>
show_group_ticket => 1
show_group_hardware => 0
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
budget => w
import_externalauth_users => w
notification => w
rule_mailcollector => w
date_mod => 2010-12-27 09:52:01
comment =>
validate_ticket => 1
create_validation => 1
calendar => w
sla => w
rule_dictionnary_printer => w
clean_ocsng => w
update_own_followups => 1
delete_followups => 1
entity_helpdesk => w
entities =>
KEY => VALUE
0 =>
KEY => VALUE
id => 0
name =>
is_recursive => 1
glpiactiveentities =>
KEY => VALUE
0 => 0
glpisearch =>
KEY => VALUE
User =>
KEY => VALUE
start => 0
order => ASC
is_deleted => 0
distinct => N
link =>
field =>
KEY => VALUE
0 => view
contains =>
KEY => VALUE
0 =>
searchtype =>
KEY => VALUE
0 => contains
link2 =>
field2 =>
KEY => VALUE
0 => view
contains2 =>
KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
glpisearchcount =>
KEY => VALUE
User => 1
glpisearchcount2 =>
KEY => VALUE
User => 0
glpiactiveentities_string => '0'
glpiparententities =>
glpiparententities_string =>
glpiactive_entity => 0
glpiactive_entity_name => Root entity (tree structure)
glpiactive_entity_shortname => Root entity (tree structure)
glpishowallentities => 1
glpigroups =>
KEY => VALUE
0 => 1
glpi_currenttime => 2011-06-06 07:06:48
MESSAGE_AFTER_REDIRECT =>
glpi_multientitiesmode => 0
glpilisttitle =>
KEY => VALUE
User => List
glpilistitems =>
KEY => VALUE
User =>
KEY => VALUE
0 => 116
1 => 2
2 => 129
3 => 35
4 => 98
5 => 97
6 => 128
7 => 63
8 => 31
9 => 123
10 => 95
11 => 37
12 => 124
13 => 93
14 => 136
15 => 34
16 => 54
17 => 21
18 => 51
19 => 60
20 => 92
21 => 120
22 => 46
23 => 90
24 => 133
25 => 7
26 => 118
27 => 119
28 => 115
29 => 86
30 => 127
31 => 20
32 => 112
33 => 85
34 => 27
35 => 122
36 => 140
37 => 83
38 => 82
39 => 14
40 => 135
41 => 80
42 => 79
43 => 78
44 => 121
45 => 25
46 => 134
47 => 75
48 => 74
49 => 43
50 => 55
51 => 73
52 => 26
53 => 10
54 => 125
55 => 56
56 => 71
57 => 38
58 => 11
59 => 45
60 => 12
61 => 44
62 => 132
63 => 50
64 => 49
65 => 109
66 => 36
67 => 107
68 => 23
69 => 8
70 => 106
71 => 105
72 => 104
73 => 103
74 => 114
75 => 102
76 => 53
77 => 15
78 => 52
79 => 101
80 => 139
81 => 137
82 => 39
83 => 22
84 => 41
85 => 126
86 => 30
87 => 17
88 => 6
89 => 57
90 => 32
91 => 13
glpilisturl =>
KEY => VALUE
User => /glpi/front/user.php
glpimassiveactionselected =>
Offline
Hope this helps JMD! Thanks in advance for your help! -Paul
Offline
BUMP - Any idea what's going on guys... this issue is a real pain!
Offline
Whatever was changed in 80.1 fixed my issue. Thanks!..
Offline
Pages: 1
Topic closed