message : Access violation

Ash501 posted 7 years ago in General
Hi; Love this software! Thank you for a very powerful work horse! I'm new to MySQL and HeidiSQL has been making my life so much easier.

I haven't been able to keep lately HeidiSQL stable, and was wondering why.

I was trying to reset the counter on my ID column by deleting ID and Saving the DB, and creating the ID column anew that way the counter - auto increase - would give me the right number for the column. Any way I got an error one time saving it and the software hasn't been the same. After trying several times to open this database the software crashed everytime. Only after a day it opened the database (it allowed me to same my work!) but I get the following error:

Access violation at address 007EDBAF in module 'heidisql.exe'. Read of address 0000000C.

1.) Why the error & how do I make it stop?
2.) Is there an easier way to reset the counter of the ID column?

Thanks for your help
Ash501 posted 7 years ago
Actually I can no longer access any data on that DB....unhappy
Here is the dump:

date/time : 2012-03-21, 10:03:08, 594ms
computer name : *********
user name : *********
registered owner : ********* <admin>
operating system : Windows 7 Service Pack 1 build 7601
system language : English
system up time : 22 hours 9 minutes
program up time : 4 minutes 49 seconds
processors : 2x Celeron(R) Dual-Core CPU T3000 @ 1.80GHz
physical memory : 938/1916 MB (free/total)
free disk space : (C:) 91.20 GB
display mode : 1366x768, 32 bit
process id : $840
allocated memory : 64.18 MB
executable : heidisql.exe
exec. date/time : 2012-03-20 22:47
version :
compiled with : Delphi XE
madExcept version : 3.0m beta 1
callstack crc : $573d6b98, $196a5e52, $196a5e52
exception number : 8
exception class : EAccessViolation
exception message : Access violation at address 007EDBAF in module 'heidisql.exe'. Read of address 0000000C.

main thread ($9b4):
007edbaf heidisql.exe Main 10390 +31 TMainForm.treeQueryHelpersInitChildren
00627140 heidisql.exe VirtualTrees TBaseVirtualTree.DoInitChildren
0062aff4 heidisql.exe VirtualTrees TBaseVirtualTree.InitChildren
00631529 heidisql.exe VirtualTrees TBaseVirtualTree.GetFirstChild
007ee235 heidisql.exe Main 10515 +9 TMainForm.RefreshHelperNode
007e2ef5 heidisql.exe Main 7156 +81 TMainForm.DBtreeFocusChanged
0062680e heidisql.exe VirtualTrees TBaseVirtualTree.DoFocusChange
0062ac34 heidisql.exe VirtualTrees TBaseVirtualTree.HandleMouseDown
004e9370 heidisql.exe Controls TControl.DoMouseDown
00622bac heidisql.exe VirtualTrees TBaseVirtualTree.WMLButtonDown
0062eebf heidisql.exe VirtualTrees TBaseVirtualTree.WndProc
004ecc7c heidisql.exe Controls TWinControl.MainWndProc
004ab504 heidisql.exe Classes StdWndProc
77b2cc6b USER32.dll DispatchMessageW
00575bc7 heidisql.exe Forms TApplication.ProcessMessage
00575c0a heidisql.exe Forms TApplication.HandleMessage
00575f35 heidisql.exe Forms TApplication.Run
007fe8fb heidisql.exe heidisql 67 +16 initialization
7676ed6a kernel32.dll BaseThreadInitThunk
ansgar posted 7 years ago
That code place are where I was currently working on, sorry to cause errors left and right.

I'll try to work around that conversion error asap. In the meantime, you can fix that for yourself:
- exit all heidisql.exe instances
- start regedit.exe
- navigate to HKEY_CURRENT_USER\Software\HeidiSQL\Servers\
- in each session subfolder, watch for a sub key calles "QueryHistory". Delete these keys.
- start heididql.exe
ansgar posted 7 years ago
This is issue #2791, and I just fixed that in r4100.
Ash501 posted 7 years ago
Thank You! works fine now happyhappy

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