distal-attribute
distal-attribute
distal-attribute
distal-attribute

Lost the result output window!

User, date Message
Written by eos
2 years ago
Category: General
14 posts since Thu, 16 Feb 12
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.
Written by eos
2 years ago
14 posts since Thu, 16 Feb 12
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.
Written by eos
2 years ago
14 posts since Thu, 16 Feb 12
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.
Written by jfalchMoney, Euro
2 years ago
380 posts since Sat, 17 Oct 09
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.
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
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
Written by eos
2 years ago
14 posts since Thu, 16 Feb 12
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?
Written by eos
2 years ago
14 posts since Thu, 16 Feb 12
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.
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by jfalchMoney, Euro
2 years ago
380 posts since Sat, 17 Oct 09
;D !
Written by norris1
2 years ago
2 posts since Wed, 28 Mar 12
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 :\
Written by norris1
2 years ago
2 posts since Wed, 28 Mar 12
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
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by Mike15739
2 years ago
2 posts since Thu, 29 Mar 12
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?
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by Mike15739
2 years ago
2 posts since Thu, 29 Mar 12
Thanks that worked
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
So, r4114 aims to auto-fix the zero-height of the SQL log, each time you start heidisql.exe.

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

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