Forum GLPI-Project

gururea

Member

Registered: 2010-05-21

Posts: 6

Profiles Config - PHP ERROR: Undefined index

Hi.
I need your help about this error

PHP ERROR: Undefined index: contract in /home/www/soporte/inc/profile.class.php at line 503

This error repeats in
bookmark_public
infocom
show_group_planning
and others.

The ouput DEBUG.

GLPI MODE DEBUG
SQL REQUEST : 3 Queries took 0s
N°    Queries    Time    Errors
1    SELECT *
FROM `glpi_profiles`
WHERE ID = '4'    0.000    
2    SELECT *
FROM `glpi_plugins`
WHERE (directory = 'applicatifs')    0.000    
3    SELECT *
FROM `glpi_profiles`
WHERE ID = '4'    0.000    
POST VARIABLE
GET VARIABLE
KEY    =>    VALUE
ID    =>    4
SESSION VARIABLE
KEY    =>    VALUE
glpi_currenttime    =>    2010-05-20 18:30:11
glpi_use_mode    =>    2
glpiID    =>    458
glpiname    =>    jnarvaez
glpirealname    =>    bog.GST.II-Servidores [ Jonathan Narvaez]
glpifirstname    =>   
glpidefault_entity    =>    0
glpiauthorisation    =>    1
glpiextauth    =>    1
glpiauth_method    =>    3
glpisearchcount    =>   
KEY    =>    VALUE
34    =>    1
glpisearchcount2    =>   
KEY    =>    VALUE
34    =>    0
glpiroot    =>   
glpicrontimer    =>    1274398053
glpi_tab    =>    1
glpilanguage    =>    en_GB
glpilist_limit    =>    20
glpidateformat    =>    0
glpinumberformat    =>    0
glpiview_ID    =>    1
glpidropdown_limit    =>    100
glpiflat_dropdowntree    =>    1
glpinum_of_events    =>    10
glpinextprev_item    =>    name
glpijobs_at_login    =>    1
glpipriority_1    =>    #fff2f2
glpipriority_2    =>    #ffe0e0
glpipriority_3    =>    #ffcece
glpipriority_4    =>    #ffbfbf
glpipriority_5    =>    #ff0000
glpiexpand_soft_categorized    =>    1
glpiexpand_soft_not_categorized    =>    1
glpitracking_order    =>    0
glpifollowup_private    =>    0
glpiprofiles    =>   
KEY    =>    VALUE
1    =>   
KEY    =>    VALUE
name    =>    post-only
entities    =>   
KEY    =>    VALUE
13846    =>   
KEY    =>    VALUE
ID    =>    0
name    =>   
recursive    =>    0
4    =>   
KEY    =>    VALUE
name    =>    super-admin
entities    =>   
KEY    =>    VALUE
9954    =>   
KEY    =>    VALUE
ID    =>    0
name    =>   
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    =>    r
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    =>    1
entities    =>   
KEY    =>    VALUE
9954    =>   
KEY    =>    VALUE
ID    =>    0
name    =>   
recursive    =>    0
glpiactiveentities    =>   
KEY    =>    VALUE
0    =>    0
glpiactiveentities_string    =>    '0'
glpiparententities    =>   
glpiparententities_string    =>   
glpiactive_entity    =>    0
glpiactive_entity_name    =>    Root entity
glpiactive_entity_shortname    =>    Root entity
glpishowallentities    =>    0
glpigroups    =>   
KEY    =>    VALUE
0    =>    148
glpi_plugin_pdf_profile    =>   
KEY    =>    VALUE
ID    =>    4
profile    =>   
use    =>    1
glpi_plugin_projet_profile    =>   
KEY    =>    VALUE
ID    =>    4
name    =>    super-admin
projet    =>    w
task    =>    w
open_ticket    =>   
glpi_plugin_alerting_profile    =>   
KEY    =>    VALUE
ID    =>    4
name    =>    super-admin
alerting    =>    r
glpi_plugins    =>   
KEY    =>    VALUE
3    =>    pdf
4    =>    projet
6    =>    alerting
MESSAGE_AFTER_REDIRECT    =>   
glpi_multientitiesmode    =>    1
glpisearch    =>   
KEY    =>    VALUE
34    =>   
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
glpilisttitle    =>   
KEY    =>    VALUE
34    =>    List
glpilistitems    =>   
KEY    =>    VALUE
34    =>   
KEY    =>    VALUE
0    =>    9
1    =>    7
2    =>    3
3    =>    10
4    =>    2
5    =>    1
6    =>    8
7    =>    4
8    =>    6
glpilisturl    =>   
KEY    =>    VALUE
34    =>    /front/profile.php
glpimassiveactionselected    =>   

Thanks...

wawa

GLPI-DEV

From: Montpellier / France

Registered: 2006-07-03

Posts: 6,019

Website

Re: Profiles Config - PHP ERROR: Undefined index

version of glpi ?

gururea

Member

Registered: 2010-05-21

Posts: 6

Re: Profiles Config - PHP ERROR: Undefined index

the version is GLPI 0.72.4 ....

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Profiles Config - PHP ERROR: Undefined index

contract_infocom    =>    w

Sauf erreur de ma part, en 0.72.4 il y a 2 lignes indépendantes (contract et infocom)

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Profiles Config - PHP ERROR: Undefined index

gururea :
In your profile's form - part Management - you must have 4 dropdowns (Contacts/Suppliers - Documents - Contracts - Financial information).
Have you this 4 dropdowns ?

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

gururea

Member

Registered: 2010-05-21

Posts: 6

Re: Profiles Config - PHP ERROR: Undefined index

Yes i have 4 drop downs
(Contacts / Suppliers:        Documents:        Contracts:    Financial Information:)

