Issues with 8.1.0.4545

Hi, I'm wondering if there is a resolution with the tab key not working while editing a table. I saw a bug report that this is a known issue and wondered if it'll be fixed soon or not?

Next I'm having a problem with Heidi 8 disconnecting from a MySQL server version 5.1.66 after 20 seconds. This was not a problem with version 7, and in fact I have tested the connection from a different workstation with version 7 to the same server and it does not disconnect. With the 8.1.0.4545 on a different server version 8 does not have this disconnect problem. So my first idea was that something changed on the MySQL server, but that server hasn't changed and hasn't been rebooted/restarted in 6 months, so it can't be a change on the server. The only thing that has changed is my upgrade to version 8. So then I tested version 7 on a different workstation and connected to this same server and it did not disconnect after 20 seconds. So it seems logical that the problem is between version 8.1.0.4545 to MySQL 5.1.66. The 8.1.0.4545 does not have the same problem when connecting to MySQL 5.1.67, nor 5.5.22. But again, version 7 to the MySQL 5.1.66 is fine and does not disconnect after 20 seconds.

By the way, I wanted to revert back to Heidi version 7 after having version 8 installed, so I uninstalled 8, then installed 7, and now 7 won't show the tables in the database/table left window. Is there some file(s) left behind by 8 that I can delete to revert back to version 7?

Thanks
John

If you saw the report for the tab issue then you should have seen that this was fixed, or? Just update to the latest build (Help > Check for updates)

For your disconnect problem I guess that was again something broken in the libmysql.dll shipped with the 8.0. I fixed that by using a version from a MariaDB server.

I recommend updating to 8.1 again and then keep being up-to-date by checking Tools > Preferences > Miscellaneous > "Check for nightly builds also".

No, when I saw that bug report it did not say it was fixed (at that time which was not today). I've just been living with the problem and since I was creating an account here and going to ask about the other problem I had, I thought I would find out if it was fixed) - thanks for letting me know the tab key works.

I did as you suggested and downloaded the nightly build, I have installed it and again I have a disconnect after about 20 seconds and my screen goes gray and is uneditable.
/* Connection to xx.xx.xx.xx closed at 2013-10-15 14:26:03 */
So getting the nightly build (8.1.0.4571) does not seem to fix the disconnect.

Thanks for your time,
John

You first need to install the 8.1 installer, and *then* update to the latest build.

I have version 8.1.0.4571 installed. When I click on Check for updates, it says "Your HeidiSQL is up-to-date (no update available).

Do I have the latest version? If so then the problem still exists.

Thanks John

Revision 4571 (yours: 4571)
Compiled: 2013-10-14 (yours: 2013-10-15)
Notes: * (r4571) Issue #3366: Do not set object as favorite when mouse moves from db to table node between mouse-down and mouse-up event.
* (r4570) Issue #3366: Enhance performance for internal favorites management. Let the connection hold its favorite list instead of reading it from registry in all places where we need them.
* (r4569) Issue #3366: Enhance phrasing in favorite button
* (r4568) Issue #3366: Make state of "Favorites only" button persistent between sessions.
* (r4567) Additional checks for Assigned() and <> nil in SetupSynEditors, to fix exceptions (in debug messages only?)
* (r4566) Introduce tree favorites: * Add a button right besides db/table filter for hiding non-favorites * Add an icon on the very left of table nodes, showing whether they are favorites Fixes issue #3366
* (r4565) Enable apply button when selecting alternating row colors. Fixes issue #3380.
* (r4564) Restore vertical and horizontal scroll offset in table list after refreshing. Fixes issue #3379.
* (r4563) Extend MDAC hint for Wine users. Fixes issue #3377.
* (r4562) Revert a part of r4529, as that broke using the right font name+size in preferences dialog (SQL tab). Fixes issue #3378.
*

FYI, this morning I upgraded to the latest nightly build (8.1.0.4572) and the disconnect after 20 seconds is still occurring.

