One on many relation in MySQL

In first table 'Profiel', i made a PK 'Profielnaam' VARCHAR(20)
Second table 'Laserfiles', a FK 'Profielnaam' VARCHAR(20)

I allways get next error when synchronise

file c:\dokumente und einstellungen\mike\eigene dateien\work\mysql-gui-common\library_grt\source\myx_grt_value.c: line 3295: assertion `dict != NULL' failed
file c:\dokumente und einstellungen\mike\eigene dateien\work\mysql-gui-common\library_grt\source\myx_grt_value.c: line 3295: assertion `dict != NULL' failed
Query was empty
No database selected

FK settings RESTRICTED (what does this mean ? and the other options?)

Hope someone helps me because i'm fed up with it, i tried everything..

thx
contec_devAsked:
Who is Participating?
 
psadacCommented:
MySQL Workbench is still in beta stage, there is something in the forum :

http://forums.mysql.com/read.php?113,77016,77016#msg-77016

but not sure it will solve your problem, howerver you could use the older product from the same developper (i think)

http://fabforce.net/dbdesigner4/
0
 
contec_devAuthor Commented:
Other FK settings
      Foreign Key name   = a_name
      Referred table = table_with_primary_key
      Column = a_column_name
      Referred Column = PK column name

0
 
contec_devAuthor Commented:
MySQL version 4.1.20
0
 
hans_vdCommented:
What is the `dict != NULL'  thing?  Is that part of a query?  
If that's the case, you should write 'dict is not null'
0
 
contec_devAuthor Commented:
it's not a part of the query, ... i think it's an internal fault in the c-code of MySQL Workbench
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.