Bug Report: changing from table A to table B when table A has unsaved changes.

[expired user #8552]'s profile image [expired user #8552] posted 10 years ago in General Permalink
Hi Ansgar,

First of all, thanks a bunch for creating/maintaining HeidiSQL to begin with.

Priority: Low
Urgency: Very Low
Bug: When editing a table, A, if you change to a different table, B, when table A has unsaved changes opens a dialog with 3 options: Yes (save), No and Cancel. When you choose Yes, it DOES save the table (A), does NOT open the other table (B), and generates the following bug:

operating system   : Windows 7 x64 Service Pack 1 build 7601
system up time     : 2 hours 48 minutes
program up time    : 2 hours 6 minutes
processors         : 8x Intel(R) Core(TM) i7-4770 CPU @ 3.40GHz
physical memory    : 4176/7864 MB (free/total)
free disk space    : (C:) 14,89 GB
display mode       : 1920x1080, 32 bit
process id         : $64c
allocated memory   : 100,22 MB
largest free block : 8185,55 GB
executable         : heidisql.exe
exec. date/time    : 2014-11-11 20:38
version            : 9.1.0.4867
compiled with      : Delphi XE5
madExcept version  : 4.0.8.1
callstack crc      : $d069d024, $54679ef2, $54679ef2
exception number   : 1
exception class    : EAccessViolation
exception message  : Access violation at address 00000000008DE3BA in module 'heidisql.exe'. Read of address FFFFFFFFFFFFFFFF.
main thread ($c80):
008de3ba heidisql.exe VirtualTrees   30117   +6 TBaseVirtualTree.GetNodeData
00c2542f heidisql.exe Main            7638   +7 TMainForm.DBtreeInitNode
008cb435 heidisql.exe VirtualTrees   22106   +2 TBaseVirtualTree.DoInitNode
008d1640 heidisql.exe VirtualTrees   24500  +10 TBaseVirtualTree.InitNode
008db3f0 heidisql.exe VirtualTrees   28445   +6 TBaseVirtualTree.GetDisplayRect
008e0231 heidisql.exe VirtualTrees   31228   +3 TBaseVirtualTree.InvalidateNode
008f2959 heidisql.exe VirtualTrees   37033   +1 TCustomVirtualStringTree.InvalidateNode
008ca962 heidisql.exe VirtualTrees   21735  +29 TBaseVirtualTree.DoFocusNode
008d0e9a heidisql.exe VirtualTrees   24316 +225 TBaseVirtualTree.HandleMouseDown
008c4df5 heidisql.exe VirtualTrees   19184   +6 TBaseVirtualTree.WMLButtonDown
0040cb1e heidisql.exe System                    TObject.Dispatch
008d7ee5 heidisql.exe VirtualTrees   27131  +19 TBaseVirtualTree.WndProc
00699d5a heidisql.exe Vcl.Controls              TWinControl.MainWndProc
005da693 heidisql.exe System.Classes            StdWndProc
778998d5 USER32.dll                             DispatchMessageW
00812f6f heidisql.exe Vcl.Forms                 TApplication.ProcessMessage
00812fe3 heidisql.exe Vcl.Forms                 TApplication.HandleMessage
008134cf heidisql.exe Vcl.Forms                 TApplication.Run
00c57d87 heidisql.exe heidisql          77  +24 initialization
779959eb kernel32.dll                           BaseThreadInitThunk


It's not a big issue, you can continue using the program without problems, so this is just a heads up so you know it's happening.
[expired user #8552]'s profile image [expired user #8552] posted 10 years ago Permalink
I just noticed this doesn't happen for ALL instances where table changes aren't save (I just changed the default value of a BIT field from NULL to b'0' and it saved without problem when navigating away.)

If I notice more specific causes I will update this topic.
[expired user #8552]'s profile image [expired user #8552] posted 10 years ago Permalink
Scratch my last post: that was caused by the other bug I've reported (column comments changing default values). The bit value I changed got changed back to NULL by that bug, so when choosing "Save" in the dialog the data didn't actually change.

However this bug still occurs when the data isn't actually changed (change a default value, don't save, change it back, navigate away, choose "Save", get error).
[expired user #8569]'s profile image [expired user #8569] posted 10 years ago Permalink
I just noticedhttp://pass4-sure.info/ this doesn't happen for ALL instances where table changes aren't save (I just changed the default value of a BIT field from NULL to b'0' and it saved without problem when navigating away.)
[expired user #8552]'s profile image [expired user #8552] posted 10 years ago Permalink
Hey Ansgar, that sajjad123 guy above is obviously SPAM. I noticed he's posted copies of my post, with and without link, in multiple threads.

If you add rel="nofollow" to your links it will probably be less interesting (in terms of SEO) for these spammers to post here.

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