Crash when selecting a trigger

blauhut posted 5 years ago in General
date/time         : 2011-03-30, 08:27:03, 200ms
computer name     : 
user name         : 
registered owner  : 
operating system  : Windows XP Service Pack 3 build 2600
system language   : German
system up time    : 18 minutes 6 seconds
program up time   : 3 seconds
processors        : 2x Pentium(R) Dual-Core CPU E5300 @ 2.60GHz
physical memory   : 1370/2012 MB (free/total)
free disk space   : (C:) 4,48 GB
display mode      : 1440x900, 32 bit
process id        : $bd0
allocated memory  : 13,03 MB
executable        : heidisql.exe
exec. date/time   : 2011-03-28 16:35
version           :
compiled with     : Delphi XE
madExcept version : 3.0m beta 1
callstack crc     : $615cba8d, $96a0db0a, $96a0db0a
exception number  : 1
exception class   : EDatabaseError
exception message : Column "Definer" not available.
main thread ($238):
006e7134 heidisql.exe dbconnection   2669  +5 TDBQuery.Col
00691951 heidisql.exe trigger_editor  108 +24 TfrmTriggerEditor.Init
00783880 heidisql.exe Main           8569 +16 TMainForm.PlaceObjectEditor
0077dd57 heidisql.exe Main           6849 +49 TMainForm.DBtreeFocusChanged
00626e5a heidisql.exe VirtualTrees            TBaseVirtualTree.DoFocusChange
0062b2a6 heidisql.exe VirtualTrees            TBaseVirtualTree.HandleMouseDown
004d8894 heidisql.exe Controls                TControl.DoMouseDown
00623570 heidisql.exe VirtualTrees            TBaseVirtualTree.WMLButtonDown
0062f4d3 heidisql.exe VirtualTrees            TBaseVirtualTree.WndProc
004dc1a0 heidisql.exe Controls                TWinControl.MainWndProc
004a5720 heidisql.exe Classes                 StdWndProc
7e368a0b USER32.dll                           DispatchMessageW
005763c3 heidisql.exe Forms                   TApplication.ProcessMessage
00576406 heidisql.exe Forms                   TApplication.HandleMessage
00576731 heidisql.exe Forms                   TApplication.Run
0079774a heidisql.exe heidisql         65 +15 initialization

I can create a new trigger, but I cannot edit it. MySql 5.0
ansgar posted 5 years ago
Column "Definer" not available
is the one to fix. I have MySQL 5.0.77 running but I have a "Definer" colum when firing
. Could you test that on your server and tell me the exact MySQL version? Thanks!
blauhut posted 5 years ago
I have MySQL 5.0.15. Columns as follows
no "Definer" column
blauhut posted 5 years ago
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html"The DEFINER clause determines the security context to be used when checking access privileges at trigger activation time. It was added in MySQL 5.0.17." So I'm going to update my server.
ansgar posted 5 years ago
Hehe, very nice - thanks a lot for considering a server update just to keep compatibility to Heidi happy I'll of course change that in Heidi so that the definer will be empty on older servers.

blauhut posted 5 years ago
Well, after updating my server to 5.0.91 Heidi worked as expected but my Delphi 6 IDE crashed when closing (even with a non-DB project)???. Made a system restore, Delphi is fine again but I have to wait for the Heidi update...unhappy
ansgar posted 5 years ago
I'm confused - what are you doing with Delphi 6, and what is a non-DB project?
blauhut posted 5 years ago
I'm using Delphi 6 to develop MySQL-Applications and use Heidi to administer the databases(=DB). After updating the MySQL-Server, my Delphi IDE did no longer work as usual. I suspected there were some issues maybe with the new libmysql.dll or the new MySQL-Service, but Delphi even crashed with projects that did not have anything to do with databases (non-DB projects).
Confusion eliminated?wink
ansgar posted 5 years ago
Yes, makes sense. Reminds me of some horrible hours where I had no clue why Delphi was throwing errors left and right after changing or adding some component stuff. I'd also guess it's the changed libmysql.dll which may be accessed as soon as you load Delphi + some component with published properties which then suddenly load the libmysql.
ansgar posted 5 years ago
Fixed in r3797

blauhut posted 5 years ago
Thanks, works like expected now.

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