Query error row

senfisu's profile image senfisu posted 1 month ago in General Permalink

Hello everyone,

I am new to Heidi and I having an issue. Whenever there is an error in the SQL query a warning pop up appears. However apart from saying that the error is in the proximity of ... it does not show the exact location of the error (for example the row number xx).

Is there a fix to this somewhere in the settings or it is something that is still not available in Heidi ?


ansgar's profile image ansgar posted 1 month ago Permalink

These error messages are sent by the server, HeidiSQL just displays them to the user. There is no setting in HeidiSQL to make these more exact. You need to find the errorneous part using the clue in the message.

For example:

select 1234, COUNT();

... produces such an error:

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 1

So, you need to look for the ')' in line 1.

Please login to leave a reply, or register at first.