Problem to assign tickets to a supplier.

taciano · 2016-04-15 18:33:07

I am using the 0.90.1 version of GLPI.
I have problem when trying to assign the ticket to a supplier. The same is not inserted to the ticket. Checking the SQL error logs, I found this:
" *** MySQL query error:
SQL:INSERT
INTO `glpi_suppliers_tickets` (`suppliers_id`,`use_notification`,`alternative_email`,`type`,`tickets_id`) VALUES (\'1\',\'Array\',\'Array\',\'2\',\'15199\')
Error: Incorrect integer value: 'Array' for column 'use_notification' at row 1
Backtrace :
inc/commondbtm.class.php:425
inc/commondbtm.class.php:831 CommonDBTM->addToDB()
inc/commonitilobject.class.php:794 CommonDBTM->add()
inc/ticket.class.php:1060 CommonITILObject->prepareInputForUpdate()
inc/commondbtm.class.php:1035 Ticket->prepareInputForUpdate()
front/ticket.form.php:69 CommonDBTM->update()"

The problem seems to me that instead of entering 0 or 1 in the "use_notification" or email in the "alternative_email", there is the attempt to insert the string "Array" in both fields.

Manually managed to assign the supplier on the ticket, alteranco SQL and running it via CLI.
Anyone else with this problem? Is there a solution for this?

Last edited by taciano (2016-04-15 18:46:33)

yllen · 2016-04-15 19:51:25

I reproduce.
Ticket opened: https://github.com/glpi-project/glpi/issues/601

yllen · 2016-04-15 19:56:53

Corrected: https://github.com/glpi-project/glpi/co … 2636dbbd16

taciano · 2016-04-15 20:14:52

Thanks for the answer!

The fix worked perfectly!!

Last edited by taciano (2016-04-15 20:20:30)

Forum GLPI-Project

Announcement

#1 2016-04-15 18:33:07

Problem to assign tickets to a supplier.

#2 2016-04-15 19:51:25

Re: Problem to assign tickets to a supplier.

#3 2016-04-15 19:56:53

Re: Problem to assign tickets to a supplier.

#4 2016-04-15 20:14:52

Re: Problem to assign tickets to a supplier.

Board footer