Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Query Error when clicking on Data tab

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

Hi,

So, I can click on this particular table. But, once I click on the Data tab, HeidiSQL pops up this error message.

SQL Error (1064): 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 'LIMIT 1000' at line 3.

And the log window shows this:

SHOW CREATE TABLE `fin_pro`.`att_log`;
SELECT * FROM `fin_pro`.`att_log` WHERE 

 LIMIT 1000;
/* SQL Error (1064): 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 'LIMIT 1000' at line 3 */

But, I can display the data if I run query manually:

SELECT * FROM `fin_pro`.`att_log` LIMIT 1000;

How do I remove the offending SQL query?

Thank you Henry

gnulab's profile image gnulab posted 1 month ago Permalink

Here is the screenshot of the log file.

Description

ansgar's profile image ansgar posted 1 month ago Permalink

Is that with the latest v12.0? If not please update.

If it's with 12.0, watch out for the filter panel on top of the grid, and remove white spaces from it. I suppose there are some blank new lines or such.

gnulab's profile image gnulab posted 1 month ago Permalink

Yeah, it is the filter alright.. click on CLEAR and everything appears again.

Thanks.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.