Page 1 of 1

need help on "Can't execute SQL: UPDATE `hesk_custom_fields`"

Posted: Thu May 16, 2019 3:36 am
by fared
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.

Re: need help on "Can't execute SQL: UPDATE `hesk_custom_fields`"

Posted: Thu May 16, 2019 6:17 am
by Klemen
Have you made any changes to the code or are you using original Hesk 2.8.2 files?

Try clearing cache by going to admin panel > Settings > click "Save changes", then try again.