My 5 last forms (requester) and My 5 last forms (validator) are not displayed. #3242
Description
Describe the bug
If we go to the forms to see my latest forms from the self-service account, instead of "My 5 last forms (requester)" and "My 5 last forms (validator)" we see the message "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '46,17)) AND ( glpi_plugin_formcreator_formanswers.entities_id IN ('6') ...' at line 11" and "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '46,17)) AND ( glpi_plugin_formcreator_formanswers.entities_id IN ('6') ...' at line 15" respectively.
Moreover, this window is normally shown when logging in from the super-admin, by changing the rights, I realized that the error is affected by the parameter for changing general settings, self-service does not have it, and if you issue that window, it is displayed, but as you understand this is not an option
Expected behavior
I expect everything should work like in the screenshot
Screenshots
at the moment what self-service sees
GLPI / Plugins (please complete the following information):
formcreator Name: Form Creator Version: 2.13.5 State: Enabled
Install Method: Marketplace
- GLPI 10.0.6
Additional context
Debug: SQL REQUEST
SELECT DISTINCT `glpi_plugin_formcreator_formanswers`.`id` AS id, 'm.goloshchanov' AS currentuser, `glpi_plugin_formcreator_formanswers`.`entities_id`, `glpi_plugin_formcreator_formanswers`.`is_recursive`, `glpi_plugin_formcreator_formanswers`.`name` AS `ITEM_PluginFormcreatorFormAnswer_1`, `glpi_plugin_formcreator_formanswers`.`id` AS `ITEM_PluginFormcreatorFormAnswer_1_id`, `glpi_plugin_formcreator_formanswers`.`id` AS `ITEM_PluginFormcreatorFormAnswer_2`, `glpi_plugin_formcreator_formanswers`.`id` AS `ITEM_PluginFormcreatorFormAnswer_2_id`, `glpi_plugin_formcreator_formanswers`.`request_date` AS `ITEM_PluginFormcreatorFormAnswer_6`, `glpi_plugin_formcreator_formanswers`.`status` AS `ITEM_PluginFormcreatorFormAnswer_8`, `glpi_users_requester_id`.`name` AS `ITEM_PluginFormcreatorFormAnswer_4`, `glpi_users_requester_id`.`realname` AS `ITEM_PluginFormcreatorFormAnswer_4_realname`, `glpi_users_requester_id`.`id` AS `ITEM_PluginFormcreatorFormAnswer_4_id`, `glpi_users_requester_id`.`firstname` AS `ITEM_PluginFormcreatorFormAnswer_4_firstname`
FROM `glpi_plugin_formcreator_formanswers`
LEFT JOIN `glpi_users` AS `glpi_users_requester_id` ON (`glpi_plugin_formcreator_formanswers`.`requester_id` = `glpi_users_requester_id`.`id` )
WHERE `glpi_plugin_formcreator_formanswers`.`requester_id` = 11 OR (`glpi_plugin_formcreator_formanswers`.`users_id_validator` = 11 OR `glpi_plugin_formcreator_formanswers`.`groups_id_validator` IN (,46,17)) AND ( `glpi_plugin_formcreator_formanswers`.`entities_id` IN ('6') OR (`glpi_plugin_formcreator_formanswers`.`is_recursive`='1' AND `glpi_plugin_formcreator_formanswers`.`entities_id` IN (0)) ) AND ( (`glpi_users_requester_id`.`id` = '11') )
ORDER BY `ITEM_PluginFormcreatorFormAnswer_6` DESC
Have errors "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '46,17)) AND ( glpi_plugin_formcreator_formanswers.entities_id IN ('6') ...' at line 11"
screen
Debug: SQL REQUEST
SELECT DISTINCT `glpi_plugin_formcreator_formanswers`.`id` AS id, 'm.goloshchanov' AS currentuser, `glpi_plugin_formcreator_formanswers`.`entities_id`, `glpi_plugin_formcreator_formanswers`.`is_recursive`, `glpi_plugin_formcreator_formanswers`.`name` AS `ITEM_PluginFormcreatorFormAnswer_1`, `glpi_plugin_formcreator_formanswers`.`id` AS `ITEM_PluginFormcreatorFormAnswer_1_id`, `glpi_plugin_formcreator_formanswers`.`id` AS `ITEM_PluginFormcreatorFormAnswer_2`, `glpi_plugin_formcreator_formanswers`.`id` AS `ITEM_PluginFormcreatorFormAnswer_2_id`, `glpi_plugin_formcreator_formanswers`.`request_date` AS `ITEM_PluginFormcreatorFormAnswer_6`, `glpi_plugin_formcreator_formanswers`.`status` AS `ITEM_PluginFormcreatorFormAnswer_8`, GROUP_CONCAT(DISTINCT `glpi_users_users_id_validator`.`id` SEPARATOR '$$##$$') AS `ITEM_PluginFormcreatorFormAnswer_5`, GROUP_CONCAT(DISTINCT CONCAT(`glpi_groups_groups_id_validator`.`completename`, '$#$' , `glpi_groups_groups_id_validator`.`id`)
ORDER BY `glpi_groups_groups_id_validator`.`id` SEPARATOR '$$##$$') AS `ITEM_PluginFormcreatorFormAnswer_7`
FROM `glpi_plugin_formcreator_formanswers`
LEFT JOIN `glpi_users` AS `glpi_users_users_id_validator` ON (`glpi_plugin_formcreator_formanswers`.`users_id_validator` = `glpi_users_users_id_validator`.`id` )
LEFT JOIN `glpi_groups` AS `glpi_groups_groups_id_validator` ON (`glpi_plugin_formcreator_formanswers`.`groups_id_validator` = `glpi_groups_groups_id_validator`.`id` )
WHERE `glpi_plugin_formcreator_formanswers`.`requester_id` = 11 OR (`glpi_plugin_formcreator_formanswers`.`users_id_validator` = 11 OR `glpi_plugin_formcreator_formanswers`.`groups_id_validator` IN (,46,17)) AND ( `glpi_plugin_formcreator_formanswers`.`entities_id` IN ('6') OR (`glpi_plugin_formcreator_formanswers`.`is_recursive`='1' AND `glpi_plugin_formcreator_formanswers`.`entities_id` IN (0)) ) AND ( (`glpi_users_users_id_validator`.`id` = '11') OR (`glpi_groups_groups_id_validator`.`id` IN ('17','46')) ) GROUP BY `glpi_plugin_formcreator_formanswers`.`id`
ORDER BY `ITEM_PluginFormcreatorFormAnswer_6` DESC
Have errors "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '46,17)) AND ( glpi_plugin_formcreator_formanswers.entities_id IN ('6') ...' at line 15"
screen