suppression impossible des reservation

lcrprod · 2006-08-23 11:55:09

bonjour,

nous n'arrivons pas a supprimer n'y modifié les reservation d'un Périphérique. Nous n'avons aucun message d'erreur pour nous guider.

Nous utilison la version 0.68 sous mac os X 10.3.9 avec mysql 4.1.12.

Quelqu'un a déjà eut le probléme.

christophe

MoYo · 2006-08-23 12:30:54

oui il y a deja eut le problème et meme la réponse posté 2 fois au moins deja sur le forum.

Le problème sera réglé avec la 0.68.1

JMD · 2006-08-23 13:51:31

Faites une recherche sur le forum , il y a meme le patch si vous ne voulez pas attendre.

lcrprod · 2006-08-23 22:28:26

bonsoir,

avant de poster j'ai lancer une recherche.

Apparament, elle était mauvaise. snifff.

j'ai relancé malgrés tous une recherche mais rien donnée encore moins de patch.

avez vous le lien vers le message en question afin que je tente d'appliquer le patch...

Merci.

JMD · 2006-08-24 05:03:15

http://glpi-project.org/forum/viewtopic.php?id=3719

lcrprod · 2006-08-24 07:10:50

forcenent je n'avais pas lancé la recherche en anglais....

merci pour l'info.

christophe

Last edited by lcrprod (2006-08-24 07:12:29)

MoYo · 2006-08-24 07:17:06

et oui GLPI est un projet international

lcrprod · 2006-08-24 09:25:29

j'ai fais la modicifation sur le fichier /front/reservation.php mais cela ne change rien.

j'ai donc activ étivé le mode debug poursavoir ce qu'il réalise lors de la suppréssion.

voici le résultat:
-----------------------------
D => 362
id_item => 6
____data_id_user1697139930 =>
id_user => 6
____begin_date_show => 24-08-2006
begin_date => 2006-08-24
begin_hour => 8
begin_min => 0
____end_date_show => 24-08-2006
end_date => 2006-08-24
end_hour => 8
end_min => 15
comment => en test de reservation
clear_resa => Supprimer
GET VARIABLE
mois_courant => 08
annee_courant => 2006
SESSION VARIABLE
glpiID => 6
glpiname => christophe
glpirealname => christophe ROUSSEAU
glpifirstname =>
glpilanguage => fr_FR
glpitracking_order => yes
glpiauthorisation => 1
glpiextauth => 0
glpisearchcount => Array
glpisearchcount2 => Array
glpiroot => /glpi
glpilist_limit => 50
glpicrontimer => 1156403610
glpiprofile => Array
ID => 3
name => 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 => r
reservation_helpdesk => 1
reservation_central => w
reports => r
ocsng => w
dropdown => w
device => w
typedoc => w
link => w
config => w
search_config => w
update => r
profile => r
user => w
group => 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_ticket => 1
show_full_ticket => 1
observe_ticket => 1
show_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_hardware_type => 8388734
glpi_plugins => Array
0 => activity
1 => addressing
2 => archires
3 => barscode
4 => outlookical
5 => projet
6 => wol
glpi_plugin_activity_profile => Array
ID => 3
name => admin
interface => activity
is_default => 0
activity => w
statistics => r
create_activity => 1
update_activity => 1
delete_activity =>
all_users =>
glpi_plugin_barscode_profile => Array
ID => 3
name => admin
interface => barscode
is_default => 0
barscode => r
glpi_plugin_outlookical_profile => Array
ID => 3
name => admin
interface => outlookical
is_default => 0
outlookical => w
mailing => 1
mailing_config => 0
glpi_plugin_projet_profile => Array
ID => 3
name => admin
interface => project
is_default => 0
project => w
create_project => 1
update_project => 1
delete_project => 0
all_project => 1
create_task => 1
update_task => 1
delete_task => 1
all_task => 1
MESSAGE_AFTER_REDIRECT =>
glpi_viewcentral => my
SQL REQUEST

Number of request: 128

