Forum GLPI-Project

ev

Member

Registered: 2014-10-27

Posts: 4

Can't remove old tickets

When I try to move old tickets to recycle bin or delete have error "Security die. trying to load an forbidden class name".
No errorrs in error.log or php-error.log
GLPI 0.85.2

Last edited by ev (2015-03-03 08:20:23)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Can't remove old tickets

Do you use plugins?
Put you GLPI in debug mode you will have more information.

---

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)

ev

Member

Registered: 2014-10-27

Posts: 4

Re: Can't remove old tickets

Now in sql-errors.log:
*** MySQL query error:
  SQL: SELECT `glpi_documents_items`.`id` AS assocID,
                       `glpi_entities`.`id` AS entity,
                       `glpi_documents`.`name` AS assocName,
                       `glpi_documents`.*
                FROM `glpi_documents_items`
                LEFT JOIN `glpi_documents`
                  ON (`glpi_documents_items`.`documents_id`=`glpi_documents`.`id`)
                LEFT JOIN `glpi_entities`
                  ON (`glpi_documents`.`entities_id`=`glpi_entities`.`id`)
                WHERE `glpi_documents_items`.`items_id` = \'71826\'
                      AND `glpi_documents_items`.`itemtype` = \'Ticket\'  AND ( `glpi_documents`.`entities_id` IN ()  )
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')  )' at line 11
  Backtrace :
  inc/ticket.class.php:6089
  inc/notificationtemplate.class.php:287             Ticket->convertContentForNotification()
  inc/notificationevent.class.php:166                NotificationTemplate->getTemplateByLanguage()
  inc/ticket.class.php:1558                          NotificationEvent::raiseEvent()
  inc/commondbtm.class.php:823                       Ticket->post_addItem()
  inc/mailcollector.class.php:559                    CommonDBTM->add()
  inc/mailcollector.class.php:1525                   MailCollector->collect()
  :                                                  MailCollector::cronMailgate()
  inc/crontask.class.php:781                         call_user_func()
  front/cron.php:84                                  CronTask::launch()

I have OCS Inventory NG plugin installed.

Last edited by ev (2015-03-05 09:21:03)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Can't remove old tickets

Try with Plugin OCS Inventory desactivate

---

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)