distal-attribute
distal-attribute
distal-attribute
distal-attribute

Crash when selecting a trigger

User, date Message
Written by blauhut
4 years ago
Category: General
9 posts since Tue, 29 Mar 11

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
Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06

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!
Written by blauhut
4 years ago
9 posts since Tue, 29 Mar 11
I have MySQL 5.0.15. Columns as follows

Trigger
Event
Table
Statement
Timing
Created
sql_mode

no "Definer" column
Written by blauhut
4 years ago
9 posts since Tue, 29 Mar 11
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.
Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06
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.
Written by blauhut
4 years ago
9 posts since Tue, 29 Mar 11
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
Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06
I'm confused - what are you doing with Delphi 6, and what is a non-DB project?
Written by blauhut
4 years ago
9 posts since Tue, 29 Mar 11
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
Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06
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.
Written by ansgar
3 years ago
5045 posts since Fri, 07 Apr 06
Fixed in r3797
Written by blauhut
3 years ago
9 posts since Tue, 29 Mar 11
Thanks, works like expected now.
 

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