SQL Error (1054): Unknown column 'ban-
comment' in 'where clause
So the error occurs when Heidi creates a new line in the SQL query text box. It splits column name 'ban-comment' to 'ban- at the end of the line and to comment' at the beginning of the new line.
Error with SQL Query when Heidi starts a new line after symbol - in column name
it's a Heidi's mistake, actually its:
...OR `ban-date` LIKE '%text%' OR `ban-count` LIKE '%text%' OR `ban-comment` LIKE ...
but Heidi shows error with ' symbols instead of `
So the problem appears when:
1. Click on Filter
2. Enter any text in "Create multi column filter" text box
3. Press Apply Filter
Heidi creates SQL query automatically and split it to a few lines but in case of Heidi's window size it past new after - symbol in column name like that: `ban-
comment`
... and error appears.
Here is a screenshot: http://clip2net.com/s/1tQKo
I guess it is necessary to prvent these errors by making one of two thing:
1. Do not split column names
2. Do not past new line in SQL query if column name was splitted and moved to a new line.
...OR `ban-date` LIKE '%text%' OR `ban-count` LIKE '%text%' OR `ban-comment` LIKE ...
but Heidi shows error with ' symbols instead of `
So the problem appears when:
1. Click on Filter
2. Enter any text in "Create multi column filter" text box
3. Press Apply Filter
Heidi creates SQL query automatically and split it to a few lines but in case of Heidi's window size it past new after - symbol in column name like that: `ban-
comment`
... and error appears.
Here is a screenshot: http://clip2net.com/s/1tQKo
I guess it is necessary to prvent these errors by making one of two thing:
1. Do not split column names
2. Do not past new line in SQL query if column name was splitted and moved to a new line.
Please login to leave a reply, or register at first.