Thank you,
John

Please download the installer... As said above, you need the libmysql.dll from the 8.1 installer.

Perhaps I have not been very clear, I have downloaded the 8.1 installer 3 times and installed it 3 times. Right now I have downloaded it again and installed new. Right after installation it told me there was an upgrade to .4572, and I immediately downloaded it too. After the installations where complete I connected to this server and waited 20 seconds and I was disconnected again. The only difference between the 4545 and this 4572 seems to be that the right hand window does not go gray, but the cells in the table are not clickable just like when it was grayed out.

Obviously the clicking of the right hand window is not the problem, but having it disconnect me after 20 seconds is the problem. Version 7 did not do this. Is there anyway back to version 7? When I've tried, the left window does not show tables.

Thank you again,
John

Perhaps I have not been very clear, I have downloaded the 8.1 installer 3 times and installed it 3 times. Right now I have downloaded it again and installed new. Right after installation it told me there was an upgrade to .4572, and I immediately downloaded it too. After the installations where complete I connected to this server and waited 20 seconds and I was disconnected again. The only difference between the 4545 and this 4572 seems to be that the right hand window does not go gray, but the cells in the table are not clickable just like when it was grayed out.

Obviously the clicking of the right hand window is not the problem, but having it disconnect me after 20 seconds is the problem. Version 7 did not do this. Is there anyway back to version 7? When I've tried, the left window does not show tables.

Thank you again,
John

---sorry about the second post, I clicked the back button and reposted, just delete it, I would but can't see how---

Ok, in that case it may be some other issue. But you wrote in your very first post above: "With the 8.1.0.4545 on a different server version 8 does not have this disconnect problem". So I thought that the 8.1 could solve your problem.

20s is the interval for the automatic ping to the server. Could you please test if you get that disconnect on a different server too?

Connected to a MySQL 5.5.22 (serverB) with version 8.1.0.4576 does not do the same thing. And, version 7 did not disconnect when connected to the first server (serverA).

Thank you,
John

You can try this libmysql instead, which is the one included in the 7.0 release, taken from the MariaDB 5.2.10 server: https://heidisql.googlecode.com/svn-history/r3992/trunk/out/libmysql.dll

I closed HeidiSQL, opened the heidisql program folder and renamed the libmysql.dll then copied this file in to it. I then opened HeidiSQL and tried again. It still disconnects after 20 seconds.

I've tried uninstalling Heidisql 8.xxx and tried to install version 7 again, but the left window does not show the tables. Is there a way to get back to a usable version 7?

Thanks
John

Well you can uninstall and install the 7.0 release again. See the "Previous releases" link on the download page.

But that's all very strange. Never heard that before..

When I did uninstall on 8 and then reinstall with 7, it doesn't work properly. However I just got done uninstalling 8 and went into the registry and renamed the HeidiSQL to HeidiSQL.8 and then installed 7 and it I can now see the tables in the left window.

I also have been connected to serverA for over 3 minutes and it has not disconnected yet! I'm not bold enough to claim that the server is not at fault, however it would appear the problem lies with one of the 2, or with a combination of 8.1 and MySQL 5.1.66.

I'll be happy with 7 for now, and when/if you can get a resolution to the disconnect I'll be happy to try that version.

Thank you,
John

Without further investigations I will not be able to track down your issue. You could for example compare your both registry folders and send me a diff file. If I understand right you have ensured this is a settings/registry issue.

Good night..

I don't believe the issue about getting disconnected is related to the registry. I think that has more to do with 8.1 and not the registry. The registry was the problem regarding version 7 not working right. Once I removed the registry I could install version 7 and the left window now shows the tables.

So the problem with getting disconnected still exists with version 8.1

Thanks
John

from the machine where the disconnect happens, can you connect to that server with the mysql command line client ?

