Forum GLPI-Project

JosephLive93

Member

Registered: 2021-08-16

Posts: 5

GLPI Not Creating New Tickets

There were no true changes in our instance of GLPI, however our instance stopped creating tickets. As soon as the 'Add' button is clicked the same fields are there and there is no blip in the bottom right stating the ticket has been created. I can still restore deleted tickets and close current tickets.

This instance of GLPI is running 9.5.5 and I've tried to check for errors but do not really see anything... We were able to open up tickets over the holidays then it just stopped working all of a sudden.

If there is anything I can provide for assistance it would be greatly appreciated for any help!

Thanks!!

Last edited by JosephLive93 (2022-01-05 10:50:49)

JosephLive93

Member

Registered: 2021-08-16

Posts: 5

Re: GLPI Not Creating New Tickets

Found out that it's producing an error in the sql log files in /var/www/html/glpi/files/_log

The error is as follows:

[2022-01-05 09:00:11] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 309
  *** MySQL query error:
  SQL: INSERT INTO `glpi_tickets` (`date`, `type`, `itilcategories_id`, `entities_id`, `status`, `requesttypes_id`, `urgency`, `impact`, `locations_id`, `priority`, `actiontime`, `name`, `content`, `id`, `users_id_lastupdater`, `users_id_recipient`, `global_validation`, `date_creation`, `date_mod`) VALUES ('2022-01-05 09:00:11', '1', '5', '0', '2', '0', '3', '3', '0', '3', '0', 'test', '<p>test</p>', '0', '6', '6', '1', '2022-01-05 09:00:11', '2022-01-05 09:00:11')
  Error: Out of range value for column 'id' at row 1
  Backtrace :
  inc/dbmysql.class.php:1148
  inc/commondbtm.class.php:602                       DBmysql->insert()
  inc/commondbtm.class.php:1172                      CommonDBTM->addToDB()
  front/ticket.form.php:63                           CommonDBTM->add()

If anyone could help it would be greatly appreciated!..

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,370

Re: GLPI Not Creating New Tickets

see here :
https://github.com/glpi-project/glpi/issues/10262

and here
https://github.com/yllen/behaviors/issues/4

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

JosephLive93

Member

Registered: 2021-08-16

Posts: 5

Re: GLPI Not Creating New Tickets

Thanks for the response!

I'm not sure I fully understand if there is a fix. I was reading through it, but this is all new to me.

I'm not sure how or what to do with the script?

cconard96

Moderator

Registered: 2018-07-31

Posts: 3,265

Website

Re: GLPI Not Creating New Tickets

The official fix was only just marked for review this morning and hasn't been "merged" into the code base yet so it isn't technically complete yet.
See https://github.com/glpi-project/glpi/pull/10263

It will be a part of the 9.5.7 release as a command you can optionally run to update the DB columns.
From what I've seen, the update can take quite a long time depending on how much data your DB has.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.

JosephLive93

Member

Registered: 2021-08-16

Posts: 5

Re: GLPI Not Creating New Tickets

Thanks cconard96,

I've replaced all the files that were changed. Still running into the same issue.. Not sure how to apply the updates of the changed files?

I've done the following command for GLPI console and nothing has changed:

/var/www/html/glpi/bin# php console glpi:migration:unsigned_keys
Found 0 primary/foreign key columns(s) using signed integers.
No migration needed.

Thanks for the hard work!

Last edited by JosephLive93 (2022-01-06 04:52:01)