Backspace strangeness

rsterenb's profile image rsterenb posted 5 years ago in General Permalink

Not sure if this is supported since I'm on Linux/Wine. I don't know if this also happens on Windows, because I guess someone would have mentioned it by now and I found nothing here.

I'm currently running HeidiSQL 10.2.0.5669. Whenever I'm in a grid (table data, table editing) and I press backspace, the active tab looses focus and the first tab called "Host [...]" becomes active. Del(ete) works as expected, but.. the number of times I press Backspace and end up in another tab.. well, it's quite annoying. ;-)

I'm unsure about when this started, but I do know this didn't use to happen in a previous version. Is it something that can be fixed?

rsterenb's profile image rsterenb posted 5 years ago Permalink

In fact, I booted a Windows PC, updated to the latest version and it doesn't happen there.

goffyara's profile image goffyara posted 5 years ago Permalink

+1.

Backspace has this unexpected behavior. Including when editing data.

wine-4.12.1 (Staging) Heidisql 10.2.0.5608

ansgar's profile image ansgar posted 5 years ago Permalink

Maybe it's that "Go to" menu item which does that, although I don't guess you have set your backspace key as shortcut for it. But maybe it helps to remove the default one (Ctrl + 1), in Tools > Preferences > Shortcuts?

Description

goffyara's profile image goffyara posted 5 years ago Permalink

to remove the default one (Ctrl + 1)

unfortunately it's useless...

There is same situation in Heidisql 9.4. I suppose the changes in wine are to blame.

Arffeh's profile image Arffeh posted 5 years ago Permalink

Can confirm this happens when under the influence of wine. Editing fields is insanity.

ansgar's profile image ansgar posted 5 years ago Permalink

Are you experiencing the same issue in some other Windows app under the same Wine version?

goffyara's profile image goffyara posted 5 years ago Permalink

Are you experiencing the same issue in some other Windows app under the same Wine version?

In other Windows applications under the same Wine version it works correctly

pazof's profile image pazof posted 5 years ago Permalink

Also confirming the Backspace issue on Linux (Manjaro). Happens to me in all HeidiSQL 64-bit versions 9.5 onwards.

Must have something to do with Wine. As a temporary workaround I downgraded Wine to version 4.1-1 and now it works. In every version above that (tried 4.10, 4.11, 4.12, 4.13, and 4.15), hitting backspace while editing a field in the grid just focuses the "Host" tab.

I noticed that this is also happening in the Preferences window, when trying to assign the Backspace key to a shortcut: When the shortcut textbox is focused and I press Backspace, the tab focus is shifted to the "General" tab of the Preferences window. Looks like it must be for the same reason.

petzoldf's profile image petzoldf posted 4 years ago Permalink

I can also confirm the behavior. After updating to the current Codeweaver Crossover (Wine 4.12.1), the behavior also occurs in a Mac environment. Because of MacOS Catalina the update to the latest Wine version is unavoidable. The problem does not occur in Heidi's SQL Editor. But if I want to change a value in the data view within a column/cell, the backspace key cannot be used.

msmiley's profile image msmiley posted 4 years ago Permalink

I can also confirm that HeidiSQL 10.2 works perfectly on wine 1.6.2, but on wine 4.17 I'm having above described "backspace problem".

Arffeh's profile image Arffeh posted 4 years ago Permalink

I gave up on using heidi with wine a long time ago. I just use a VM for it with clipboard sharing and be done with it. Crashes and other odd behavior are becoming more common with it under wine.

I think the "works with wine" text should be removed until thoroughly tested/bugfixed for current-gen wine releases.

ansgar's profile image ansgar posted 4 years ago Permalink

I think the "works with wine" text should be removed

Sad but true. I suppose it's fair to change that into something like "may work with Wine, but untested".

Arffeh's profile image Arffeh posted 4 years ago Permalink

Yeah nah sorry, it's not great at the moment. I wouldn't even say that at the moment.

Adding fuel to the fire, wine 5.0 just got released today. :)

sasho1982's profile image sasho1982 posted 4 years ago Permalink

Actually, HeidiSQL works fine with wine! I've had it working with all major versions of wine including 5.0-dev.

The problem with backspace is easy to solve. You just have to unassign Ctrl + 1 not only from "Goto Marker 1" but also from Various -> Tab 1 then restart.

I love HeidiSQL! To me this is the best software for working with MySql! I can't say enough to express my admiration and gratitude to the author!

Arffeh's profile image Arffeh posted 4 years ago Permalink

That's not a solution, that's a workaround.

Regardless, thank you for sharing. Hopefully that could narrow down why the behaviour started out of the blue in the first place.

mstoute's profile image mstoute posted 4 years ago Permalink

The problem with backspace is easy to solve. You just have to unassign Ctrl + 1 not only from "Goto Marker 1" but also from Various -> Tab 1 then restart.

Unfortunately this didn't work for me :(

I love HeidiSQL! To me this is the best software for working with MySql! I can't say enough to express my admiration and gratitude to the author!

+1 :)

Code modification/commit f10b9b0 from Ansgar Becker <anse@heidisql.com>, 4 years ago, revision 10.3.0.5873
Prefer KeyPressed() over GetKeyState(), which may help to fix the backspace crashes on Wine: https://www.heidisql.com/forum.php?t=34351
yapsr's profile image yapsr posted 4 years ago Permalink

I can confirm the backspace issue is resolved by using Wine 4.8, until the Wine developers have fixed the issue.

With these commands I installed Wine 4.8 in Debian Buster:

wget dl.winehq.org/wine-builds/debian/dists/buster/main/binary-amd64/wine-staging_4.8~buster_amd64.deb

sudo apt-get install wine-staging-i386=4.8~buster wine-staging-amd64=4.8~buster

sudo dpkg -i ./wine-staging_4.8~buster_amd64.deb

Wine 4.8 will be installed in /opt/wine-staging/

yapsr's profile image yapsr posted 4 years ago Permalink

In follow up to my post above, you could have to make a symlink to be able to access wine easily:

sudo /opt/wine-staging/bin/wine /usr/bin/wine

patro666's profile image patro666 posted 4 years ago Permalink

This happens on Ubuntu 20.04 and Wine 5.18 Editing fields is extremally hard :(

Nick R's profile image Nick R posted 4 months ago Permalink

I know it's been awhile but if you're still dealing with this issue, I tried all of the fixes above to no avail, so I tried installing Heidisql wine from the snap software package manager and the problem is non-existent and it adds Heidisql as an executable. Hope this helps someone.

Nick R's profile image Nick R posted 4 months ago Permalink

Sorry I forgot to add I'm using Ubuntu 22.04 Desktop.

Nick R's profile image Nick R posted 4 months ago Permalink

Hey, ya know what, now after testing it's even worst. I'm done with Heidisql on linux. Dbeaver-CE works well.

msmiley's profile image msmiley posted 4 months ago Permalink

I'm using HeidiSQL 10.2 under Ubuntu 20.04. almost on daily basis. It works very stable without any problems (and no backspace problem). The backspace problem is very annoying but with the wine-staging-6.1 (version 6.1~focal-1) there is no backspace problem (i'm using 64bit standalone heidisql version) - works out of box.

As far as I know it's a wine problem (depends which version you use) - I didn't have backspace problem on the old version of wine (1.6.2)

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