Unable to read response from gateway

Ignition
1

When trying to execute my sql query to see if there is duplicate usernames

SELECT IF(EXISTS(SELECT username FROM auto_users WHERE username =  "sean1"), 1, 0)

I am getting the following error…

GatewayException: Unable to read response from Gateway.
caused by org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 76; Element type “column” must be followed by either attribute specifications, “>” or “/>”.

Ignition v8.0.16 (b2020082513)
Java: Azul Systems, Inc. 11.0.7

Does anyone know why this is happening, the SQL is working in MYSQL.

2

Is this being used in a script? If so, It may help tho see it.

3

Hi Jordan, I havent tried it as a script yet I am just testing it as a named query.

4

Is there any solution for this , why I m getting the error.

5

Exactly that error? Consider starting a new topic, and share all potentially relevant information.