Total Time: 0.312s
N° 1 :
SELECT FK_profiles
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 2 :
SELECT FK_profiles, ID
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 3 :
SELECT *
FROM glpi_plugin_activity_profiles
WHERE (ID = '3')
Time: 0.002sN° 4 :
SELECT FK_profiles
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 5 :
SELECT FK_profiles, ID
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 6 :
SELECT *
FROM glpi_plugin_barscode_profiles
WHERE (ID = '3')
Time: 0.002sN° 7 :
SELECT FK_profiles
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 8 :
SELECT FK_profiles, ID
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 9 :
SELECT *
FROM glpi_plugin_outlookical_profiles
WHERE (ID = '3')
Time: 0.002sN° 10 :
SELECT FK_profiles
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 11 :
SELECT FK_profiles, ID
FROM glpi_users_profiles
WHERE (FK_users = '6')
Time: 0.002sN° 12 :
SELECT *
FROM glpi_plugin_project_profiles
WHERE (ID = '3')
Time: 0.002sN° 13 :
SELECT *
FROM glpi_reservation_resa
WHERE (ID = '3')
Time: 0.002sN° 14 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 15 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 16 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 17 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 18 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-01 00:00:00' < begin AND '2006-08-01 23:59:59' > begin) OR ('2006-08-01 00:00:00' < end AND '2006-08-01 23:59:59' > end) OR (begin < '2006-08-01 00:00:00' AND end > '2006-08-01 00:00:00') OR (begin < '2006-08-01 23:59:59' AND end > '2006-08-01 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 19 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 20 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 21 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-02 00:00:00' < begin AND '2006-08-02 23:59:59' > begin) OR ('2006-08-02 00:00:00' < end AND '2006-08-02 23:59:59' > end) OR (begin < '2006-08-02 00:00:00' AND end > '2006-08-02 00:00:00') OR (begin < '2006-08-02 23:59:59' AND end > '2006-08-02 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 22 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 23 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 24 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-03 00:00:00' < begin AND '2006-08-03 23:59:59' > begin) OR ('2006-08-03 00:00:00' < end AND '2006-08-03 23:59:59' > end) OR (begin < '2006-08-03 00:00:00' AND end > '2006-08-03 00:00:00') OR (begin < '2006-08-03 23:59:59' AND end > '2006-08-03 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 25 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 26 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 27 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-04 00:00:00' < begin AND '2006-08-04 23:59:59' > begin) OR ('2006-08-04 00:00:00' < end AND '2006-08-04 23:59:59' > end) OR (begin < '2006-08-04 00:00:00' AND end > '2006-08-04 00:00:00') OR (begin < '2006-08-04 23:59:59' AND end > '2006-08-04 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 28 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 29 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 30 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-05 00:00:00' < begin AND '2006-08-05 23:59:59' > begin) OR ('2006-08-05 00:00:00' < end AND '2006-08-05 23:59:59' > end) OR (begin < '2006-08-05 00:00:00' AND end > '2006-08-05 00:00:00') OR (begin < '2006-08-05 23:59:59' AND end > '2006-08-05 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 31 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 32 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 33 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-06 00:00:00' < begin AND '2006-08-06 23:59:59' > begin) OR ('2006-08-06 00:00:00' < end AND '2006-08-06 23:59:59' > end) OR (begin < '2006-08-06 00:00:00' AND end > '2006-08-06 00:00:00') OR (begin < '2006-08-06 23:59:59' AND end > '2006-08-06 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 34 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 35 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 36 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-07 00:00:00' < begin AND '2006-08-07 23:59:59' > begin) OR ('2006-08-07 00:00:00' < end AND '2006-08-07 23:59:59' > end) OR (begin < '2006-08-07 00:00:00' AND end > '2006-08-07 00:00:00') OR (begin < '2006-08-07 23:59:59' AND end > '2006-08-07 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 37 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 38 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 39 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-08 00:00:00' < begin AND '2006-08-08 23:59:59' > begin) OR ('2006-08-08 00:00:00' < end AND '2006-08-08 23:59:59' > end) OR (begin < '2006-08-08 00:00:00' AND end > '2006-08-08 00:00:00') OR (begin < '2006-08-08 23:59:59' AND end > '2006-08-08 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 40 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 41 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 42 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-09 00:00:00' < begin AND '2006-08-09 23:59:59' > begin) OR ('2006-08-09 00:00:00' < end AND '2006-08-09 23:59:59' > end) OR (begin < '2006-08-09 00:00:00' AND end > '2006-08-09 00:00:00') OR (begin < '2006-08-09 23:59:59' AND end > '2006-08-09 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 43 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 44 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 45 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-10 00:00:00' < begin AND '2006-08-10 23:59:59' > begin) OR ('2006-08-10 00:00:00' < end AND '2006-08-10 23:59:59' > end) OR (begin < '2006-08-10 00:00:00' AND end > '2006-08-10 00:00:00') OR (begin < '2006-08-10 23:59:59' AND end > '2006-08-10 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 46 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 47 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 48 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-11 00:00:00' < begin AND '2006-08-11 23:59:59' > begin) OR ('2006-08-11 00:00:00' < end AND '2006-08-11 23:59:59' > end) OR (begin < '2006-08-11 00:00:00' AND end > '2006-08-11 00:00:00') OR (begin < '2006-08-11 23:59:59' AND end > '2006-08-11 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 49 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 50 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 51 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-12 00:00:00' < begin AND '2006-08-12 23:59:59' > begin) OR ('2006-08-12 00:00:00' < end AND '2006-08-12 23:59:59' > end) OR (begin < '2006-08-12 00:00:00' AND end > '2006-08-12 00:00:00') OR (begin < '2006-08-12 23:59:59' AND end > '2006-08-12 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 52 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 53 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 54 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-13 00:00:00' < begin AND '2006-08-13 23:59:59' > begin) OR ('2006-08-13 00:00:00' < end AND '2006-08-13 23:59:59' > end) OR (begin < '2006-08-13 00:00:00' AND end > '2006-08-13 00:00:00') OR (begin < '2006-08-13 23:59:59' AND end > '2006-08-13 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 55 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 56 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 57 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-14 00:00:00' < begin AND '2006-08-14 23:59:59' > begin) OR ('2006-08-14 00:00:00' < end AND '2006-08-14 23:59:59' > end) OR (begin < '2006-08-14 00:00:00' AND end > '2006-08-14 00:00:00') OR (begin < '2006-08-14 23:59:59' AND end > '2006-08-14 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 58 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 59 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 60 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-15 00:00:00' < begin AND '2006-08-15 23:59:59' > begin) OR ('2006-08-15 00:00:00' < end AND '2006-08-15 23:59:59' > end) OR (begin < '2006-08-15 00:00:00' AND end > '2006-08-15 00:00:00') OR (begin < '2006-08-15 23:59:59' AND end > '2006-08-15 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 61 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 62 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 63 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-16 00:00:00' < begin AND '2006-08-16 23:59:59' > begin) OR ('2006-08-16 00:00:00' < end AND '2006-08-16 23:59:59' > end) OR (begin < '2006-08-16 00:00:00' AND end > '2006-08-16 00:00:00') OR (begin < '2006-08-16 23:59:59' AND end > '2006-08-16 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 64 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 65 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 66 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-17 00:00:00' < begin AND '2006-08-17 23:59:59' > begin) OR ('2006-08-17 00:00:00' < end AND '2006-08-17 23:59:59' > end) OR (begin < '2006-08-17 00:00:00' AND end > '2006-08-17 00:00:00') OR (begin < '2006-08-17 23:59:59' AND end > '2006-08-17 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 67 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 68 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 69 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-18 00:00:00' < begin AND '2006-08-18 23:59:59' > begin) OR ('2006-08-18 00:00:00' < end AND '2006-08-18 23:59:59' > end) OR (begin < '2006-08-18 00:00:00' AND end > '2006-08-18 00:00:00') OR (begin < '2006-08-18 23:59:59' AND end > '2006-08-18 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 70 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 71 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 72 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-19 00:00:00' < begin AND '2006-08-19 23:59:59' > begin) OR ('2006-08-19 00:00:00' < end AND '2006-08-19 23:59:59' > end) OR (begin < '2006-08-19 00:00:00' AND end > '2006-08-19 00:00:00') OR (begin < '2006-08-19 23:59:59' AND end > '2006-08-19 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 73 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 74 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 75 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-20 00:00:00' < begin AND '2006-08-20 23:59:59' > begin) OR ('2006-08-20 00:00:00' < end AND '2006-08-20 23:59:59' > end) OR (begin < '2006-08-20 00:00:00' AND end > '2006-08-20 00:00:00') OR (begin < '2006-08-20 23:59:59' AND end > '2006-08-20 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 76 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 77 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 78 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-21 00:00:00' < begin AND '2006-08-21 23:59:59' > begin) OR ('2006-08-21 00:00:00' < end AND '2006-08-21 23:59:59' > end) OR (begin < '2006-08-21 00:00:00' AND end > '2006-08-21 00:00:00') OR (begin < '2006-08-21 23:59:59' AND end > '2006-08-21 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 79 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 80 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 81 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-22 00:00:00' < begin AND '2006-08-22 23:59:59' > begin) OR ('2006-08-22 00:00:00' < end AND '2006-08-22 23:59:59' > end) OR (begin < '2006-08-22 00:00:00' AND end > '2006-08-22 00:00:00') OR (begin < '2006-08-22 23:59:59' AND end > '2006-08-22 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 82 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 83 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 84 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-23 00:00:00' < begin AND '2006-08-23 23:59:59' > begin) OR ('2006-08-23 00:00:00' < end AND '2006-08-23 23:59:59' > end) OR (begin < '2006-08-23 00:00:00' AND end > '2006-08-23 00:00:00') OR (begin < '2006-08-23 23:59:59' AND end > '2006-08-23 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 85 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 86 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 87 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-24 00:00:00' < begin AND '2006-08-24 23:59:59' > begin) OR ('2006-08-24 00:00:00' < end AND '2006-08-24 23:59:59' > end) OR (begin < '2006-08-24 00:00:00' AND end > '2006-08-24 00:00:00') OR (begin < '2006-08-24 23:59:59' AND end > '2006-08-24 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 88 :
SELECT *
FROM glpi_users
WHERE (ID = '6')
Time: 0.002sN° 89 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 90 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 91 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-25 00:00:00' < begin AND '2006-08-25 23:59:59' > begin) OR ('2006-08-25 00:00:00' < end AND '2006-08-25 23:59:59' > end) OR (begin < '2006-08-25 00:00:00' AND end > '2006-08-25 00:00:00') OR (begin < '2006-08-25 23:59:59' AND end > '2006-08-25 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 92 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 93 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 94 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-26 00:00:00' < begin AND '2006-08-26 23:59:59' > begin) OR ('2006-08-26 00:00:00' < end AND '2006-08-26 23:59:59' > end) OR (begin < '2006-08-26 00:00:00' AND end > '2006-08-26 00:00:00') OR (begin < '2006-08-26 23:59:59' AND end > '2006-08-26 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 95 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 96 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 97 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-27 00:00:00' < begin AND '2006-08-27 23:59:59' > begin) OR ('2006-08-27 00:00:00' < end AND '2006-08-27 23:59:59' > end) OR (begin < '2006-08-27 00:00:00' AND end > '2006-08-27 00:00:00') OR (begin < '2006-08-27 23:59:59' AND end > '2006-08-27 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 98 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 99 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 100 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-28 00:00:00' < begin AND '2006-08-28 23:59:59' > begin) OR ('2006-08-28 00:00:00' < end AND '2006-08-28 23:59:59' > end) OR (begin < '2006-08-28 00:00:00' AND end > '2006-08-28 00:00:00') OR (begin < '2006-08-28 23:59:59' AND end > '2006-08-28 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 101 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 102 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 103 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-29 00:00:00' < begin AND '2006-08-29 23:59:59' > begin) OR ('2006-08-29 00:00:00' < end AND '2006-08-29 23:59:59' > end) OR (begin < '2006-08-29 00:00:00' AND end > '2006-08-29 00:00:00') OR (begin < '2006-08-29 23:59:59' AND end > '2006-08-29 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 104 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 105 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.002sN° 106 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-30 00:00:00' < begin AND '2006-08-30 23:59:59' > begin) OR ('2006-08-30 00:00:00' < end AND '2006-08-30 23:59:59' > end) OR (begin < '2006-08-30 00:00:00' AND end > '2006-08-30 00:00:00') OR (begin < '2006-08-30 23:59:59' AND end > '2006-08-30 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 107 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 108 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 109 :
SELECT *
FROM glpi_reservation_resa
WHERE (('2006-08-31 00:00:00' < begin AND '2006-08-31 23:59:59' > begin) OR ('2006-08-31 00:00:00' < end AND '2006-08-31 23:59:59' > end) OR (begin < '2006-08-31 00:00:00' AND end > '2006-08-31 00:00:00') OR (begin < '2006-08-31 23:59:59' AND end > '2006-08-31 23:59:59')) AND id_item=6
ORDER BY begin
Time: 0.003sN° 110 :
select ID
FROM glpi_reservation_item
ORDER BY device_type
Time: 0.002sN° 111 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '1')
Time: 0.002sN° 112 :
SELECT *
FROM glpi_computers
WHERE (ID = '22')
Time: 0.003sN° 113 :
select *
FROM glpi_dropdown_locations
WHERE (ID = '7')
Time: 0.002sN° 114 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '2')
Time: 0.002sN° 115 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '2')
Time: 0.002sN° 116 :
select *
FROM glpi_dropdown_locations
WHERE (ID = '16')
Time: 0.002sN° 117 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '3')
Time: 0.002sN° 118 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '3')
Time: 0.003sN° 119 :
select *
FROM glpi_dropdown_locations
WHERE (ID = '16')
Time: 0.002sN° 120 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '4')
Time: 0.002sN° 121 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '4')
Time: 0.003sN° 122 :
select *
FROM glpi_dropdown_locations
WHERE (ID = '16')
Time: 0.002sN° 123 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '5')
Time: 0.002sN° 124 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '5')
Time: 0.003sN° 125 :
select *
FROM glpi_dropdown_locations
WHERE (ID = '7')
Time: 0.002sN° 126 :
SELECT *
FROM glpi_reservation_item
WHERE (ID = '6')
Time: 0.002sN° 127 :
SELECT *
FROM glpi_peripherals
WHERE (ID = '6')
Time: 0.003sN° 128 :
select *
FROM glpi_dropdown_locations
WHERE (ID = '7')
Time: 0.002s
-----------------------------

