You are not logged in.
- Topics: Active | Unanswered
Announcement
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Pages: 1
Topic closed
#1 2008-09-30 14:42:19
- TheHinou
- Member
- Registered: 2008-07-03
- Posts: 434
ticketreport : Affichage vide
Bonjour,
J'ai installé le plug-in Plugin ticketreport v1.1 sur un glpi 0.71.2
l'installation se fait sans problème
le parametrage est ok : compte super Admin droit d'écriture.
J'ai des ticket ouverts et fermés entre les dates demandées, pourtant le tableau reste vide
Ais-je oublié une étape ?
y'a t'il quelqu'un qui à le même problème ?
Last edited by TheHinou (2008-09-30 14:43:08)
Server : Windows 2003 - Apache 2.2.23 - Php 5.4.11 - Mysql 5.5.30 - Glpi 0.83.7
Offline
#2 2008-09-30 15:12:01
- tsmr
- GLPI-DEV
- From: Rennes
- Registered: 2005-08-26
- Posts: 11,632
- Website
Re: ticketreport : Affichage vide
tu peux te mettre en mode debug ?
Xavier Caillaud
Blog GLPI Infotel
Offline
#3 2008-09-30 15:16:34
- TheHinou
- Member
- Registered: 2008-07-03
- Posts: 434
Re: ticketreport : Affichage vide
Oui que dois-je fournir comme élément?
GLPI MODE DEBUG
SQL REQUEST : 28 Queries took 0.006s
N° Queries Time Errors
1 SELECT *
FROM glpi_users
WHERE ID='6' 0.000
2 SELECT *
FROM glpi_dropdown_locations
WHERE (ID = '1') 0.000
3 SELECT DISTINCT glpi_users.*
FROM glpi_users
LEFT JOIN glpi_users_profiles ON (glpi_users.ID = glpi_users_profiles.FK_users)
LEFT JOIN glpi_profiles ON (glpi_profiles.ID= glpi_users_profiles.FK_profiles)
WHERE glpi_profiles.interface='central' AND ( glpi_users_profiles.FK_entities = '0' ) AND glpi_users.deleted='0' AND glpi_users.active='1' AND glpi_users.ID NOT IN (6)
ORDER BY glpi_users.realname,glpi_users.firstname, glpi_users.name 0.000
4 SELECT *
FROM glpi_users
WHERE ID='6' 0.000
5 SELECT glpi_tracking.*, glpi_entities.ID AS entity
FROM glpi_tracking
LEFT JOIN glpi_entities ON (glpi_tracking.FK_entities=glpi_entities.ID)
WHERE glpi_tracking.assign= '6' 0.000
6 SELECT *
FROM glpi_users
WHERE ID='6' 0.000
7 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
8 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='1'
ORDER BY glpi_docs.date_mod DESC 0.001
9 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
10 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='2'
ORDER BY glpi_docs.date_mod DESC 0.001
11 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
12 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='4'
ORDER BY glpi_docs.date_mod DESC 0.001
13 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
14 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='5'
ORDER BY glpi_docs.date_mod DESC 0.001
15 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
16 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='6'
ORDER BY glpi_docs.date_mod DESC 0.001
17 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
18 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='7'
ORDER BY glpi_docs.date_mod DESC 0.000
19 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
20 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='8'
ORDER BY glpi_docs.date_mod DESC 0.000
21 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
22 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='9'
ORDER BY glpi_docs.date_mod DESC 0.001
23 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
24 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='10'
ORDER BY glpi_docs.date_mod DESC 0.000
25 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
26 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='11'
ORDER BY glpi_docs.date_mod DESC 0.000
27 SELECT *
FROM glpi_plugin_ticketreport_config
WHERE (ID = 1) 0.000
28 SELECT glpi_docs.*, glpi_entities.ID AS entity
FROM glpi_docs
LEFT JOIN glpi_entities ON (glpi_docs.FK_entities=glpi_entities.ID)
WHERE rubrique='0' AND glpi_docs.date_mod >= '2008-09-22' AND glpi_docs.date_mod <= '2008-09-29' AND glpi_docs.FK_tracking ='12'
ORDER BY glpi_docs.date_mod DESC 0.000
POST VARIABLEServer : Windows 2003 - Apache 2.2.23 - Php 5.4.11 - Mysql 5.5.30 - Glpi 0.83.7
Offline
#4 2008-09-30 15:25:05
- tsmr
- GLPI-DEV
- From: Rennes
- Registered: 2005-08-26
- Posts: 11,632
- Website
Re: ticketreport : Affichage vide
Le tableau reste vide ca veut dire quoi ?
Xavier Caillaud
Blog GLPI Infotel
Offline
#5 2008-09-30 15:35:53
- TheHinou
- Member
- Registered: 2008-07-03
- Posts: 434
Re: ticketreport : Affichage vide
Ben ca donne ca quoi
genre j'ai pas de ticket ...
Server : Windows 2003 - Apache 2.2.23 - Php 5.4.11 - Mysql 5.5.30 - Glpi 0.83.7
Offline
#6 2008-09-30 15:36:54
- tsmr
- GLPI-DEV
- From: Rennes
- Registered: 2005-08-26
- Posts: 11,632
- Website
Re: ticketreport : Affichage vide
Il faut d'abord les générer les rapports : dans le l'onglet plugins dans le detail d'un ticket
Xavier Caillaud
Blog GLPI Infotel
Offline
#7 2008-09-30 16:38:41
- TheHinou
- Member
- Registered: 2008-07-03
- Posts: 434
Re: ticketreport : Affichage vide
Ok les rapports se génère bien et je ne voyais pas le plug-in fonctionnant de cette façon
Par contre il faut impérativement que la date de fin soit suppérieur à la date voulu sinon ils ne sont pas affiché
Donc si on veux toute les fiches sortie le 30 septembre il faut sélectionner du 30/09 au 01/10 selectionner du 30 au 30 ne fonctionne pas
Merci, tu peux cloturer
Server : Windows 2003 - Apache 2.2.23 - Php 5.4.11 - Mysql 5.5.30 - Glpi 0.83.7
Offline
Pages: 1
Topic closed