GLPI 0.7 RC1 suppression des reservations impossible

siegfried · 2007-10-03 15:30:39

Bonjour,

J'ai fait la mise à jour de la version 0.7 Beta vers la RC1.
Un utilisateur m'a soumis un bug.
Il est impossible de supprimer une reservation de matériel, j'ai essayé en tant que super-admin et l'utilisateur en Post-only.
Pourant je reçoit bien le mail de confirmation pour la suppression.

Ci après la requête SQL en mode Debug:

GLPI MODE DEBUG
SQL REQUEST : 58 Queries took 0.053s
N° Queries Time Errors
1 SELECT count(*) AS cpt
FROM glpi_entities 0.000
2 SELECT count(*) AS cpt
FROM glpi_entities 0.000
3 SELECT *
FROM glpi_reservation_resa
WHERE (ID = 87) 0.001
4 SELECT *
FROM glpi_reservation_resa
WHERE (ID = 87) 0.000
5 SELECT *
FROM glpi_mailing
WHERE type='resa' 0.001
6 SELECT *
FROM glpi_users
WHERE (ID = 6) 0.001
7 SELECT *
FROM glpi_users
WHERE (ID = 6) 0.000
8 SELECT *
FROM glpi_reservation_item
WHERE (ID = 2) 0.001
9 SELECT *
FROM glpi_peripherals
WHERE (ID = 12) 0.001
10 SELECT *
FROM glpi_users
WHERE (ID = 6) 0.001
11 SELECT *
FROM glpi_reservation_item
WHERE (ID = 2) 0.000
12 SELECT *
FROM glpi_peripherals
WHERE (ID = 12) 0.001
13 SELECT *
FROM glpi_users
WHERE (ID = 6) 0.001
14 SELECT *
FROM glpi_reservation_item
WHERE (ID = 2) 0.001
15 SELECT *
FROM glpi_peripherals
WHERE (ID = 12) 0.001
16 SELECT *
FROM glpi_users
WHERE (ID = 6) 0.001
17 SELECT *
FROM glpi_reservation_item
WHERE (ID = 2) 0.001
18 SELECT *
FROM glpi_peripherals
WHERE (ID = 12) 0.001
19 SELECT *
FROM glpi_users
WHERE (ID = 6) 0.001
20 SELECT *
FROM glpi_reservation_item
WHERE (ID = 2) 0.001
21 SELECT *
FROM glpi_peripherals
WHERE (ID = 12) 0.001
22 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-01 00:00:00' < begin AND '2007-10-01 23:59:59' > begin) OR ('2007-10-01 00:00:00' < end AND '2007-10-01 23:59:59' > end) OR (begin < '2007-10-01 00:00:00' AND end > '2007-10-01 00:00:00') OR (begin < '2007-10-01 23:59:59' AND end > '2007-10-01 23:59:59')) AND id_item=2
ORDER BY begin 0.001
23 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-02 00:00:00' < begin AND '2007-10-02 23:59:59' > begin) OR ('2007-10-02 00:00:00' < end AND '2007-10-02 23:59:59' > end) OR (begin < '2007-10-02 00:00:00' AND end > '2007-10-02 00:00:00') OR (begin < '2007-10-02 23:59:59' AND end > '2007-10-02 23:59:59')) AND id_item=2
ORDER BY begin 0.001
24 SELECT *
FROM glpi_users
WHERE (ID = 6) 0.001
25 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-03 00:00:00' < begin AND '2007-10-03 23:59:59' > begin) OR ('2007-10-03 00:00:00' < end AND '2007-10-03 23:59:59' > end) OR (begin < '2007-10-03 00:00:00' AND end > '2007-10-03 00:00:00') OR (begin < '2007-10-03 23:59:59' AND end > '2007-10-03 23:59:59')) AND id_item=2
ORDER BY begin 0.001
26 SELECT *
FROM glpi_users
WHERE (ID = 50) 0.001
27 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-04 00:00:00' < begin AND '2007-10-04 23:59:59' > begin) OR ('2007-10-04 00:00:00' < end AND '2007-10-04 23:59:59' > end) OR (begin < '2007-10-04 00:00:00' AND end > '2007-10-04 00:00:00') OR (begin < '2007-10-04 23:59:59' AND end > '2007-10-04 23:59:59')) AND id_item=2
ORDER BY begin 0.001
28 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-05 00:00:00' < begin AND '2007-10-05 23:59:59' > begin) OR ('2007-10-05 00:00:00' < end AND '2007-10-05 23:59:59' > end) OR (begin < '2007-10-05 00:00:00' AND end > '2007-10-05 00:00:00') OR (begin < '2007-10-05 23:59:59' AND end > '2007-10-05 23:59:59')) AND id_item=2
ORDER BY begin 0.001
29 SELECT *
FROM glpi_users
WHERE (ID = 50) 0.001
30 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-06 00:00:00' < begin AND '2007-10-06 23:59:59' > begin) OR ('2007-10-06 00:00:00' < end AND '2007-10-06 23:59:59' > end) OR (begin < '2007-10-06 00:00:00' AND end > '2007-10-06 00:00:00') OR (begin < '2007-10-06 23:59:59' AND end > '2007-10-06 23:59:59')) AND id_item=2
ORDER BY begin 0.001
31 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-07 00:00:00' < begin AND '2007-10-07 23:59:59' > begin) OR ('2007-10-07 00:00:00' < end AND '2007-10-07 23:59:59' > end) OR (begin < '2007-10-07 00:00:00' AND end > '2007-10-07 00:00:00') OR (begin < '2007-10-07 23:59:59' AND end > '2007-10-07 23:59:59')) AND id_item=2
ORDER BY begin 0.001
32 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-08 00:00:00' < begin AND '2007-10-08 23:59:59' > begin) OR ('2007-10-08 00:00:00' < end AND '2007-10-08 23:59:59' > end) OR (begin < '2007-10-08 00:00:00' AND end > '2007-10-08 00:00:00') OR (begin < '2007-10-08 23:59:59' AND end > '2007-10-08 23:59:59')) AND id_item=2
ORDER BY begin 0.001
33 SELECT *
FROM glpi_users
WHERE (ID = 50) 0.001
34 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-09 00:00:00' < begin AND '2007-10-09 23:59:59' > begin) OR ('2007-10-09 00:00:00' < end AND '2007-10-09 23:59:59' > end) OR (begin < '2007-10-09 00:00:00' AND end > '2007-10-09 00:00:00') OR (begin < '2007-10-09 23:59:59' AND end > '2007-10-09 23:59:59')) AND id_item=2
ORDER BY begin 0.001
35 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-10 00:00:00' < begin AND '2007-10-10 23:59:59' > begin) OR ('2007-10-10 00:00:00' < end AND '2007-10-10 23:59:59' > end) OR (begin < '2007-10-10 00:00:00' AND end > '2007-10-10 00:00:00') OR (begin < '2007-10-10 23:59:59' AND end > '2007-10-10 23:59:59')) AND id_item=2
ORDER BY begin 0.001
36 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-11 00:00:00' < begin AND '2007-10-11 23:59:59' > begin) OR ('2007-10-11 00:00:00' < end AND '2007-10-11 23:59:59' > end) OR (begin < '2007-10-11 00:00:00' AND end > '2007-10-11 00:00:00') OR (begin < '2007-10-11 23:59:59' AND end > '2007-10-11 23:59:59')) AND id_item=2
ORDER BY begin 0.001
37 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-12 00:00:00' < begin AND '2007-10-12 23:59:59' > begin) OR ('2007-10-12 00:00:00' < end AND '2007-10-12 23:59:59' > end) OR (begin < '2007-10-12 00:00:00' AND end > '2007-10-12 00:00:00') OR (begin < '2007-10-12 23:59:59' AND end > '2007-10-12 23:59:59')) AND id_item=2
ORDER BY begin 0.001
38 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-13 00:00:00' < begin AND '2007-10-13 23:59:59' > begin) OR ('2007-10-13 00:00:00' < end AND '2007-10-13 23:59:59' > end) OR (begin < '2007-10-13 00:00:00' AND end > '2007-10-13 00:00:00') OR (begin < '2007-10-13 23:59:59' AND end > '2007-10-13 23:59:59')) AND id_item=2
ORDER BY begin 0.001
39 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-14 00:00:00' < begin AND '2007-10-14 23:59:59' > begin) OR ('2007-10-14 00:00:00' < end AND '2007-10-14 23:59:59' > end) OR (begin < '2007-10-14 00:00:00' AND end > '2007-10-14 00:00:00') OR (begin < '2007-10-14 23:59:59' AND end > '2007-10-14 23:59:59')) AND id_item=2
ORDER BY begin 0.001
40 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-15 00:00:00' < begin AND '2007-10-15 23:59:59' > begin) OR ('2007-10-15 00:00:00' < end AND '2007-10-15 23:59:59' > end) OR (begin < '2007-10-15 00:00:00' AND end > '2007-10-15 00:00:00') OR (begin < '2007-10-15 23:59:59' AND end > '2007-10-15 23:59:59')) AND id_item=2
ORDER BY begin 0.001
41 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-16 00:00:00' < begin AND '2007-10-16 23:59:59' > begin) OR ('2007-10-16 00:00:00' < end AND '2007-10-16 23:59:59' > end) OR (begin < '2007-10-16 00:00:00' AND end > '2007-10-16 00:00:00') OR (begin < '2007-10-16 23:59:59' AND end > '2007-10-16 23:59:59')) AND id_item=2
ORDER BY begin 0.001
42 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-17 00:00:00' < begin AND '2007-10-17 23:59:59' > begin) OR ('2007-10-17 00:00:00' < end AND '2007-10-17 23:59:59' > end) OR (begin < '2007-10-17 00:00:00' AND end > '2007-10-17 00:00:00') OR (begin < '2007-10-17 23:59:59' AND end > '2007-10-17 23:59:59')) AND id_item=2
ORDER BY begin 0.001
43 SELECT *
FROM glpi_users
WHERE (ID = 50) 0.001
44 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-18 00:00:00' < begin AND '2007-10-18 23:59:59' > begin) OR ('2007-10-18 00:00:00' < end AND '2007-10-18 23:59:59' > end) OR (begin < '2007-10-18 00:00:00' AND end > '2007-10-18 00:00:00') OR (begin < '2007-10-18 23:59:59' AND end > '2007-10-18 23:59:59')) AND id_item=2
ORDER BY begin 0.001
45 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-19 00:00:00' < begin AND '2007-10-19 23:59:59' > begin) OR ('2007-10-19 00:00:00' < end AND '2007-10-19 23:59:59' > end) OR (begin < '2007-10-19 00:00:00' AND end > '2007-10-19 00:00:00') OR (begin < '2007-10-19 23:59:59' AND end > '2007-10-19 23:59:59')) AND id_item=2
ORDER BY begin 0.001
46 SELECT *
FROM glpi_users
WHERE (ID = 50) 0.001
47 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-20 00:00:00' < begin AND '2007-10-20 23:59:59' > begin) OR ('2007-10-20 00:00:00' < end AND '2007-10-20 23:59:59' > end) OR (begin < '2007-10-20 00:00:00' AND end > '2007-10-20 00:00:00') OR (begin < '2007-10-20 23:59:59' AND end > '2007-10-20 23:59:59')) AND id_item=2
ORDER BY begin 0.001
48 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-21 00:00:00' < begin AND '2007-10-21 23:59:59' > begin) OR ('2007-10-21 00:00:00' < end AND '2007-10-21 23:59:59' > end) OR (begin < '2007-10-21 00:00:00' AND end > '2007-10-21 00:00:00') OR (begin < '2007-10-21 23:59:59' AND end > '2007-10-21 23:59:59')) AND id_item=2
ORDER BY begin 0.001
49 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-22 00:00:00' < begin AND '2007-10-22 23:59:59' > begin) OR ('2007-10-22 00:00:00' < end AND '2007-10-22 23:59:59' > end) OR (begin < '2007-10-22 00:00:00' AND end > '2007-10-22 00:00:00') OR (begin < '2007-10-22 23:59:59' AND end > '2007-10-22 23:59:59')) AND id_item=2
ORDER BY begin 0.001
50 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-23 00:00:00' < begin AND '2007-10-23 23:59:59' > begin) OR ('2007-10-23 00:00:00' < end AND '2007-10-23 23:59:59' > end) OR (begin < '2007-10-23 00:00:00' AND end > '2007-10-23 00:00:00') OR (begin < '2007-10-23 23:59:59' AND end > '2007-10-23 23:59:59')) AND id_item=2
ORDER BY begin 0.001
51 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-24 00:00:00' < begin AND '2007-10-24 23:59:59' > begin) OR ('2007-10-24 00:00:00' < end AND '2007-10-24 23:59:59' > end) OR (begin < '2007-10-24 00:00:00' AND end > '2007-10-24 00:00:00') OR (begin < '2007-10-24 23:59:59' AND end > '2007-10-24 23:59:59')) AND id_item=2
ORDER BY begin 0.001
52 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-25 00:00:00' < begin AND '2007-10-25 23:59:59' > begin) OR ('2007-10-25 00:00:00' < end AND '2007-10-25 23:59:59' > end) OR (begin < '2007-10-25 00:00:00' AND end > '2007-10-25 00:00:00') OR (begin < '2007-10-25 23:59:59' AND end > '2007-10-25 23:59:59')) AND id_item=2
ORDER BY begin 0.001
53 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-26 00:00:00' < begin AND '2007-10-26 23:59:59' > begin) OR ('2007-10-26 00:00:00' < end AND '2007-10-26 23:59:59' > end) OR (begin < '2007-10-26 00:00:00' AND end > '2007-10-26 00:00:00') OR (begin < '2007-10-26 23:59:59' AND end > '2007-10-26 23:59:59')) AND id_item=2
ORDER BY begin 0.001
54 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-27 00:00:00' < begin AND '2007-10-27 23:59:59' > begin) OR ('2007-10-27 00:00:00' < end AND '2007-10-27 23:59:59' > end) OR (begin < '2007-10-27 00:00:00' AND end > '2007-10-27 00:00:00') OR (begin < '2007-10-27 23:59:59' AND end > '2007-10-27 23:59:59')) AND id_item=2
ORDER BY begin 0.001
55 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-28 00:00:00' < begin AND '2007-10-28 23:59:59' > begin) OR ('2007-10-28 00:00:00' < end AND '2007-10-28 23:59:59' > end) OR (begin < '2007-10-28 00:00:00' AND end > '2007-10-28 00:00:00') OR (begin < '2007-10-28 23:59:59' AND end > '2007-10-28 23:59:59')) AND id_item=2
ORDER BY begin 0.001
56 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-29 00:00:00' < begin AND '2007-10-29 23:59:59' > begin) OR ('2007-10-29 00:00:00' < end AND '2007-10-29 23:59:59' > end) OR (begin < '2007-10-29 00:00:00' AND end > '2007-10-29 00:00:00') OR (begin < '2007-10-29 23:59:59' AND end > '2007-10-29 23:59:59')) AND id_item=2
ORDER BY begin 0.001
57 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-30 00:00:00' < begin AND '2007-10-30 23:59:59' > begin) OR ('2007-10-30 00:00:00' < end AND '2007-10-30 23:59:59' > end) OR (begin < '2007-10-30 00:00:00' AND end > '2007-10-30 00:00:00') OR (begin < '2007-10-30 23:59:59' AND end > '2007-10-30 23:59:59')) AND id_item=2
ORDER BY begin 0.001
58 SELECT *
FROM glpi_reservation_resa
WHERE (('2007-10-31 00:00:00' < begin AND '2007-10-31 23:59:59' > begin) OR ('2007-10-31 00:00:00' < end AND '2007-10-31 23:59:59' > end) OR (begin < '2007-10-31 00:00:00' AND end > '2007-10-31 00:00:00') OR (begin < '2007-10-31 23:59:59' AND end > '2007-10-31 23:59:59')) AND id_item=2
ORDER BY begin 0.001
POST VARIABLE
KEY => VALUE
ID => 87
items =>
KEY => VALUE
2 => 2
____data_203360071 =>
id_user => 6
____begin_date_show => 02-10-2007
begin_date => 2007-10-02
begin_hour => 12:00
____end_date_show => 02-10-2007
end_date => 2007-10-02
end_hour => 13:00
comment => test
clear_resa => Supprimer
GET VARIABLE
KEY => VALUE
ID =>
mois_courant => 10
annee_courant => 2007
SESSION VARIABLE
KEY => VALUE
glpilist_limit => 20
glpilanguage => fr_FR
glpi_plugins =>
MESSAGE_AFTER_REDIRECT =>
glpi_currenttime => 2007-10-03 15:21:37
glpitest => testcookie
glpiID => 6
glpiname => s.marechal
glpirealname => MARECHAL
glpifirstname => Siegfried
glpitracking_order => 0
glpiauthorisation => 1
glpiextauth => 1
glpisearchcount =>
KEY => VALUE
29 => 1
glpisearchcount2 =>
KEY => VALUE
29 => 0
glpiroot => /glpi
glpicrontimer => 1191417489
glpiprofiles =>
KEY => VALUE
4 =>
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_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
group => w
entity => w
transfer => w
logs => r
reminder_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_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_hardware_type => 8388674
show_group_ticket => 0
show_group_hardware => 0
entities =>
KEY => VALUE
425 =>
KEY => VALUE
ID => 0
name =>
completename =>
recursive => 0
1 =>
KEY => VALUE
ID => 1
name => post-only
interface => central
is_default => 1
computer =>
monitor =>
software =>
networking =>
printer =>
peripheral =>
cartridge =>
consumable =>
phone =>
notes =>
contact_enterprise =>
document =>
contract_infocom =>
knowbase =>
faq => r
reservation_helpdesk => 1
reservation_central =>
reports =>
ocsng =>
view_ocsng =>
sync_ocsng =>
dropdown =>
entity_dropdown =>
device =>
typedoc =>
link =>
config =>
rule_tracking =>
rule_ocs =>
rule_ldap =>
rule_softwarecategories =>
search_config =>
search_config_global =>
check_update =>
profile =>
user =>
group =>
entity =>
transfer =>
logs =>
reminder_public =>
backup =>
create_ticket => 1
delete_ticket => 0
comment_ticket => 1
comment_all_ticket => 0
update_ticket => 0
own_ticket => 0
steal_ticket => 0
assign_ticket => 0
show_all_ticket => 0
show_assign_ticket => 0
show_full_ticket => 0
observe_ticket => 1
update_followups => 0
show_planning => 0
show_all_planning => 0
statistic => 0
password_update => 0
helpdesk_hardware => 2
helpdesk_hardware_type => 58
show_group_ticket => 0
show_group_hardware => 0
entities =>
KEY => VALUE
427 =>
KEY => VALUE
ID => 0
name =>
completename =>
recursive => 0
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_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
group => w
entity => w
transfer => w
logs => r
reminder_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_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_hardware_type => 8388674
show_group_ticket => 0
show_group_hardware => 0
entities =>
KEY => VALUE
425 =>
KEY => VALUE
ID => 0
name =>
completename =>
recursive => 0
glpi_entities_tree =>
KEY => VALUE
0 =>
KEY => VALUE
0 =>
KEY => VALUE
tree =>
name => Entité Racine
glpiactiveentities =>
KEY => VALUE
0 => 0
glpi_entities_ancestors =>
glpiactive_entity => 0
glpiactive_entity_name => Entité Racine (Voir Tous)
glpigroups =>
glpi_viewcentral => my
glpisearch =>
KEY => VALUE
29 =>
KEY => VALUE
ID =>
glpimassiveactionselected =>
glpi_configgen => 1

Last edited by siegfried (2007-10-03 15:31:11)

JMD · 2007-10-03 22:15:44

Corrigé ici il me semble : https://dev.indepnet.net:8080/glpi/changeset/5576

siegfried · 2007-10-03 22:42:36

Merci JMD, je teste demain :-) et post le retour

EDIT: Le problème est résolu, merci JMD

Last edited by siegfried (2007-10-04 09:11:53)

MoYo · 2007-10-04 21:39:01

je ferme

Forum GLPI-Project

Announcement

#1 2007-10-03 15:30:39

GLPI 0.7 RC1 suppression des reservations impossible

#2 2007-10-03 22:15:44

Re: GLPI 0.7 RC1 suppression des reservations impossible

#3 2007-10-03 22:42:36

Re: GLPI 0.7 RC1 suppression des reservations impossible

#4 2007-10-04 21:39:01

Re: GLPI 0.7 RC1 suppression des reservations impossible

Board footer