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-01-30 11:40:21
- SylvainD
- Member
- From: Noisy le sec
- Registered: 2008-01-23
- Posts: 40
Réintégration dans le stock d'une cartouche
Bonjour,
La réintégration de cartouche ne fonctionne pas.
Lorsque je clique sur le lien Reintégrer dans le stock, il ne se passe rien, à part un rechargement de la page.
J'en profite pour signaler à qui de droit, qu'il faut un accent sur le "e" de Reintégrer ==> Réintégrer.
-= Sylvain =-
GPLI : 0.70.2
Apache : 2.0.55 / PHP : 5.1.2 / MySQL : 5.0.18
Offline
#2 2008-01-30 18:29:36
- MoYo
- GLPI - Lead
- From: Poitiers
- Registered: 2004-09-13
- Posts: 14,513
- Website
Re: Réintégration dans le stock d'une cartouche
bizarre car je viens de tester sur mon install et je n'ai aucun problème.
D'autres personnes ont ce problème ?
MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI : Support Contribute References Freshmeat
Offline
#3 2008-03-31 15:32:39
- lcrprod
- Member
- From: Saint-Junien
- Registered: 2006-04-12
- Posts: 70
Re: Réintégration dans le stock d'une cartouche
oui nous aussi.
et ce depuis le début: en sachant que nous avons commencé il y a 2 ans avec la 0.6.
Nous utilisons actuellement la version 0.7.2
coridalement.
Offline
#4 2008-08-19 10:47:51
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
Bonjour,
j'ai le même problème que lcrprod en version 0.71.1 et sylvainD
Offline
#5 2008-08-19 11:29:50
- MoYo
- GLPI - Lead
- From: Poitiers
- Registered: 2004-09-13
- Posts: 14,513
- Website
Re: Réintégration dans le stock d'une cartouche
cela fonctionne sur la démo
des infos en mode debug ?
MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI : Support Contribute References Freshmeat
Offline
#6 2008-08-19 15:08:06
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
SQL REQUEST : 25 Queries took 0.005s
N° Queries Time Errors
1 SELECT *
FROM glpi_cartridges_type
WHERE (ID = 39) 0.001
2 SELECT name
FROM glpi_cartridges_type
WHERE ID='39' 0.000
3 SELECT glpi_cartridges_type.ID
FROM glpi_cartridges_type
WHERE ( glpi_cartridges_type.name > 'Q7551X' OR (glpi_cartridges_type.name = 'Q7551X' AND glpi_cartridges_type.ID > '39') ) AND glpi_cartridges_type.deleted='0'
ORDER BY glpi_cartridges_type.name ASC, glpi_cartridges_type.ID ASC 0.001
4 SELECT name
FROM glpi_cartridges_type
WHERE ID=39 0.000
5 SELECT glpi_cartridges_type.ID
FROM glpi_cartridges_type
WHERE (glpi_cartridges_type.name < 'Q7551X' OR (glpi_cartridges_type.name = 'Q7551X' AND glpi_cartridges_type.ID < '39') ) AND glpi_cartridges_type.deleted='0'
ORDER BY glpi_cartridges_type.name DESC, glpi_cartridges_type.ID DESC 0.001
6 SELECT glpi_dropdown_model_printers.name as type, glpi_cartridges_assoc.ID as ID
FROM glpi_cartridges_assoc, glpi_dropdown_model_printers
WHERE glpi_cartridges_assoc.FK_glpi_dropdown_model_printers=glpi_dropdown_model_printers.ID AND glpi_cartridges_assoc.FK_glpi_cartridges_type = '39'
ORDER BY glpi_dropdown_model_printers.name 0.001
7 SELECT *
FROM glpi_dropdown_model_printers
WHERE 1 AND ID NOT IN (-1)
ORDER BY name 0.001
8 SELECT *
FROM glpi_dropdown_model_printers
WHERE ID = '-1' 0.000
9 SELECT count(*) AS COUNT
FROM glpi_cartridges
WHERE (FK_glpi_cartridges_type = '39') 0.000
10 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_use IS NULL) 0.000
11 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_use IS NOT NULL AND date_out IS NULL) 0.000
12 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_out IS NOT NULL) 0.000
13 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39') 0.000
14 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_use IS NULL) 0.000
15 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_use IS NOT NULL AND date_out IS NULL) 0.000
16 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_out IS NOT NULL) 0.000
17 SELECT glpi_cartridges.*, glpi_printers.ID as printID, glpi_printers.name as printname, glpi_printers.initial_pages as initial_pages
FROM glpi_cartridges
LEFT JOIN glpi_printers ON (glpi_cartridges.FK_glpi_printers = glpi_printers.ID)
WHERE (glpi_cartridges.FK_glpi_cartridges_type = '39') AND glpi_cartridges.date_out IS NULL
ORDER BY glpi_cartridges.date_out ASC, glpi_cartridges.date_use ASC, glpi_cartridges.date_in 0.000
18 SELECT COUNT(*)
FROM glpi_infocoms
WHERE FK_device='311' AND device_type='19' 0.000
19 SELECT COUNT(*)
FROM glpi_infocoms
WHERE FK_device='340' AND device_type='19' 0.000
20 SELECT count(*) AS COUNT
FROM glpi_cartridges
WHERE (FK_glpi_cartridges_type = '39') 0.000
21 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_use IS NULL) 0.000
22 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_use IS NOT NULL AND date_out IS NULL) 0.000
23 SELECT ID
FROM glpi_cartridges
WHERE ( FK_glpi_cartridges_type = '39' AND date_out IS NOT NULL) 0.000
24 SELECT glpi_cartridges.*, glpi_printers.ID as printID, glpi_printers.name as printname, glpi_printers.initial_pages as initial_pages
FROM glpi_cartridges
LEFT JOIN glpi_printers ON (glpi_cartridges.FK_glpi_printers = glpi_printers.ID)
WHERE (glpi_cartridges.FK_glpi_cartridges_type = '39') AND glpi_cartridges.date_out IS NOT NULL
ORDER BY glpi_cartridges.date_use ASC, glpi_cartridges.date_out DESC, glpi_cartridges.date_in 0.000
25 SELECT COUNT(*)
FROM glpi_infocoms
WHERE FK_device='310' AND device_type='19' 0.000
Offline
#7 2008-08-19 15:10:58
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
POST VARIABLE
KEY => VALUE
searchText => *
value => -1
table => glpi_dropdown_model_printers
myname => model
limit => 50
comments => 1
rand => 1199950544
entity_restrict => -1
update_item =>
used =>
Offline
#8 2008-08-19 15:13:16
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
Get Variable
Key => Value
Id => 39
Offline
#9 2008-08-19 15:14:26
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
SESSION VARIABLE
KEY => VALUE
glpi_currenttime => 2008-08-19 14:50:30
glpiID => 25
glpiname => rybakowski
glpirealname => Rybakowski
glpifirstname => Arnaud
glpilanguage => fr_FR
glpidefault_entity => 0
glpitracking_order => 1
glpiauthorisation => 1
glpiextauth => 1
glpiauth_method => 3
glpisearchcount => KEY => VALUE
11 => 1
3 => 1
glpisearchcount2 => KEY => VALUE
11 => 0
3 => 0
glpiroot => /glpi
glpilist_limit => 50
glpicrontimer => 1219150092
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
user_auth_method => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_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_group_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
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
entities => KEY => VALUE
7 => KEY => VALUE
ID => 0
name =>
completename =>
recursive => 1
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
user_auth_method => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_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_group_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
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
entities => KEY => VALUE
7 => KEY => VALUE
ID => 0
name =>
completename =>
recursive => 1
glpi_entities_tree => KEY => VALUE
0 => KEY => VALUE
0 => KEY => VALUE
name => Entité Racine
tree =>
glpiactiveentities => KEY => VALUE
0 => 0
glpi_entities_ancestors => KEY => VALUE
0 =>
glpiactive_entity => 0
glpiactive_entity_name => Entité Racine (arborescence)
glpiactive_entity_shortname => Entité Racine (arborescence)
glpishowallentities => 1
glpigroups =>
glpi_plugins =>
MESSAGE_AFTER_REDIRECT =>
glpi_multientitiesmode => 0
glpi_viewcentral => my
glpi_configgen => 1
glpisearch => KEY => VALUE
11 => KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
type2 =>
sort => 1
3 => KEY => VALUE
start => 0
order => ASC
deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
type2 =>
sort => 1
glpimassiveactionselected =>
glpi_onglet => 1
Offline
#10 2008-08-19 15:50:17
- MoYo
- GLPI - Lead
- From: Poitiers
- Registered: 2004-09-13
- Posts: 14,513
- Website
Re: Réintégration dans le stock d'une cartouche
des traces dans les fichiers de logs ? c'est le plus intéressant.
MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI : Support Contribute References Freshmeat
Offline
#11 2008-08-19 16:12:33
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
Item (ID) Date Service Niveau Message
cartouches: 39 2008-08-19 14:50:30 Inventaire 5 rybakowski restore cartridge.
système: 2008-08-19 14:48:12 Connexion 3 rybakowski connexion de l'IP :
cartouches: 32 2008-08-19 14:37:50 Inventaire 4 rybakowski added 4 cartridge.
système: 2008-08-19 14:37:05 Connexion 3 rybakowski connexion de l'IP :
cartouches: 39 2008-08-19 10:31:11 Inventaire 5 rybakowski restore cartridge.
système: 2008-08-19 10:30:29 Connexion 3 rybakowski connexion de l'IP :
cartouches: 39 2008-08-19 10:08:33 Inventaire 5 CORDIER restore cartridge.
cartouches: 39 2008-08-19 10:08:28 Inventaire 5 CORDIER restore cartridge.
cartouches: 39 2008-08-19 10:07:36 Inventaire 5 CORDIER restore cartridge.
cartouches: 39 2008-08-19 10:07:33 Inventaire 5 CORDIER restore cartridge.
cartouches: 39 2008-08-19 10:07:07 Inventaire 5 CORDIER restore cartridge.
imprimante: 49 2008-08-19 10:06:43 Inventaire 4 CORDIER mise à jour de l'item
système: 2008-08-19 10:05:30 Connexion 3 cordier connexion de l'IP :
cartouches: 37 2008-08-19 09:43:40 Inventaire 5 CORDIER installed cartridge.
cartouches: 2008-08-19 09:43:38 Inventaire 5 CORDIER uninstalled cartridge.
système: 2008-08-19 09:41:53 Connexion 3 cordier connexion de l'IP :
Offline
#12 2008-08-19 16:18:41
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
Ah, j'ai ce fichier dans files\_log\sql_errors.log :
2008-08-19 16:17:51
*** MySQL query error :
***
SQL: UPDATE glpi_cartridges SET date_out = NULL, date_use = NULL , FK_glpi_printers= NULL WHERE ID=\'340\'
Error: Column was set to data type implicit default; NULL supplied for NOT NULL column 'FK_glpi_printers' at row 1
Backtrace :
C:\glpi2\inc\cartridge.class.php:331 DBmysql->query()
C:\glpi2\front\cartridge.edit.php:78 Cartridge->restore()
C:\glpi2\front\cartridge.edit.php
2008-08-19 16:18:47
*** MySQL query error :
***
SQL: UPDATE glpi_cartridges SET date_out = NULL, date_use = NULL , FK_glpi_printers= NULL WHERE ID=\'340\'
Error: Column was set to data type implicit default; NULL supplied for NOT NULL column 'FK_glpi_printers' at row 1
Backtrace :
C:\glpi2\inc\cartridge.class.php:331 DBmysql->query()
C:\glpi2\front\cartridge.edit.php:78 Cartridge->restore()
C:\glpi2\front\cartridge.edit.php
Offline
#13 2008-08-19 16:27:33
- MoYo
- GLPI - Lead
- From: Poitiers
- Registered: 2004-09-13
- Posts: 14,513
- Website
Re: Réintégration dans le stock d'une cartouche
la cartouche est bien liée à une imprimante ?
vous pouvez tester de modifier ca :
https://dev.indepnet.net/glpi/changeset/7229
MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI : Support Contribute References Freshmeat
Offline
#14 2008-08-19 17:04:51
- ryb
- Member
- Registered: 2008-08-19
- Posts: 11
Re: Réintégration dans le stock d'une cartouche
ça fonctionne ....!
Merci beaucoup
PS : j'ai changé le code comme indiqué
Offline
#15 2008-08-19 17:15:58
- MoYo
- GLPI - Lead
- From: Poitiers
- Registered: 2004-09-13
- Posts: 14,513
- Website
Re: Réintégration dans le stock d'une cartouche
ok je ferme donc.
MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI : Support Contribute References Freshmeat
Offline
Pages: 1
Topic closed