Bug #51955 problem in work bench (relashionships)
Submitted: 11 Mar 2010 15:11 Modified: 28 Apr 2010 12:41
Reporter: Hackman brahim Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.2.16 OS:Windows
Assigned to: CPU Architecture:Any
Tags: probleme in relationships

[11 Mar 2010 15:11] Hackman brahim
Description:
Exception = System.Runtime.InteropServices.SEHException
Message = Un composant externe a levé une exception.
FullText = System.Runtime.InteropServices.SEHException: Un composant externe a levé une exception.
   à bec.FKConstraintColumnsListBE.get_column_is_fk(FKConstraintColumnsListBE* , NodeId* )
   à MySQL.Grt.Db.FKConstraintColumnsListBE.get_column_is_fk(NodeId node)
   à MySQL.GUI.Workbench.Plugins.DbMysqlTableFkColumnListModel.columnEnabledFkNodeControl_CheckStateChanged(Object sender, TreePathEventArgs e)
   à System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   à Aga.Controls.Tree.NodeControls.NodeCheckBox.OnCheckStateChanged(TreePathEventArgs args)
   à Aga.Controls.Tree.NodeControls.NodeCheckBox.OnCheckStateChanged(TreeNodeAdv node)
   à Aga.Controls.Tree.NodeControls.NodeCheckBox.SetCheckState(TreeNodeAdv node, CheckState value)
   à Aga.Controls.Tree.NodeControls.NodeCheckBox.MouseDown(TreeNodeAdvMouseEventArgs args)
   à Aga.Controls.Tree.TreeViewAdv.OnMouseDown(MouseEventArgs e)
   à System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   à System.Windows.Forms.Control.WndProc(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
i have a table called services and a table called contacts i want to contact an field from table service to the primary id of contact .
table contact contain standard information but perhaps can have some services example : thechnique service ,buy service with the contact info service .
[11 Mar 2010 15:14] Hackman brahim
i have more problem with this version (its better to call some incomplete applications "Beta" after the version of the product)
[11 Mar 2010 15:14] Hackman brahim
i don't know if i can return to an older version.
[11 Mar 2010 15:54] Hackman brahim
i found solution the problem is that the table services dons't have a primary key whene i add a primary key in services table all done well.
[26 Mar 2010 12:56] Valeriy Kravchuk
How exactly you tried to create foreign key, via Foreign keys tab or with 1:n tool? What data types your columns have?
[26 Mar 2010 13:02] Hackman brahim
the probleme exactely the data types is not match for exemple the primary key of the first table was int and the pk for the second table was int(11).
[28 Mar 2010 12:41] Valeriy Kravchuk
The fact that primary keys have different data types should not matter if you are NOT trying to define primary key in one table as a foreign key referencing primary key of the other table.

My question still remains: How exactly you tried to create foreign key, via Foreign keys tab or with 1:n tool?
[28 Apr 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".