Author:jean.spr...@gmail.com Date:2010-01-13 08:47:07

I continue reading your documentations. Just in case it could help:

• the Mysql is hosted on a WIN server, and all table names are in lowercase, with
  just underscore as "special" chars.
  I tried to create a TEST db, with just a "a" and "b" table, with juste ID in each and
  it's always the case: the "table" drop down in Relation/REFERENCES doenst react.
  Hope it help
  j

Author:bibiko@gmail.com Date:2010-01-13 10:28:27

Hi Jean,

did you try the + button (⌥⌘A)? And the selected table should be a innoDB.

Regards,
--Hans

Author:jean.spr...@gmail.com Date:2010-01-13 11:07:24

Hi bibiko
Thks a lot for your fast answer. REALLY pro !

Unfortunatly, maybe I do not well explain:

1. I select the table (whitch is innoDB, UTF8, called "alerts". In my DB, I do have
   37 other tables, all with normal chars, all in innoDB - UTF8)
2. I do click on "Relations" icon in the top menu
3. I get an "empty" table (with Name, Columns, FK Table, FK Columns, On Update, On
   delete)
4. I click the "+" at the bottom (same action as ⌥⌘A)
5. I get a POPUP window, with 3 areas: "Table: alerts", "References", "Action")
6. I click, in the first "Table: alerts", on the drop down menu "Column" and it list
   me, in the dorp down, all my column of table "alert"
7. ... till here, everything is perfect and normal :)
8. In the second area (References), I have 2 drop-down (TABLE and COLUMN). When I
   click on the second one (Table), it doenst show me anything, nothing happend, no
   "bug" sound from the mac, no white empty field, nothing... like if I dont click on it
   :)... I tried to click everywhere on this drop-down but nothing... I try to use the
   TAB button to go to this field but no: he doenst react
9. the related "COLUMN" (just under) drop-down is grey (this look normal till I dont
   select a table... but I cannot)...
10. the ACTION works perfectly (they list me "restrict, cascade, set null, ...".
11. The MAIN "ADD" button (of the popup) is also grey, because (i suppose) i dont
    select a table.

I hope this help...
In attach I put a video to show you ;)

Author:rowanb@gmail.com Date:2010-01-13 11:50:23

Hi jean,

bibiko has spotted the cause and asked me to update this issue - the problem is that you're connecting to
MySQL 4.1, and we're building that particular table dropdown in a way that's only compatible with MySQL 5+!

We'll get this fixed - thanks for your amazing bug report (and especially the video), all the detail is very, very
appreciated!

Author:jean.spr...@gmail.com Date:2010-01-13 11:57:10

Thks a lot.
Happy to participate in this open projet to make it going to the perfection :-)
Your soft help me everydays!
J

Author:classout...@googlemail.com Date:2010-02-04 05:19:13

There are also bugs if you try to remove an existing relation.

Author:chris.be...@gmail.com Date:2010-10-05 19:33:59

I'm seeing the same problem (non-responsive "Table" drop-down), but connected to a brand new install of MySQL 5.1.51 on OS X.

Author:abhibeck...@gmail.com Date:2012-03-23 19:04:13

Not sure exactly what the status is of this old issue, it looks like we should try to fix it soon.

Can someone please confirm that this bug still exists?

Author:schlabbe...@gmail.com Date:2012-03-24 12:09:42

Still an issue with MySQL 4 - The Table dropdown will stay empty.

Author:stuart02 Date:2012-03-24 12:34:58

It's because we're using information_schema.tables to get the list of InnoDB tables. information_schema doesn't exist in MySQL 3 or 4 so this will never work.

Maybe we should disable the ability altogether unless the database we're connected to is at least version 5.

We can just use SHOW TABLE STATUS back to 3.23.0. InnoDB was added in 3.23.49