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

Everything related to Hesk - helpdesk software

Moderator: mkoch227

Post Reply
fared
Posts: 1
Joined: Thu May 16, 2019 3:31 am

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

Post 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.
Klemen
Site Admin
Posts: 10136
Joined: Fri Feb 11, 2005 4:04 pm

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

Post 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.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply