| Issue 530: | Table relations can't be added on MySQL < 5 | |
| 1 person starred this issue and may be notified of changes. | Back to list |
Sign in to add a comment
|
What steps will reproduce the problem? 1.select a table 2.click the "relations" icon 3.select the column 4.try to select a Table as REFERENCE ... and nothing happend . What is the expected output? What do you see instead? A list of the existing tables, and after a list of related fields in this table. I see nothing :-) -> the button doenst react . What version of the product are you using? On what operating system? 0.9.7, latest one Mac OSX 10.5.8 . Please provide any additional information below. When I open a database with relations already builded in another tool (like SQLyog on PC), I see the relations but cannot edit them. Can only DELETE. When I add a relation, as I connot select a related table and field, the ADD button is always disabled |
||||||||||||||
,
Jan 13, 2010
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 |
|||||||||||||||
,
Jan 13, 2010
Hi Jean, did you try the + button (⌥⌘A)? And the selected table should be a innoDB. Regards, --Hans |
|||||||||||||||
,
Jan 13, 2010
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 ;)
|
|||||||||||||||
,
Jan 13, 2010
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!
Summary: Table relations can't be added on MySQL < 5
Status: Accepted Labels: Type-Defect Priority-High Milestone-Release0.9 Component-Logic Usability |
|||||||||||||||
,
Jan 13, 2010
Thks a lot. Happy to participate in this open projet to make it going to the perfection :-) Your soft help me everydays! J |
|||||||||||||||
,
Feb 04, 2010
There are also bugs if you try to remove an existing relation. |
|||||||||||||||
| ► Sign in to add a comment | |||||||||||||||
