Can't see anything in query tab

iveyj's profile image iveyj posted 4 years ago in General Permalink

Folks, I suddenly can't get see anything useful in the query tab, although previously it was working fine for months.

Resizing/minimizing/maximizing the main window doesn't help, neither does creating new query tabs or reinstalling the program.

I am using 10.3.0.5771, but it also didn't work in the previous version I was using (10.2.xxx?). Running on a Surface Book Tablet running Windows 10.

Any suggestions?

Thanks

iveyj's profile image iveyj posted 4 years ago Permalink

Screen shot...

1 attachment(s):
  • heidi-capture
ansgar's profile image ansgar posted 4 years ago Permalink

What you see there is the right side toobox on the query tab, not the query editor. You perhaps made it too wide previously. Try to resize the left database tree to a minimum, as shown in the screen:

Description

If that doesn't help, exit HeidiSQL and start regedit.exe:

  • navigate to HKEY_CURRENT_USER\Software\HeidiSQL
  • delete value queryhelperswidth (or edit it and set it to a pixel width of 200)
iveyj's profile image iveyj posted 4 years ago Permalink

I tried both things you mentioned and they didn't help. The queryhelperswidth was something like 26000, but if I changed it to something reasonable and ran the application, I still couldn't see what you're supposed to and it would change back to the crazy number. I tried uninstalling and reinstalling the app and deleting the registry keys, but no good. It seems to me I had this problem before and tweaking the register helped, but not this time.

It probably has something to do with my display setup, with a hires laptop screen plus an external monitor. I tried disconnecting the external monitor and playing around with the screen arrangement in windows, but no go.

I reinstalled windows from scratch and it is working ok for now. Now I'm afraid to hook up the external monitor! I'll let you know if the problem comes back.

HeidiSQL is a very helpful tool, I'm lost without it!

Thanks, Jack

puppriss's profile image puppriss posted 4 years ago Permalink

I also have this problem with the new build 10.3.0.5771 on Windows 10. The regedit solution didn't seem to change anything at all. The only thing that worked for me was to have an 'extend'ed setup with my laptop & monitor, then I could drag the Heidi window wide enough and minimise the right-side toolbox. But when I open other queries toolbox is again too wide... Cheers!

ansgar's profile image ansgar posted 4 years ago Permalink

Ok, this might be a bug in the code then. I'll have a look.

ansgar's profile image ansgar posted 4 years ago Permalink

I just probably found the cause of it, which I introduced 11 years ago :)

See this ticket, which was on Google Code, then migrated to Sourceforge: https://sourceforge.net/p/heidisql/tickets/814/

I added a procedure which should prevent the helpers box from getting too small. And I guess this has some side effects. So I will replace that logic testwise with a static max-width setting.

Code modification/commit 5a35096 from Ansgar Becker <anse@heidisql.com>, 4 years ago, revision 10.3.0.5783
Revert a part of commit:7ed97b3fe2f989b19bd282ae00c64de8e7b4871d which should have fixed a resizing bug on the query helpers box. See https://www.heidisql.com/forum.php?t=35096
ansgar's profile image ansgar posted 4 years ago Permalink

Ok, you could update HeidiSQL in a few minutes and check again if that works now.

puppriss's profile image puppriss posted 4 years ago Permalink

Great, super, looks like this fixed my problem and all is well now.

Thanks for the quick turnaround :-)

Cheers!

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