php-error.log PHP Notice(8): Undefined offset: 13

deathvarg · 2016-06-21 14:48:10

Hi all!

I`m using GLPI 0.90.3 and I have a problem.
I enable error log: Setup - general - system - Logs in files (SQL, email, automatic action...) = Yes.
After that I watch than php-error.log is growing to ~9GB very fast, in few minutes.

Last 20 lines from php-error.log:

tail -n 20 php-errors.log
  inc/search.class.php:98                            Search::constructDatas()
  inc/search.class.php:81                            Search::showList()
  front/ticket.php:56                                Search::show()
2016-06-21 15:32:57 [2444@sd.mydomain.com]
  *** PHP Notice(8): Undefined offset: 12
  Backtrace :
  inc/search.class.php:4871                          
  inc/search.class.php:1107                          Search::giveItem()
  inc/search.class.php:98                            Search::constructDatas()
  inc/search.class.php:81                            Search::showList()
  front/ticket.php:56                                Search::show()
2016-06-21 15:32:57 [2444@sd.mydomain.com]
  *** PHP Notice(8): Undefined offset: 13
  Backtrace :
  inc/search.class.php:4871                          
  inc/search.class.php:1107                          Search::giveItem()
  inc/search.class.php:98                            Search::constructDatas()
  inc/search.class.php:81                            Search::showList()
  front/ticket.php:56                                Search::show()
Test

I cannot understand why these errors apperar.

Please, give my a right way to dig

yllen · 2016-06-21 18:10:41

These errors are linked with language.
Have you defined a default language in "My settings" ?
In ticket list, do you display column that can be translated?

deathvarg · 2016-06-22 08:32:51

Hi, yllen!

Thank you for your response!

yllen wrote:

These errors are linked with language.
Have you defined a default language in "My settings" ?

Yes, I defied Default language as "Russian".
Should I define another default language?

yllen wrote:

In ticket list, do you display column that can be translated?

Yes, it is:
- Status;
- Ticket type;
- Time metrics columns;

Actualy, I watch this problem from June 18 and we are using GLPI from June 01.
So, it looks a little bit strange, because I didn`t make any changes with logs settings.

yllen · 2016-06-22 14:43:19

In debug mode (in your settings), you have a like right under tickets lists: See GLPI debug.
Click on and give the result of SQL request for ticket (SELECT 'ylllen' AS currentuser, ....)

deathvarg · 2016-06-22 15:03:52