Ansgar, this morning when I try to download the 8.1 Installer, the link fails. I am on a different computer today and thought I would try this all over again.

Thanks
John
http://www.heidisql.com/installers/HeidiSQL_8.1.0.4545_Setup.exe

from the machine where the disconnect happens, can you connect to that server with the mysql command line client ?

Yes.

Ansgar, when using the same 8.1xxxx version on a different computer today connecting to the serverA (MySQL 5.1.66), it again closes the connection after 20 seconds.

So just like the PC yesterday. Yesterdays PC was a win7 32bit, todays PC is a win7 64bit if that matters. I also have a laptop with Win8 64bit if you want me to try that.

So since I couldn't download a new version yet (previous email about the broken link), I decided to revert back to your version 7, so I uninstalled my version 8.1.0.4545. I installed version 7 and again the left window did not show the tables. I don't think you need to fix that, but thought I would bring it up since you said no one has ever mentioned this problem. However I again renamed the registry key, installed 7 and works again.

So after reverting to version 7 and connected to serverA just like yesterday, everything works fine and no disconnect.

I can do as much testing as you wish if you think of anything else you want me to try.

Thanks
John

The link is offline because I committed "too much" yesterday and this morning... thanks for the hint, I will go and fix that in a few hours.

You could be more detailed when you say "the left window did not show the tables". Is it the tree, which shows databases, but no tables, or what?

I am happy to provide my detail.

It is the tree, it does not show the list of tables, but it does show the database name which has been selected with an arrow looking icon pointing 45deg down, like there should be a tree, but nothing more is showing.

Link to release installer just fixed...

Your description looks as if you have activated the favorites button right besides the table filter at the top, but without having marked tables as favorites. See here for a screenshot.

So this morning I had v7 installed and have been using it, I then upgraded to the 8.1.0.4545 help/check for updates. After it was done I did another help/check for updates and upgraded to 8.1.0.4581. I can see the favorites button by the table filter, but it is not enabled.

The first thing to note is 8.1.0.4581 closed my session to serverA after only 10 seconds.

I've just spent 30 min installing v7, uninstalling v8 and so on in an effort to duplicate whether the favorites button was enabled, and I cannot duplicate the problem of the tree not showing tables when I revert back to v7. I have tried every way of uninstalling, installing and going back to v7 and it's not doing it again which I guess is good news. It still had occured on 2 different PC's that over time had been upgraded from 7 to 8.1 and up to 8.1.0.4581.

I'm glad I can't reproduce that problem, however the main issue is still getting v8.1 to stop disconnecting me after a short period of time. In 8.1.0.4545 it would disconnect me after 20 seconds. With 8.1.0.4581, it's now more random. The first time it was 10 sec, this last time I tried it was 15 seconds.

Thanks
John

Please check this: Hover your mouse over the bottom status bar panel, where it says "MySQL x.x". You will see a balloon hint containing 10 or 20 details about the connection and the server. Please post what you see as "Client version:...". Please a short answer :)

v8.1.0.4582
Client version (libmysql): 5.3.12-MariaDB

Thanks
John

I've also noticed on v7, if/when the connection gets timed out, I can still click on and edit content in the row view, and when I try to save it, it reconnects. Can this feature be enabled in 8.1x? If it were enabled, instead of making the cells read only I think I would not have noticed the disconnects happening so frequently.

Thanks
John

Two issues:

1) I'm on a Win2000 server. I had been running Heidi v8.? and upgraded to 8.1.0.4545. The program gave me the error "The procedure entry point DecodePointer could not be located in the dynamic link library KERNEL.DLL". I had this problem once before and remembered that it was the libmysql.dll. Luckily I had renamed copy of a working version of the dll saved. After I replaced the dll the program seems to be working, apparently the update overwrote that file.

2) I think there is a problem with how Heidi is handling parameters when I try to load an .sql file. I have 2 files on my desktop. 'Lookup MCI.sql' & 'fixed.sql'

