Forum GLPI-Project

rrintoul

Member

Registered: 2024-02-21

Posts: 7

Cannot create new tickets

We are unable to create new tickets using either + Add, or Create Ticket

We can create tickets by cloning existing ones, or by using form creator

but when we try to create one using the standard interface and default template you can enter all the info into the ticket but when you click Add the screen flashes but does nothing, no errors

rrintoul

Member

Registered: 2024-02-21

Posts: 7

Re: Cannot create new tickets

find error in SQL log

[2024-02-22 09:27:28] glpisqllog.ERROR: DBmysql::doQuery() in /var/www/glpi/src/DBmysql.php line 403
  *** MySQL query error:
  SQL: INSERT INTO `glpi_tickets` (`name`, `content`, `type`, `itilcategories_id`, `status`, `requesttypes_id`, `urgency`, `impact`, `locations_id`, `priority`, `users_id_lastupdater`, `users_id_recipient`, `entities_id`, `date`, `global_validation`, `olas_id_tto`, `olas_id_ttr`, `olalevels_id_ttr`, `ola_ttr_begin_date`, `ola_waiting_duration`, `internal_time_to_resolve`, `ola_tto_begin_date`, `internal_time_to_own`, `date_creation`, `date_mod`) VALUES ('1', '', '1', '0', '1', '1', '3', '2', '7', '2', '1201', '1201', '0', '2024-02-22 09:27:28', '1', '1', '2', '0', '2024-02-22 09:27:28', '', '2024-04-15 16:00:00', '2024-02-22 09:27:28', '2024-03-01 16:00:00', '2024-02-22 09:27:28', '2024-02-22 09:27:28')
  Error: Incorrect integer value: '' for column `glpi`.`glpi_tickets`.`ola_waiting_duration` at row 1
  Backtrace :
  src/DBmysql.php:1381                               DBmysql->doQuery()
  src/CommonDBTM.php:729                             DBmysql->insert()
  src/CommonDBTM.php:1342                            CommonDBTM->addToDB()
  front/ticket.form.php:80                           CommonDBTM->add()
  public/index.php:82                                require()

rrintoul

Member

Registered: 2024-02-21

Posts: 7

Re: Cannot create new tickets

Turns out OLA rule was breaking it, delete rule and it worked

rrintoul

Member

Registered: 2024-02-21

Posts: 7

Re: Cannot create new tickets

business rule for tickets works when Use rule for is update, but if it is add or add/update it stops new tickets being made

Last edited by rrintoul (2024-02-22 21:42:23)

rrintoul

Member

Registered: 2024-02-21

Posts: 7

Re: Cannot create new tickets

Found fix here:
github.com/glpi-project/glpi/pull/16496/files