wawa

GLPI-DEV

From: Montpellier / France

Registered: 2006-07-03

Posts: 6,019

Website

Re: Profiles Config - PHP ERROR: Undefined index

how did you installed version 0.72.4 ?
you did an upgrade from a previous installation ? if yes which version ?
please activate the logfiles, and copy/paste us the error found in it which seems related to this issue

in your db, can you please check to you have this 2 fields in glpi_profile : contract & infocom

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Profiles Config - PHP ERROR: Undefined index

In database, glpi_profiles, have you 2 fields contract and infocom or only 1 field contract_infocom ?

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

gururea

Member

Registered: 2010-05-21

Posts: 6

Re: Profiles Config - PHP ERROR: Undefined index

how did you installed version 0.72.4 ?
you did an upgrade from a previous installation ? if yes which version ?
please activate the logfiles, and copy/paste us the error found in it which seems related to this issue

in your db, can you please check to you have this 2 fields in glpi_profile : contract & infocom

The actual version is upgrade from a previous installation (version 0.72.3),

the log files
php-errors.log

2010-05-21 10:55
Notice(8): Undefined index:  bookmark_public
Backtrace :
/home/www/soporte/inc/profile.class.php:488             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

2010-05-21 10:55
Notice(8): Undefined index:  contract
Backtrace :
/home/www/soporte/inc/profile.class.php:503             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

2010-05-21 10:55
Notice(8): Undefined index:  infocom
Backtrace :
/home/www/soporte/inc/profile.class.php:508             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

2010-05-21 10:55
Notice(8): Undefined index:  show_group_planning
Backtrace :
/home/www/soporte/inc/profile.class.php:620             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

2010-05-21 10:55
Notice(8): Undefined index:  user_auth_method
Backtrace :
/home/www/soporte/inc/profile.class.php:676             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

2010-05-21 10:55
Notice(8): Undefined index:  rule_dictionnary_dropdown
Backtrace :
/home/www/soporte/inc/profile.class.php:721             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

2010-05-21 10:55
Notice(8): Undefined index:  rule_dictionnary_software
Backtrace :
/home/www/soporte/inc/profile.class.php:725             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

2010-05-21 11:02
Notice(8): Undefined index:  bookmark_public
Backtrace :
/home/www/soporte/inc/profile.class.php:488             userErrorHandler()
/home/www/soporte/inc/profile.class.php:288             Profile->showCentralForm()
/home/www/soporte/ajax/profile.tabs.php:60              Profile->showForm()

---------------------------------------------------

File sql-error.log :

2010-05-21 11:07
*** MySQL query error :
***
SQL: SELECT admin_email AS EMAIL
                        FROM glpi_entities_data
                        WHERE FK_entities = \'0\'
Error: Unknown column 'admin_email' in 'field list'
Backtrace :
/home/www/soporte/inc/mailing.class.php:474             DBmysql->query()
/home/www/soporte/inc/mailing.class.php:615             Mailing->get_mail_sender()
/home/www/soporte/inc/tracking.class.php:559            Mailing->send()
/home/www/soporte/inc/commondbtm.class.php:604          Job->post_updateItem()
/home/www/soporte/front/tracking.form.php:55            CommonDBTM->update()
/home/www/soporte/front/tracking.form.php

2010-05-21 11:07
*** MySQL query error :
***
SQL: SELECT admin_email AS EMAIL, admin_reply AS REPLY
                        FROM glpi_entities_data
                        WHERE FK_entities = \'0\'
Error: Unknown column 'admin_email' in 'field list'
Backtrace :
/home/www/soporte/inc/mailing.class.php:545             DBmysql->query()
/home/www/soporte/inc/mailing.class.php:617             Mailing->get_reply_to_address()
/home/www/soporte/inc/tracking.class.php:559            Mailing->send()
/home/www/soporte/inc/commondbtm.class.php:604          Job->post_updateItem()
/home/www/soporte/front/tracking.form.php:55            CommonDBTM->update()
/home/www/soporte/front/tracking.form.php

2010-05-21 11:07
*** MySQL query error :
***
SQL: SELECT admin_email AS EMAIL
                        FROM glpi_entities_data
                        WHERE FK_entities = \'0\'
Error: Unknown column 'admin_email' in 'field list'
Backtrace :
/home/www/soporte/inc/mailing.class.php:474             DBmysql->query()
/home/www/soporte/inc/mailing.class.php:615             Mailing->get_mail_sender()
/home/www/soporte/inc/tracking.class.php:559            Mailing->send()
/home/www/soporte/inc/commondbtm.class.php:604          Job->post_updateItem()
/home/www/soporte/front/tracking.form.php:55            CommonDBTM->update()
/home/www/soporte/front/tracking.form.php

2010-05-21 11:07
*** MySQL query error :
***
SQL: SELECT admin_email AS EMAIL, admin_reply AS REPLY
                        FROM glpi_entities_data
                        WHERE FK_entities = \'0\'
Error: Unknown column 'admin_email' in 'field list'
Backtrace :
/home/www/soporte/inc/mailing.class.php:545             DBmysql->query()
/home/www/soporte/inc/mailing.class.php:617             Mailing->get_reply_to_address()
/home/www/soporte/inc/tracking.class.php:559            Mailing->send()
/home/www/soporte/inc/commondbtm.class.php:604          Job->post_updateItem()
/home/www/soporte/front/tracking.form.php:55            CommonDBTM->update()
/home/www/soporte/front/tracking.form.php

in my DB exist only 1 filed contract_infocom..

Thanks.

gururea

Member

Registered: 2010-05-21

Posts: 6

Re: Profiles Config - PHP ERROR: Undefined index

Hi

GLPI version that changes are made to these tables?

for revise this version.

thanks..