Crash when selecting a trigger

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           : 6.0.0.3734
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

Column "Definer" not available

is the one to fix. I have MySQL 5.0.77 running but I have a "Definer" colum when firing

SHOW TRIGGERS

. Could you test that on your server and tell me the exact MySQL version? Thanks!

I have MySQL 5.0.15. Columns as follows

Trigger
Event
Table
Statement
Timing
Created
sql_mode

no "Definer" column

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.

Hehe, very nice - thanks a lot for considering a server update just to keep compatibility to Heidi I'll of course change that in Heidi so that the definer will be empty on older servers.

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...

I'm confused - what are you doing with Delphi 6, and what is a non-DB project?

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?

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.

Fixed in r3797

Thanks, works like expected now.