distal-attribute
distal-attribute
distal-attribute
distal-attribute

crash on edit in mssql

User, date Message
Written by boskras
2 months ago
Category: General
10 posts since Tue, 18 Feb 14
While editing single cell:

press "F2" to edit cell content
change the content and press ENTER

After pressing Enter Heidi suddenly turns off, i don't get any error message.
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
Is that reproducible or was it a one-time error?
Written by boskras
2 months ago
10 posts since Tue, 18 Feb 14
this error ocured every time, now i notice that it happen also in MYSQL databases while editing cell value, after pressing ENTER Heidi turns off without any message...
Written by boskras
2 months ago
10 posts since Tue, 18 Feb 14
in previous versions everything was OK, but i don't know which last one was good :(
Written by boskras
2 months ago
10 posts since Tue, 18 Feb 14
heidi exits even when no changes where made in cell.

My colegue has Heidi: 8.1.0.4545 and he can edit cell values without any problems.
Written by boskras
2 months ago
10 posts since Tue, 18 Feb 14
Update 4714 didn't solve this problem. :(
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
So, again, you are in the "Data" tab, and when editing a text value (or date, number...?) in the grid inplace editor, and pressing Enter lets HeidiSQL crash?
Written by boskras
2 months ago
10 posts since Tue, 18 Feb 14
yes, but wht i've noticed it only happens onWindows XP, on windows 7 everything is ok
Written by boskras
2 months ago
10 posts since Tue, 18 Feb 14
I've downloaded again from your website version 4694 and it's bug free, after update from menu help to 4714 it is crashing again. So I'll stay with 4694 version
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
Hmm ok, XP may be an explanation. I have no xp system any longer to use for testing purposes. Any chance you upgrade to windows 7?
Written by jfalchMoney, Euro
2 months ago
348 posts since Sat, 17 Oct 09
i´m on xp too, with very little chance of upgrade. could provide a "clean XP" vm...
Written by boskras
2 months ago
10 posts since Tue, 18 Feb 14
"Any chance you upgrade to windows 7?"

but it's not a sollution, what had change since version 4694 and now it's crushing on cell editing event. there are some chance to switch to win7 but not in the closest future. Heidi is very usfull tool and i would like to use it on systems that you declare that it's working fine :)

HeidiSQL runs fine on Windows (XP, Vista, 7, 8)
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
Yes, of course, I would like to keep Heidi compatible with XP. I only have no clue why it shuts down so silently for you. Could be that it's only on your computer, probably your colleage can try the current build?
Written by levinkatz
2 months ago
3 posts since Tue, 26 Jun 12
I'm on XP also and just noticed the same problem today, I was on 8.3.0.4711, updated to 4714 and it still happens, you can edit the contents as long as you click outside the current record to trigger the update, if you hit the enter key HeidiSQL closes.
Written by levinkatz
2 months ago
3 posts since Tue, 26 Jun 12
Just downloading the compiled exe, 4709 does NOT have this problem 4710 does.
Written by usiw
2 months ago
6 posts since Mon, 24 Feb 14
Same issue here even after updating to 8.3.0.4714 on XP SP3.

While editing a cell value in a results window if I press ENTER it closes immediately. If I edit a cell value but then click to a different row using the mouse it performs the DB update successfully. This happens on varchar, text, tinyint(1), but does not happen on datetime
field.
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
I'm just creating an XP image in VirtualXP, so I have an environment for testing this issue.
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
Hm, on XP SP2, I am unable to reproduce that Enter issue.
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
"Virtual PC", not "Virtual XP"...
Written by usiw
2 months ago
6 posts since Mon, 24 Feb 14
This may not always happen then a column is edited the first time. For example:

1) Edit an int column by pressing "Enter", typing a number like 3, then pressing "Enter"
2) navigate to a new row and do the same to a column in that row.
3) Navigate back to the row edited in step 1 by pressing "Enter", typing in a number like 2, then pressing "Enter"
4) at that point HeidiSQL immediately closes (no warnings, etc).

I just tested this with 8.3.0.4716
Written by usiw
2 months ago
6 posts since Mon, 24 Feb 14
step 3 should be:

3) Navigate back to the row edited in step 1 and edit the value by pressing "Enter", typing in a number like 2, then pressing "Enter"
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
Is it right that this only happens in MSSQL mode? On MySQL, I cannot reproduce it - I've done exactly what you wrote.
Written by ansgar
2 months ago
4784 posts since Fri, 07 Apr 06
Even on MSSQL and XP, I cannot reproduce this crash. I can't help it - it seems there is some more going on in your machine.
Written by usiw
1 month ago
6 posts since Mon, 24 Feb 14
In my case it happens with Percona Server 5.5.16 with XtraDB (GPL), Release rel22.0, Revision 189

I have the exact same HeideiSQL version on Windows 7 SP1 and don't have the problem there. If it helps, I am running both W7 and XP SP3 in Vmware Fusion on a Mac and nothing has changed in my current configuration in over two years. HeidiSQL hasn't had this particular problem until the past month or so, abou tthe same time that everyone else started experiencing the same issue.
Written by usiw
1 month ago
6 posts since Mon, 24 Feb 14
I've narrowed this down to a change that occurred between 4705 and 4706. I can't reproduce in 4705 but it always happens in 4706.
Written by ansgar
1 month ago
4784 posts since Fri, 07 Apr 06
r4706 was reverted in r4709, so does it also happen in the current build (4719)?
Written by levinkatz
1 month ago
3 posts since Tue, 26 Jun 12
I just downloaded just heidisql32.r4719.exe, did not run the installer and yes it still happens.
Win XP pro version 2002
Service Pack 3
Mysql 5.0.45
Written by ansgar
1 month ago
4784 posts since Fri, 07 Apr 06
That sounds random somehow. r4706 was reverted and it modified anyway nothing with grid editing, but with query parameter binding. I am not able to track it down to anything. Shit.
 

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