si cela vous parle.

christophe

yoyox · 2006-08-24 16:27:55

Salut,

En fait un autre patch doit être appliqué.
Il se trouve ici :
https://dev.indepnet.net:8080/glpi/changeset/3721

Lionel

JMD · 2006-08-24 16:52:47

Là on perd un peu notre temps et le votre en bidouillage, le bug est corrigé dans la version 0.68.1 qui sort ce WE.

Attendez quelques jours et tout rentrera dans l'ordre.

sharkkan · 2006-08-29 11:31:25

Bonjour

J'ai fait une mise à jour de 0.68 RC2 en 0.68.1 et j'ai aussi le problème de suppression impossible des réservations.
cela vient-il de ma mise à jour et dois-je appliquer les patchs cités ci-dessus sur une 0.68.1 ?

merci

Version GLPI 0.68.1 sur Windows 2003 SP1 et MySQL 5.0.21

JMD · 2006-08-29 11:59:21

Bonjour,

Le bug des reservations a été corrigé dans la version 0.68.1. Donc vous n'avez pas de patch à appliquer.

Pour ce qui est de la mise à jour ..... cf http://glpi-project.org/wiki/doku.php?id=fr:faqgenerale

sharkkan · 2006-08-29 14:32:39

Merci JMD de votre réponse mais je ne la comprend pas car comme je l'ai précisé, je suis en 0.68.1 après mise à jour et j'ai encore le bug ..

