Lost the result output window!

When I run some sql, usually you get a nice grid of data back.
Now when I run any sql, there is no output or output window.

I tried the following:
1) updating to the latest vers
2) maximising/minimising
3) moving to a different monitor.
4) closing opening app.

At the very bottom, I can see it says:

/* Affected rows: 0 Found rows: 1,315 Warnings: 0 Duration for 1 query: 0.078 sec. (+ 1.716 sec. network) */

So the sql is working and returning rows, just no way to see them all of a sudden.

Forgot to say, even though I cant "see" any output rows, If I go to the tools menu at the top and hit "export grid rows" it saves the data.

So every query I run, I have to save the results to a file, then open the file in excel.

I also notice that the slider bar for the SQL window goes off the bottom, i.e. I cant actually scroll down to see the end of a multi-page sql. The scroll bar extends below the window, if you see what I mean.

Yesterday it was all god.

Today broken.

I have done nothing (honest).

The only thing that I can think of is I was using a higher resolution monitor yesterday than today, but I have switched between them many times in the past with no issue.

this is the by-now-famous "results pane made invisible" problem, ie the height of the results pane has become zero (or negative?). attempt to drag at the lower edge of the sql pane; if you are lucky, the results pane will reappear. if not, ask anse for some registry magic to make the pane appear.

Hehe, yes...

Here's the hack:
1. exit all heidisql.exe instances
2. run regedit.exe
3. navigate to HKEY_CURRENT_USER\Software\HeidiSQL\
4. delete value "querymemoheight"
5. restart heidi to see it

Thanks for the reply!

Unfortunately, im running heidiSQL in portable mode as my super fast machine has been turned into a 286 with all the installs/drivers. So there is no entry for HeidiSQL under Software.

Is there an equiv. fix for portable that you know of?

I have a workaround, I connected a high -resolution monitor, and I was able to rescue the window and drag it backup. Now when I go back to a normal resolution monitor, I can see the output window.

r4111 should heal that behaviour finally, by auto-resizing components to a height which allows the grid to be displayed at least for a minimum of 20 pixels.

;D !

Hi. I'm using nightly version 7.0.0.4112 and still not seeing the query log at the bottom that is missing since last update :\

fixed manualy by changing sqloutheight property from 0 to 80 in
- regedit.exe
- HKEY_CURRENT_USER\Software\HeidiSQL\
lol. Hope you fix it somehow in next update

r4111 fixes only the upper query editor when it is about to be hidden. The SQL log can of course be also affected, I'll check if I can fix that in the same method.

I am getting the same problem even after I use all the steps mentioned above. I have no more log file to let me know what has been run or what I have run in sql code. I am currently using r7.0.0.4112 and still getting the same problem even after I uninstall and reinstall. Could someone please help?

It should definitly help to delete the "sqloutheight" value *after* exiting all running heidisql.exe instances.

Also, as said, I'll go and add a fix for that old problem very soon.

Thanks that worked

So, r4114 aims to auto-fix the zero-height of the SQL log, each time you start heidisql.exe.

"by-now-famous" ... ts! :)

I ran into this recently as well (2021). Deleting the "sqloutheight" and "querymemoheight" keys in HKEY_CURRENT_USER\Software\HeidiSQL\ fixed it. I think the issue arose because sometimes I connect a 19:10 monitor (1920x1200 px), and after I disconnect it and return to using my laptop screen (1924x1080 px) the results tab disappears.

Perhaps some kind of check to ensure that the query editor window + results tab + log window combined height doesn't exceed HeidiSQL window height? Dunno.

Anyways, thanks again for Heidi!

Hello, I confirm that this happens when I change the connected monitor, from a 1920x1080 to a 1920x1200, as @lieszkol noted above. Deleting the mentioned "sqloutheight" and "querymemoheight" values from the registry did not fix the issue though. Deleting all the values with "height" in their name did not fix it either. I deleted all the values and... voila. Kind regards

Hello, I encountered the same problem when I disconnected my laptop from my monitors, and started using HeidiSQL on my laptop's screen. To solve the issue, as mentioned a few times above, I removed the two lines of settings for querymemoheight and sqloutheight and closed and relaunched HeidiSQL. I got a HeidiSQL Portable 11.3.0.6295 and these settings were saved in portable_settings.txt. Thank you to everyone above who mentioned this solution already.

Version 11.3.0.6317...

This problem still exists.

I've had the same monitors for several months, and just today HeidiSQL decided to not the output window.

Deleting the 2 registry keys did work, but that's a workaround, not a fix. I would have hoped that, seeing as how this has been a problem for over 10 years now, it could have been solved.

Nothing of the above worked for me

Even uninstalling HeidiSQL and installing it again

@Spyros please go to Help > Check for updates, then click "Download and install build xyz".

In the latest builds, I have added a "reset" menu item for such situations:

Thanks, latest build fixed it