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 2015-05-19 09:19:18

atanas.ag
Member
Registered: 2015-05-19
Posts: 7

Problem loading combo boxes in search/filter bar

Dear GLPI Developers,
After I update from v. 83.5 to v.85.3 and finally 85.4 I experience strange problem with search/filter bar. When I choose something like entity and pick “is” and then try to expand the combo box there is something wrong. There doesn’t show anything on the list instead some massage “loading failed”. Here is the screen shot of that. This strange behavior is happening with every database data that must be populated in a combo box. Is there something that I miss to config or something else? Thank you for your help in advance!

Link to download the screenshot: http://dox.bg/files/dw?a=1f22c2126f

PS: Excuse me for my bad English! smile

Offline

#2 2015-05-19 13:47:55

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Problem loading combo boxes in search/filter bar

I have no problem with 0.85.4
Have your some errors in glpi/files/_logs/php-error.log or sql-error.log?


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)

Offline

#3 2015-05-19 16:07:58

atanas.ag
Member
Registered: 2015-05-19
Posts: 7

Re: Problem loading combo boxes in search/filter bar

yllen wrote:

I have no problem with 0.85.4
Have your some errors in glpi/files/_logs/php-error.log or sql-error.log?

Yes, there is errors in the log files: http://dox.bg/files/dw?a=865d905d34

Offline

#4 2015-05-20 09:44:41

atanas.ag
Member
Registered: 2015-05-19
Posts: 7

Re: Problem loading combo boxes in search/filter bar

Hello again,
I ask one of my colleagues to look at this and he told me that the problem is because there is so many entities and the method "GET" is used to populate data into the combo boxes and there has limitation in browser address bar to contain about 4000 chars. If there is more than that then the GET method doesn't complete the server request and the error is raised.
He told me that if "GET" is replaced with "POST" to populate the data into the combo boxes there will be no errors whatever how big is the data. Of course this is just a suggestion and because of that I’m writing here for your help. Thank you very much again.

Offline

#5 2015-05-20 14:13:01

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Problem loading combo boxes in search/filter bar

Ticket opened on the roadmap: https://forge.indepnet.net/issues/5312
Fix for entity restrict for change (view in your logs): https://forge.indepnet.net/projects/glp … ions/23476


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)

Offline

#6 2015-05-20 20:06:53

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Problem loading combo boxes in search/filter bar

You can solve temporary with problem by using Contain parameter and the name of your entity
(contain Root Entity)


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)

Offline

#7 2015-05-21 16:08:08

atanas.ag
Member
Registered: 2015-05-19
Posts: 7

Re: Problem loading combo boxes in search/filter bar

yllen wrote:

You can solve temporary with problem by using Contain parameter and the name of your entity
(contain Root Entity)

Yes. Thank you very much again for your help!

Offline

#8 2015-05-22 11:53:17

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: Problem loading combo boxes in search/filter bar

Voir https://forge.indepnet.net/projects/glp … ions/23483

Ce changement devrait limiter la taille de l'URL et partiellement résoudre ce bug.
à tester


Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

#9 2015-05-22 12:50:37

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Problem loading combo boxes in search/filter bar

Can you try with this fix: https://forge.indepnet.net/projects/glp … .class.php
in addition of the fix of Remi?


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)

Offline

#10 2015-05-25 09:16:33

atanas.ag
Member
Registered: 2015-05-19
Posts: 7

Re: Problem loading combo boxes in search/filter bar

yllen wrote:

Can you try with this fix: https://forge.indepnet.net/projects/glp … .class.php
in addition of the fix of Remi?

No. It does not work. The result is the same as before.

Last edited by atanas.ag (2015-05-25 09:18:31)

Offline

#11 2015-05-27 13:06:45

remi
GLPI-DEV
From: Champagne
Registered: 2007-04-28
Posts: 7,127
Website

Re: Problem loading combo boxes in search/filter bar

How many entities do you have ?
(URL is managed by jquery, not so easy to fix)


Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

Offline

#12 2015-05-28 08:40:08

atanas.ag
Member
Registered: 2015-05-19
Posts: 7

Re: Problem loading combo boxes in search/filter bar

remi wrote:

How many entities do you have ?
(URL is managed by jquery, not so easy to fix)

Entities - 480

but the problem is not only for entities but for every combo filed by ths mechanism.

Last edited by atanas.ag (2015-05-28 08:40:20)

Offline

#13 2015-05-28 13:33:09

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Problem loading combo boxes in search/filter bar

Have you try a combo box with less than 480 (for me it's work with ~ 330 item)


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)

Offline

#14 2015-05-28 15:54:28

atanas.ag
Member
Registered: 2015-05-19
Posts: 7

Re: Problem loading combo boxes in search/filter bar

yllen wrote:

Have you try a combo box with less than 480 (for me it's work with ~ 330 item)

Yes, same thing,  but it not loading the data only when I'm in "tree structure" mode.
When I change the mode for just current entiti then the combos are loaded fine. Of course i see only parent entiti where i am at the moment.  Other combos like status, category etc. ar then loaded fineq but when i change to "tree structure"  then nothing is loaded in every combo that uses db as source.

Offline

#15 2015-05-29 10:20:55

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Problem loading combo boxes in search/filter bar

I have 332 entities and the problem is solved with the 2 fixes.


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)

Offline

#16 2015-07-22 16:40:30

jgobet
Member
Registered: 2013-06-14
Posts: 72

Re: Problem loading combo boxes in search/filter bar

Je me permet un petit up afin de préciser que le problème persiste toujours de mon côté après la mise en place des 2 fixes proposés avec GLPI en version 0.85.4.

En effet, dès que je souhaite charger une liste depuis l'entité racine (arborescence), celle-ci retourne constamment l'erreur "Loading failed".
Que ce soit pour le champ Catégorie, Entité, Source de la demande, Demandeur, Groupe demandeur, ... dans la recherche de tickets ou en souhaitant ajouter une habilitation à un utilisateur par exemple (avec le champ Entité).
Par contre dès que je sélectionne une entité alors ces listes déroulantes fonctionnent bien.

Pour information, nous gérons actuellement plus de 700 entités dans GLPI.

Je vous remercie par avance pour la prise en considération de mon message et reste à votre disposition si nécessaire.

Offline

#17 2015-07-27 17:52:36

jgobet
Member
Registered: 2013-06-14
Posts: 72

Re: Problem loading combo boxes in search/filter bar

Sorry for my answer in french, i don't view that it's an only english section.
I so try to translate my answer in english.

I have always this problem in 0.85.4 after apply 2 fixes on top.

The problem start when I want to load an item list in the root entity (tree structure), I always the error "Loading failed" for all lists.
I've got this error for Categories, Entities, Request source, Requester, Requester group, ... in the ticket search or when I want to add an authorization to a user for example (with the Entity field).
However if I select an entity these lists run fine.

For information, we use actually more than 700 entities in GLPI.

Thanks for your answer and sorry for my bad English.

Offline

#18 2015-07-31 09:43:23

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Problem loading combo boxes in search/filter bar

Done in tarball of 0.85.5 or present in new future version 0.90


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)

Offline

Board footer

Powered by FluxBB