emgenet · 2006-08-29 15:09:45

Pour info, moi je suis en vacances (je sais jm c'est interdit d'en parler, mais c'est pour la suite). Je n'ai pas encore basculé en 0.68.1 (vacances !). Par contre j'avais récupérer les 3 fichiers modifiés lors de ce post :http://glpi-project.org/forum/viewtopic.php?id=3719.

Et ca marche nickel depuis !

@+

Last edited by emgenet (2006-08-29 15:10:07)

sharkkan · 2006-08-31 12:05:19

personne pour confirmer que le bug existe toujours en 0.68.1 ou cela vient de mon install ?

JMD · 2006-08-31 12:55:24

Je comprends pas votre question là. Je vous ai dit que ce bug avait été corrigé dans la 0.68.1.

Je viens de reverifier chez moi et ça fonctionne trés bien.

D'autre part vous pouvez vérifier vous même sur la démo en ligne par exemple.

Donc je pense que ça vient de votre mise à jour....

Forum GLPI-Project

Announcement

#1 2006-08-23 11:55:09

suppression impossible des reservation

#2 2006-08-23 12:30:54

Re: suppression impossible des reservation

#3 2006-08-23 13:51:31

Re: suppression impossible des reservation

#4 2006-08-23 22:28:26

Re: suppression impossible des reservation

#5 2006-08-24 05:03:15

Re: suppression impossible des reservation

#6 2006-08-24 07:10:50

Re: suppression impossible des reservation

#7 2006-08-24 07:17:06

Re: suppression impossible des reservation

#8 2006-08-24 09:25:29

Re: suppression impossible des reservation

#9 2006-08-24 16:27:55

Re: suppression impossible des reservation

#10 2006-08-24 16:52:47

Re: suppression impossible des reservation

#11 2006-08-29 11:31:25

Re: suppression impossible des reservation

#12 2006-08-29 11:59:21

Re: suppression impossible des reservation

#13 2006-08-29 14:32:39

Re: suppression impossible des reservation

#14 2006-08-29 15:09:45

Re: suppression impossible des reservation

#15 2006-08-31 12:05:19

Re: suppression impossible des reservation

#16 2006-08-31 12:55:24

Re: suppression impossible des reservation

Board footer