Lost the result output window!
| User, date | Message |
|---|---|
|
Written by eos
1 year ago Category: General 11 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
1 year ago 11 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
1 year ago 11 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 jfalch
1 year ago 222 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
1 year ago 3950 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
1 year ago 11 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
1 year ago 11 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
1 year ago 3950 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 jfalch
1 year ago 222 posts since Sat, 17 Oct 09 |
;D ! |
|
Written by norris1
1 year 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
1 year 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
1 year ago 3950 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
1 year 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
1 year ago 3950 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
1 year ago 2 posts since Thu, 29 Mar 12 |
Thanks that worked |
|
Written by ansgar
1 year ago 3950 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. |