HeidiSQL crashing on startup

[expired user #4458]'s profile image [expired user #4458] posted 14 years ago in General Permalink
Hello, yesturday heidisql started crashing on startup. At first it tries to connect to last made connection, which is not available and a window with error msg that that it couldn't make sql connection appears, which is normal. When I am pressing ok button on that error window, it starts to load heidi, but then another error window appears with a message "An error occured in the application." and along with my PC parameters and settings there is following exception message:
exception class   : EAccessViolation
exception message : Access violation at address 0075C500 in module 'heidisql.exe'. Read of address 000000B4.

What could cause this problem? Do i need to post full bug report?
[expired user #4458]'s profile image [expired user #4458] posted 14 years ago Permalink
Forgot to mention Heidi v.6.0.0.3603 on Win7
[expired user #4458]'s profile image [expired user #4458] posted 14 years ago Permalink
Ok, I got pass this problem. The adress of db was one local network 192.168.x.x, i think the problem was that at the moment i am connected to different router and also have ip address 192.168.x.x. and Heidi tried to make a connection to address which appeared to be valid, but there wasnt any db server. So i disabled my network adapter and started Heidi and this time application didn't crash.
ansgar's profile image ansgar posted 14 years ago Permalink
Next time you see such an exception you could be so nice and paste the callstack here. Thanks!
[expired user #4458]'s profile image [expired user #4458] posted 14 years ago Permalink
processors        : 2x Intel(R) Core(TM)2 Duo CPU T7250 @ 2.00GHz
physical memory   : 733/2038 MB (free/total)
free disk space   : (C:) 7,72 GB
display mode      : 1680x1050, 32 bit
process id        : $a30
allocated memory  : 45,50 MB
executable        : heidisql.exe
exec. date/time   : 2010-11-20 18:49
version           : 6.0.0.3603
compiled with     : Delphi 2010
madExcept version : 3.0k
callstack crc     : $1959c8a5, $6e514d84, $6e514d84
exception number  : 9
exception class   : EAccessViolation
exception message : Access violation at address 0075C500 in module 'heidisql.exe'. Read of address 000000B4.
main thread ($1444):
0075c500 heidisql.exe mysql_connection 1216 +1 TMySQLConnection.GetInformationSchemaObjects
006d4e43 heidisql.exe Main             7747 +8 TMainForm.ListDatabasesBeforePaint
0061c0a3 heidisql.exe VirtualTrees             TBaseVirtualTree.DoBeforePaint
0062a9d3 heidisql.exe VirtualTrees             TBaseVirtualTree.PaintTree
0053a86c heidisql.exe Controls                 TControl.Perform
00542101 heidisql.exe Controls                 TWinControl.CMInvalidate
00622c44 heidisql.exe VirtualTrees             TBaseVirtualTree.Paint
00544f4b heidisql.exe Controls                 TCustomControl.PaintWindow
0053f6c9 heidisql.exe Controls                 TWinControl.PaintHandler
0053fea8 heidisql.exe Controls                 TWinControl.WMPaint
00544ee5 heidisql.exe Controls                 TCustomControl.WMPaint
00619b3d heidisql.exe VirtualTrees             TBaseVirtualTree.WMPaint
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
00625518 heidisql.exe VirtualTrees             TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls                 TWinControl.MainWndProc
0049a5dc heidisql.exe Classes                  StdWndProc
7776642b ntdll.dll                             KiUserCallbackDispatcher
777665c6 ntdll.dll                             RtlRaiseStatus
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
0053a86c heidisql.exe Controls                 TControl.Perform
00542101 heidisql.exe Controls                 TWinControl.CMInvalidate
00622c44 heidisql.exe VirtualTrees             TBaseVirtualTree.Paint
00544f4b heidisql.exe Controls                 TCustomControl.PaintWindow
0053f6c9 heidisql.exe Controls                 TWinControl.PaintHandler
0053fea8 heidisql.exe Controls                 TWinControl.WMPaint
00544ee5 heidisql.exe Controls                 TCustomControl.WMPaint
00619b3d heidisql.exe VirtualTrees             TBaseVirtualTree.WMPaint
0053ac48 heidisql.exe Controls                 TControl.WndProc
00617b06 heidisql.exe VirtualTrees             TBaseVirtualTree.WMChangeState
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
00625518 heidisql.exe VirtualTrees             TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls                 TWinControl.MainWndProc
0049a5dc heidisql.exe Classes                  StdWndProc
7776642b ntdll.dll                             KiUserCallbackDispatcher
777665c6 ntdll.dll                             RtlRaiseStatus
77766452 ntdll.dll                             KiUserExceptionDispatcher
0061c0a3 heidisql.exe VirtualTrees             TBaseVirtualTree.DoBeforePaint
0062a9d3 heidisql.exe VirtualTrees             TBaseVirtualTree.PaintTree
0049a5dc heidisql.exe Classes                  StdWndProc
00622c44 heidisql.exe VirtualTrees             TBaseVirtualTree.Paint
00544f4b heidisql.exe Controls                 TCustomControl.PaintWindow
0053f6c9 heidisql.exe Controls                 TWinControl.PaintHandler
0053fea8 heidisql.exe Controls                 TWinControl.WMPaint
00544ee5 heidisql.exe Controls                 TCustomControl.WMPaint
00619b3d heidisql.exe VirtualTrees             TBaseVirtualTree.WMPaint
0053ac48 heidisql.exe Controls                 TControl.WndProc
00617b06 heidisql.exe VirtualTrees             TBaseVirtualTree.WMChangeState
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
00625518 heidisql.exe VirtualTrees             TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls                 TWinControl.MainWndProc
0049a5dc heidisql.exe Classes                  StdWndProc
7776642b ntdll.dll                             KiUserCallbackDispatcher
777665c6 ntdll.dll                             RtlRaiseStatus
77766452 ntdll.dll                             KiUserExceptionDispatcher
0061c0a3 heidisql.exe VirtualTrees             TBaseVirtualTree.DoBeforePaint
0062a9d3 heidisql.exe VirtualTrees             TBaseVirtualTree.PaintTree
0049a5dc heidisql.exe Classes                  StdWndProc
00622c44 heidisql.exe VirtualTrees             TBaseVirtualTree.Paint
00544f4b heidisql.exe Controls                 TCustomControl.PaintWindow
0053f6c9 heidisql.exe Controls                 TWinControl.PaintHandler
0053fea8 heidisql.exe Controls                 TWinControl.WMPaint
00544ee5 heidisql.exe Controls                 TCustomControl.WMPaint
00619b3d heidisql.exe VirtualTrees             TBaseVirtualTree.WMPaint
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
00625518 heidisql.exe VirtualTrees             TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls                 TWinControl.MainWndProc
0049a5dc heidisql.exe Classes                  StdWndProc
7776642b ntdll.dll                             KiUserCallbackDispatcher
777665c6 ntdll.dll                             RtlRaiseStatus
77766452 ntdll.dll                             KiUserExceptionDispatcher
0061c0a3 heidisql.exe VirtualTrees             TBaseVirtualTree.DoBeforePaint
0062a9d3 heidisql.exe VirtualTrees             TBaseVirtualTree.PaintTree
0049a5dc heidisql.exe Classes                  StdWndProc
00622c44 heidisql.exe VirtualTrees             TBaseVirtualTree.Paint
00544f4b heidisql.exe Controls                 TCustomControl.PaintWindow
0053f6c9 heidisql.exe Controls                 TWinControl.PaintHandler
0053fea8 heidisql.exe Controls                 TWinControl.WMPaint
00544ee5 heidisql.exe Controls                 TCustomControl.WMPaint
00619b3d heidisql.exe VirtualTrees             TBaseVirtualTree.WMPaint
0053ac48 heidisql.exe Controls                 TControl.WndProc
00617b06 heidisql.exe VirtualTrees             TBaseVirtualTree.WMChangeState
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
00625518 heidisql.exe VirtualTrees             TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls                 TWinControl.MainWndProc
0049a5dc heidisql.exe Classes                  StdWndProc
7776642b ntdll.dll                             KiUserCallbackDispatcher
777665c6 ntdll.dll                             RtlRaiseStatus
77766452 ntdll.dll                             KiUserExceptionDispatcher
0061c0a3 heidisql.exe VirtualTrees             TBaseVirtualTree.DoBeforePaint
0062a9d3 heidisql.exe VirtualTrees             TBaseVirtualTree.PaintTree
0049a5dc heidisql.exe Classes                  StdWndProc
00622c44 heidisql.exe VirtualTrees             TBaseVirtualTree.Paint
00544f4b heidisql.exe Controls                 TCustomControl.PaintWindow
0053f6c9 heidisql.exe Controls                 TWinControl.PaintHandler
0053fea8 heidisql.exe Controls                 TWinControl.WMPaint
00544ee5 heidisql.exe Controls                 TCustomControl.WMPaint
00619b3d heidisql.exe VirtualTrees             TBaseVirtualTree.WMPaint
0053ac48 heidisql.exe Controls                 TControl.WndProc
00617b06 heidisql.exe VirtualTrees             TBaseVirtualTree.WMChangeState
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053b56e heidisql.exe Controls                 TControl.WMMouseMove
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
00625518 heidisql.exe VirtualTrees             TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls                 TWinControl.MainWndProc
0049a5dc heidisql.exe Classes                  StdWndProc
7776642b ntdll.dll                             KiUserCallbackDispatcher
777665c6 ntdll.dll                             RtlRaiseStatus
77766452 ntdll.dll                             KiUserExceptionDispatcher
0061c0a3 heidisql.exe VirtualTrees             TBaseVirtualTree.DoBeforePaint
0062a9d3 heidisql.exe VirtualTrees             TBaseVirtualTree.PaintTree
00622c44 heidisql.exe VirtualTrees             TBaseVirtualTree.Paint
00544f4b heidisql.exe Controls                 TCustomControl.PaintWindow
0053f6c9 heidisql.exe Controls                 TWinControl.PaintHandler
0053fea8 heidisql.exe Controls                 TWinControl.WMPaint
00544ee5 heidisql.exe Controls                 TCustomControl.WMPaint
00619b3d heidisql.exe VirtualTrees             TBaseVirtualTree.WMPaint
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053b56e heidisql.exe Controls                 TControl.WMMouseMove
0053ac48 heidisql.exe Controls                 TControl.WndProc
0053f510 heidisql.exe Controls                 TWinControl.WndProc
00625518 heidisql.exe VirtualTrees             TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls                 TWinControl.MainWndProc
0049a5dc heidisql.exe Classes                  StdWndProc
7776642b ntdll.dll                             KiUserCallbackDispatcher
76951192 kernel32.dll                          BaseThreadInitThunk
[expired user #6187]'s profile image [expired user #6187] posted 13 years ago Permalink
I had the same problem. The program crashed because it was trying to restart a connection to a MySql database with incorrect user and password details (hence the AccessViolation message).

I solved the problem by forcing HeidiSQL to open another connection with correct user and password. You can do it like this:
Go to the shortcut of the HeidiSQL program and open its properties.
In the field "TARGET" it display the path to your HeidiSQL program (embraced in double quotes).
Type the below code after the last double quotes:
-h [ftp.hostname.com] -u [username] -p [password]
(of course you will have to replace the thing in between the brackets to your own details.
Save the shortcut by pressing OK and try to open HeidiSQL using the shortcut you just edited.

For me this helped, because it opened another connection and now I was able to edit the faulty connection's details to the correct username and password and I was again able to use my HeidiSQL.

Hope it will help you. Let me know if it did by posting below.

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