Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Backspace strangeness

rsterenb's profile image rsterenb posted 11 months 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 11 months 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 10 months ago Permalink

+1.

Backspace has this unexpected behavior. Including when editing data.

wine-4.12.1 (Staging) Heidisql 10.2.0.5608

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 10 months 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 10 months 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 10 months ago Permalink

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

ansgar's profile image ansgar posted 10 months ago Permalink

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

goffyara's profile image goffyara posted 10 months 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 9 months 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 7 months 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.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
msmiley's profile image msmiley posted 6 months 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 6 months 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 5 months 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 5 months 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 5 months 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 5 months 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 5 months 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>, 5 months ago, revision 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 1 month 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 1 month 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

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.