SELECT 'r.savin' AS currentuser, `glpi_tickets`.`id` AS `ITEM_0`, `glpi_tickets`.`name` AS `ITEM_1`, `glpi_tickets`.`id` AS `ITEM_1_id`, `glpi_tickets`.`id` AS `ITEM_1_id`, `glpi_tickets`.`content` AS `ITEM_1_content`, `glpi_tickets`.`status` AS `ITEM_1_status`, `glpi_entities`.`completename` AS `ITEM_2`, `glpi_tickets`.`status` AS `ITEM_3`, `glpi_tickets`.`date_mod` AS `ITEM_4`, `glpi_itilcategories`.`completename` AS `ITEM_5`, `glpi_tickets`.`date` AS `ITEM_6`, `glpi_tickets`.`due_date` AS `ITEM_7`, `glpi_tickets`.`status` AS `ITEM_7_status`, `glpi_tickets`.`closedate` AS `ITEM_8`, `glpi_tickets`.`priority` AS `ITEM_9`, GROUP_CONCAT(DISTINCT `glpi_users_647c2805c3795643b0f52f520e7cdb86`.`id` SEPARATOR '$$##$$') AS `ITEM_10`, GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`users_id`, ' ', `glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`alternative_email`) SEPARATOR '$$##$$') AS `ITEM_10_2`, GROUP_CONCAT(DISTINCT `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`id` SEPARATOR '$$##$$') AS `ITEM_11`, GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`users_id`, ' ', `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`alternative_email`) SEPARATOR '$$##$$') AS `ITEM_11_2`, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_groups_80a94b3f6bc6957c5f1fd062f3013524`.`completename`, '__NULL__'), '$#$',`glpi_groups_80a94b3f6bc6957c5f1fd062f3013524`.`id`) SEPARATOR '$$##$$'), '__NULL__$#$') AS `ITEM_12`, `glpi_requesttypes`.`name` AS `ITEM_13`, `glpi_tickets`.`type` AS `ITEM_14`, `glpi_users_users_id_lastupdater`.`name` AS `ITEM_15`, `glpi_users_users_id_lastupdater`.`realname` AS `ITEM_15_realname`, `glpi_users_users_id_lastupdater`.`id` AS `ITEM_15_id`, `glpi_users_users_id_lastupdater`.`firstname` AS `ITEM_15_firstname`, COUNT(DISTINCT `glpi_ticketfollowups`.`id`) AS `ITEM_16`, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_tickets`.`takeintoaccount_delay_stat`, '__NULL__'), '$#$',`glpi_tickets`.`id`) SEPARATOR '$$##$$'), '__NULL__$#$') AS `ITEM_17`, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_tickets`.`solve_delay_stat`, '__NULL__'), '$#$',`glpi_tickets`.`id`) SEPARATOR '$$##$$'), '__NULL__$#$') AS `ITEM_18`, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_tickets`.`waiting_duration`, '__NULL__'), '$#$',`glpi_tickets`.`id`) SEPARATOR '$$##$$'), '__NULL__$#$') AS `ITEM_19`, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_ticketvalidations`.`status`, '__NULL__'), '$#$',`glpi_ticketvalidations`.`id`) SEPARATOR '$$##$$'), '__NULL__$#$') AS `ITEM_20`, `glpi_tickets`.`id` AS id
FROM `glpi_tickets`
LEFT JOIN `glpi_entities` ON (`glpi_tickets`.`entities_id` = `glpi_entities`.`id` )
LEFT JOIN `glpi_itilcategories` ON (`glpi_tickets`.`itilcategories_id` = `glpi_itilcategories`.`id` )
LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_a900a61824c3906cc82f90407e525192` ON (`glpi_tickets`.`id` = `glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`tickets_id` AND `glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`type` = 1 )
LEFT JOIN `glpi_users` AS `glpi_users_647c2805c3795643b0f52f520e7cdb86` ON (`glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`users_id` = `glpi_users_647c2805c3795643b0f52f520e7cdb86`.`id` )
LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83` ON (`glpi_tickets`.`id` = `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`tickets_id` AND `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`type` = 2 )
LEFT JOIN `glpi_users` AS `glpi_users_c5e682856a6d6fe48b5aed8f8b238708` ON (`glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`users_id` = `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`id` )
LEFT JOIN `glpi_groups_tickets` AS `glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83` ON (`glpi_tickets`.`id` = `glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83`.`tickets_id` AND `glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83`.`type` = 2 )
LEFT JOIN `glpi_groups` AS `glpi_groups_80a94b3f6bc6957c5f1fd062f3013524` ON (`glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83`.`groups_id` = `glpi_groups_80a94b3f6bc6957c5f1fd062f3013524`.`id` )
LEFT JOIN `glpi_requesttypes` ON (`glpi_tickets`.`requesttypes_id` = `glpi_requesttypes`.`id` )
LEFT JOIN `glpi_users` AS `glpi_users_users_id_lastupdater` ON (`glpi_tickets`.`users_id_lastupdater` = `glpi_users_users_id_lastupdater`.`id` )
LEFT JOIN `glpi_ticketfollowups` ON (`glpi_tickets`.`id` = `glpi_ticketfollowups`.`tickets_id` )
LEFT JOIN `glpi_ticketvalidations` ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id` )
WHERE `glpi_tickets`.`is_deleted` = '0' AND ( `glpi_tickets`.`status` IN ('1','2','3','4') ) GROUP BY `glpi_tickets`.`id`
ORDER BY ITEM_4 DESC

Forum GLPI-Project

Announcement

#1 2016-06-21 14:48:10

php-error.log PHP Notice(8): Undefined offset: 13

#2 2016-06-21 18:10:41

Re: php-error.log PHP Notice(8): Undefined offset: 13

#3 2016-06-22 08:32:51

Re: php-error.log PHP Notice(8): Undefined offset: 13

#4 2016-06-22 14:43:19

Re: php-error.log PHP Notice(8): Undefined offset: 13

#5 2016-06-22 15:03:52

Re: php-error.log PHP Notice(8): Undefined offset: 13

Board footer