When I double click on the 'Lookup MCI.sql' file I get an error dialog that says 'Could not load file(s): MCI.sql. It's leaving off the part of the filename before the space character.

I opened Heidi and loaded the file manually (without issue) and saved it as 'fixed.sql', and then exited Heidi. I tried double clicking on 'fixed.sql' and the error dialog says "Could not load file(s): Settings\Administrator\Desktop\fixed.sql". The full path for the file is 'C:\Documents and Settings\Administrator\Desktop\fixed.sql' again it seems to be breaking up at the space character

Hey, what about using another thread for that new topic.

1) Please look at the Windows 2000 notice on the download page. And yes, the installer overwrites the libmysql.dll. Not so the build updater.

2) Use doublequotes for file names on the command line, not single quotes.

teksaport: Reconnecting is not a feature which was removed for 8.1. Please do not mix guesses with questions here.

The point is a problem of your specific server version with the libmysql.dll in your HeidiSQL directory. Neither you nor me can do any other thing than testing different versions of that file, for example the one I mentioned above with a link. If that does not work, download a newer MySQL server and take the one from the lib directory.

As the topic is "Issues with 8.1.0.4545" and multiple issues were already discussed in this thread I didn't see that as an problem. Also, I'm aware of the Win2000 issues, that's why I identified it at the outset and indicated that it was an issue to which there was a pre-existing solution

I ran the updater/installer prompted with when starting the old version. This really isn't an issue, just something I wanted to make known, so no resolution required. I think anyone else who gets prompted and has made similar adjustments will have the same issue as they will not "know" that they're supposed to use the updater.

I will start a different thread for the file association issue

My apologies for "guessing". But in 8.1xxx it seems to me that when Heidi gets disconnected, the right window (Data) tab is changed to "read only", and gets grayed out. In version 7 that does not happen. So it appears to me (an enduser) who is not a Delphi programmer, that a feature has been changed (presumably removed). So if I am wrong, I apologize, but can you tell me if the cells turning to read only and grayed out is a feature of libmysql.dll? I figured that was a feature in your program not libmysql.dll.

As for a link to a libmysql.dll - I did try the one you linked to previously and it did not change any behavior.

Thanks
John

A disabled data grid is the result of your disconnection. You said various times you get disconnected, so let's solve that first before examining other issues which are most likely follow up issues.

If you are willing to continue, I can, but I thought a work around - since we are having a problem, would be to remove the disabled grid, like in version 7, and this will all be over.

Thanks
John

Please read... the disabled grid is an intentional effect of a broken/disconnected session. This is not a bug, it's really a feature, and a reasonable one :)

Might I ask why in 7 it doesn't work that way?

Thanks
John

I thought you're having the disconnects only in the 8.x versions, so why should 7.0 disable the grid when your connection is alive??

I think I mentioned in an earlier post, that v7 would time out after a period of inactivity, not 10 - 20 seconds like v8, but a lot longer (I just test it and it took 10 minutes to timeout). When it did time out it leaves the grid editable. If/when I made a change to a cell, it then reconnects and updates the server. So I am only having disconnect issues with v8, but I'm asking why v8 acts differently? V7 allows me to edit the grid when it is disconnected and v8 does not. If v8 worked like v7, my time out issues with v8 would not be an issue since I could keep working and it would automatically reconnect. With v8 I have to click on a different table for it to reconnect. Then go back to the table I was in, pull up the data tab and it disconnects again.

Thanks
John

Ok, then I had done that somewhere between 7.0 and 8.0, in order to avoid exceptions on disconnected sessions. Maybe you do not get exceptions but there were some for other users and probably also on MSSQL.

Ok, so it sounds like that was a fix to a different problem and won't be something you could turn back on. I understand that.

I'll just have to try different libmysql.dll files and/or upgrade the MySQL version.

Thanks for your help, and I believe we've taken this as far as it can go.

John