PHPJunkyard support forum

I am running hesk 2.6.8 and mods 2.6.4

Write your message below:

I get this error when replying to a ticket in IE but it workes fine when I replied in chrome.

Error:

Can't execute SQL: SELECT `IsClosed`, `Key` FROM `hesk_statuses` WHERE `ID` = Submit reply and change status to Resolved

MySQL said:
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 'reply and change status to Resolved' at line 1

I just tried resolving a ticket by selecting "Submit reply and change status to Resolved" in IE 11 and it worked fine. What version of IE are you using?

Also, the latest version of Mods for HESK is 3.0.3 which supports HESK 2.7.2. It is recommended that you upgrade when possible as previous versions of Mods for HESK will not receive any bug fixes.

My 2 cents: SQL is run on the server, what browser you use has nothing to do with it.

Klemen wrote: Tue Mar 28, 2017 6:42 pm My 2 cents: SQL is run on the server, what browser you use has nothing to do with it.

The only possibility I could see is that the submit "buttons" (that look like links) that submit and change status are being treated differently by an older version of IE (for example, using the button text instead of the button's value attribute). However, I haven't had a chance to actually test that hypothesis. If the browser is sending the wrong value up to the server, then the SQL would be malformed.

I am able to reproduce this in IE 7 (via IE 11 emulation). IE 7 is not supported by Mods for HESK. IE 11 is the only "truly" supported browser, however IE 9 and 10 will most likely work. Are you using IE 7 or something different?

I don't know why I didn't test this out first but that was the issue. Local intranet sites or showing in compatibility mode IE 7 emulation. Thanks for all your help.