Forum GLPI-Project

stazzy

Member

Registered: 2023-10-05

Posts: 2

Problem with Behaviour plugin and preselection of the group

Hi all, we recently migrated our GLPI to a new server (restarted pretty much from scratch).
Now we have a weird little problem with the Behaviour plugin, probably linked to sql.

We would like to use the automatical preselection of the requester's / technician's group. However, that doesn't work, le group is not chosen.

Debug mode is nice and gives me errors when I'm creating a ticket :

PHP Warning (2): Undefined array key "entities_id" in /var/www/glpi/plugins/behaviors/inc/ticket.class.php at line 703

SQL Error "1064": 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 ') AND (`is_requester`)' at line 1 in query "SELECT `glpi_groups`.`id` FROM `glpi_groups_users` INNER JOIN `glpi_groups` ON (`glpi_groups`.`id` = `glpi_groups_users`.`groups_id`) WHERE `users_id` = '18' AND () AND (`is_requester`)"

PHP Warning (2): Undefined array key "entities_id" in /var/www/glpi/plugins/behaviors/inc/ticket.class.php at line 761

SQL Error "1064": 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 ') AND (`is_assign`)' at line 1 in query "SELECT `glpi_groups`.`id` FROM `glpi_groups_users` INNER JOIN `glpi_groups` ON (`glpi_groups`.`id` = `glpi_groups_users`.`groups_id`) WHERE `users_id` = '11' AND () AND (`is_assign`)"

I just don't what to do. How to force Behaviours to send a sql request that wouldn't have errors?
Les propositions des solutions en français seront acceptées aussi

Using GLPI 10.0.10 and MySql 8.0.34.

loyolajavi

Member

Registered: 2017-11-10

Posts: 8

Re: Problem with Behaviour plugin and preselection of the group

Hello, is not the optimal solution, but you can do that with service rules.
Criteria: technician exist.
Action: add default group of technician

The technician user must have the default group configured