You are not logged in.
- Topics: Active | Unanswered
Announcement
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Pages: 1
#1 2023-09-12 23:29:05
- sIBajHYG
- Member
- From: Mission [KS]
- Registered: 2023-08-18
- Posts: 75
Filter - Applications installed today
Please tell me what could be causing the problem?
Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0, Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.
Offline
#2 2023-09-13 08:52:44
- LaDenrée
- HELPER
- Registered: 2012-11-19
- Posts: 6,287
Re: Filter - Applications installed today
have a look to glpi_items_softwareversions table and check if you have an index on 'date_install' column
Nom de l'index Type Unique Compressé Colonne Cardinalité Interclassement Null Commentaire
PRIMARY BTREE Oui Non id 1532300 A Non unicity BTREE Oui Non itemtype 2 A Non
items_id 14187 A Non
softwareversions_id 1532300 A Non
softwareversions_id BTREE Non Non softwareversions_id 51076 A Non
computers_info BTREE Non Non entities_id 2 A Non
is_template_item 2 A Non
is_deleted_item 4 A Non
is_dynamic BTREE Non Non is_dynamic 2 A Non
date_install BTREE Non Non date_install 7738 A Oui
is_deleted BTREE Non Non is_deleted 2 A Non
is_deleted_item BTREE Non Non is_deleted_item 2 A Non
is_template_item BTREE Non Non is_template_item 2 A Non Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
#3 2023-09-13 17:15:19
- sIBajHYG
- Member
- From: Mission [KS]
- Registered: 2023-08-18
- Posts: 75
Re: Filter - Applications installed today
have a look ....
It seems there is
There is also this value for every software. For example:
Last edited by sIBajHYG (2023-09-13 17:26:54)
Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0, Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.
Offline
#4 2023-09-13 17:38:29
- LaDenrée
- HELPER
- Registered: 2012-11-19
- Posts: 6,287
Re: Filter - Applications installed today
I see column but no indexes
Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
#5 2023-09-13 18:05:58
- sIBajHYG
- Member
- From: Mission [KS]
- Registered: 2023-08-18
- Posts: 75
Re: Filter - Applications installed today
I see column but no indexes
Hmm... can you please tell me more? This?
Last edited by sIBajHYG (2023-09-13 18:09:41)
Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0, Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.
Offline
#6 2023-09-14 08:30:51
- LaDenrée
- HELPER
- Registered: 2012-11-19
- Posts: 6,287
Re: Filter - Applications installed today
ok your indexes seem correct.
I work with 10.0.9 and i have no error, however, since indexes are persent I don't known if it's due to database or glpi version.
I didn't see any fix for that in changelog at github.
sorry. I can't help more :-(
Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9
Offline
#7 2023-09-14 12:52:30
- cconard96
- Moderator
- Registered: 2018-07-31
- Posts: 2,813
- Website
Re: Filter - Applications installed today
sIBajHYG, which version of GLPI are you using? If it is still 10.0.3, it is possible the issue was already fixed. There were over 1,100 patches made between 10.0.3 and the latest bug-fix version 10.0.9.
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline
#8 2023-09-14 17:25:23
- sIBajHYG
- Member
- From: Mission [KS]
- Registered: 2023-08-18
- Posts: 75
Re: Filter - Applications installed today
OK! thanks a lot for the advice! I'll update soon and report the results!
Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0, Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.
Offline
#9 2023-09-21 23:40:00
- sIBajHYG
- Member
- From: Mission [KS]
- Registered: 2023-08-18
- Posts: 75
Re: Filter - Applications installed today
If it is still 10.0.3....latest bug-fix version 10.0.9.
Updated to 10.0.9. WITHOUT the FusionInventory plugin these bugs did not exist.
But FusionInventory still only supports 10.0.6 GLPI maximum version.
So I downgraded GLPI to 10.0.6. And installed the latest version of FusionInventory. The bugs are back.
I checked it twice... in 10.0.9 there are 2 fewer bugs (a bug from the topisk and a bug about the "lock" fields in the inventory), but there is no FusionInventory 
so we are waiting for the update...
Locks & Locks bugs:
Last edited by sIBajHYG (2023-09-22 17:54:45)
Linux ubuntu-22.04.2-live-server-amd64, PHP 8.1.2, Apache 2.4.52, MariaDB 10.6.12, GLPI 10.0.15.
GLPI Inventory 1.3.5, PHP SAML 1.3.0, Oauth IMAP 1.4.3, Additional Fields, 1.21.8,Ticket Cleaner.
Offline
Pages: 1