[2024-03-29 08:48:33] glpisqllog.ERROR: DBmysql::query() in /var/www/html/itsm-ng/inc/dbmysql.class.php line 335
*** MySQL query error:
SQL: INSERT INTO `glpi_logs` (`items_id`, `itemtype`, `itemtype_link`, `linked_action`, `user_name`, `date_mod`, `id_search_option`, `old_value`, `new_value`) VALUES ('1', 'Config', '', '0', 'glpi (2)', '2024-03-29 08:48:33', '1', 'priority_matrix {\"1\":{\"1\":\"1\",\"2\":\"1\",\"3\":\"2\",\"4\":\"2\",\"5\":\"2\"},\"2\":{\"1\":\"1\",\"2\":\"2\",\"3\":\"2\",\"4\":\"3\",\"5\":\"3\"},\"3\":{\"1\":\"2\",\"2\":\"2\",\"3\":\"3\",\"4\":\"4\",\"5\":\"4\"},\"4\":{\"1\":\"2\",\"2\":\"3\', '{\"1\":{\"1\":\"1\",\"2\":\"1\",\"3\":\"2\",\"4\":\"2\",\"5\":\"2\"},\"2\":{\"1\":\"1\",\"2\":\"2\",\"3\":\"2\",\"4\":\"3\",\"5\":\"3\"},\"3\":{\"1\":\"2\",\"2\":\"2\",\"3\":\"3\",\"4\":\"4\",\"5\":\"4\"},\"4\":{\"1\":\"2\",\"2\":\"3\",\"3\":\"4\",\"')
Error: 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 '{\"1\":{\"1\":\"1\",\"2\":\"1\",\"3\":\"2\",\"4\":\"2\",\"5\":\"2\"},\"2\":{\"1\' at line 1
Backtrace :
inc/dbmysql.class.php:1174
inc/log.class.php:246 DBmysql->insert()
inc/log.class.php:173 Log::history()
inc/config.class.php:3809 Log::constructHistory()
inc/config.class.php:3784 Config->logConfigChange()
inc/commondbtm.class.php:1685 Config->post_updateItem()
inc/config.class.php:3044 CommonDBTM->update()
inc/config.class.php:263 Config::setConfigurationValues()
inc/commondbtm.class.php:1568 Config->prepareInputForUpdate()
front/config.form.php:60 CommonDBTM->update()
$old_value = $DB->escape(Toolbox::substr(stripslashes($old_value), 0, 180));
$new_value = $DB->escape(Toolbox::substr(stripslashes($new_value), 0, 180));
// Security to be sure that values do not pass over the max length
if (Toolbox::strlen($old_value) > 255) {
$old_value = Toolbox::substr($old_value, 0, 250);
}
if (Toolbox::strlen($new_value) > 255) {
$new_value = Toolbox::substr($new_value, 0, 250);
}
$old_value = Toolbox::substr(stripslashes($old_value), 0, 180);
$new_value = Toolbox::substr(stripslashes($new_value), 0, 180);
// Security to be sure that values do not pass over the max length
if (Toolbox::strlen($old_value) > 255) {
$old_value = Toolbox::substr($old_value, 0, 250);
}
if (Toolbox::strlen($new_value) > 255) {
$new_value = Toolbox::substr($new_value, 0, 250);
}
$old_value = $DB->escape($old_value);
$new_value = $DB->escape($new_value);