need help on "Can't execute SQL: UPDATE `hesk_custom_fields`"
Posted: Thu May 16, 2019 3:36 am
need help , i cannot update on custom fields ..
Error:
Can't execute SQL: UPDATE `hesk_custom_fields` SET `use` = '1', `place` = '1', `type` = 'select', `req` = '2', `category` = NULL, `name` = '{\"English\":\"Problem Selector\"}', `mfh_description` = '{\"English\":\"Select this option if you dont know what is the issue .\"}', `value` = '{\"show_select\":1,\"select_options\":[\"Cannot turn on computer\",\"Computer suddenly shutdown\",\"Display flickering \",\"Don\'t have connection to the database\",\"Don\'t have connection to the database \",\"Mouse not working\",\"No Display\",\"No internet connection\"]}' WHERE `id`=
MySQL said:
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 '' at line 10
WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.
Error:
Can't execute SQL: UPDATE `hesk_custom_fields` SET `use` = '1', `place` = '1', `type` = 'select', `req` = '2', `category` = NULL, `name` = '{\"English\":\"Problem Selector\"}', `mfh_description` = '{\"English\":\"Select this option if you dont know what is the issue .\"}', `value` = '{\"show_select\":1,\"select_options\":[\"Cannot turn on computer\",\"Computer suddenly shutdown\",\"Display flickering \",\"Don\'t have connection to the database\",\"Don\'t have connection to the database \",\"Mouse not working\",\"No Display\",\"No internet connection\"]}' WHERE `id`=
MySQL said:
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 '' at line 10
WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.