forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › FK Management Gone
- This topic is empty.
-
AuthorPosts
-
-
July 30, 2004 at 2:20 pm #8516
terryriley
MemberHi,
Using SQLyog 3.71 on WinXP.
The ability to Manage Foreign Keys has suddenly disappeared, after I upgraded MySQL from 4.1.1-alpha to 4.1.3b-beta. The dialogue comes up, but FKs that I know (from using MySQL Maestro) are there, do not show. And newly-created ones still don't show when the dialogue is re-opened.
A friend of mine who (on my recommendation) purchased SQLyog just two days ago, has exactly the same problem (on WinNT4).
Neither of us can go back to 4.1.1, so it would be appreciated if this were investigated. Something within MySQL looks as though it has changed between the two versions – just requires SQLyog to catch up, I think.
-
July 30, 2004 at 3:10 pm #16132
Ritesh
MemberCan you cut-n-paste the output of the following SQL:
Code:show table status from `yourdb`for both the MySQL servers?
-
July 30, 2004 at 3:55 pm #16133Member
Ritesh – apologies for the formatting – it was easiest to take from the commandline:
mysql> show table status;
+
+
+
+
+
+
+
+
+
+
+
+
-+
+
+
+
+
+—
+| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_le
ngth | Max_data_length | Index_length | Data_free | Auto_increment | Create_time
| Update_time | Check_time | Collation | Checksum | Create_options | Co
mment
|
+
+
+
+
+
+
+
+
+
+
+
+
-+
+
+
+
+
+—
+| appearance | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 49152 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`PlayerID`) REFER `fm1999/player`(`ID`); (`FixtureID`) REF
ER `fm1999/fixture`(`ID`)
|
| committee | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 32768 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| constitution | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 98304 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`DivisionID`) REFER `fm1999/division`(`ID`); (`TeamID`) RE
FER `fm1999/team`(`ID`); (`OrdinalID`) REFER `fm1999/ordinal`(`ID`); (`ThisMatch
NoID`) REFER `fm1999/matchno`(`ID`); (`NextMatchNoID`) REFER `fm1999/matchno`(`I
D`) |
| division | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| fixture | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 163840 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`AsstRef2ID`) REFER `fm1999/referee`(`ID`); (`AwayID`) REF
ER `fm1999/fixture`(`AwayID`); (`RefereeID`) REFER `fm1999/referee`(`ID`); (`Hom
eID`) REFER `fm1999/constitution`(`ID`); (`KORoundID`) REFER `fm1999/koround`(`I
D`); (`AsstRef1ID`) REFER `fm1999/referee`(`ID`) |
| koround | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| matchno | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| matchreport | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`FixtureID`) REFER `fm1999/fixture`(`ID`)
|
| newsitem | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| ordinal | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| player | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| referee | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| register | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 49152 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`TeamID`) REFER `fm1999/team`(`ID`); (`PlayerID`) REFER `f
m1999/player`(`ID`)
|
| sponsor | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
| suspension | InnoDB | 9 | Fixed | 1 | 16384 | 1
6384 | NULL | 32768 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB; (`PlayerID`) REFER `fm1999/player`(`ID`)
|
| team | InnoDB | 9 | Dynamic | 1 | 16384 | 1
6384 | NULL | 16384 | 0 | 1 | NULL
| NULL | NULL | latin1_swedish_ci | NULL | | In
noDB free: 27648 kB
|
+
+
+
+
+
+
+
+
+
+
+
+
-+
+
+
+
+
+—
+16 rows in set (0.05 sec)
The data is exactly the same for the other NT server – databases are also identical.
None of them (including newly-added) show in the dialogue.
Terry
-
July 30, 2004 at 3:59 pm #16134Member
Hello,
I think this result returned from 4.1.3. Can you cut and paste the result returned from 4.1.1?
You can use SQLyog to get the same result and it is formatted also 😀
-
July 30, 2004 at 4:18 pm #16135Member
Yes, it is – and as stated earlier, neither of us can go BACK to 4.1.1 – we have both committed to 4.1.3b, and the MySQL on his machine is live!
If I remember correctly, the output was the same (or certainly very similar).
Terry
-
July 30, 2004 at 4:59 pm #16136Member
In fact, Ritesh, 4.1.1 does not seem to be available for download any longer from the MySQL site! It is now almost exclusively 4.1.3b-beta.
Terry
-
July 31, 2004 at 6:06 am #16137Member
Ok.
I think I have a binary of 4.1.1 in my development box. Will work on it over the weekend and let you know 😀
-
August 2, 2004 at 8:42 am #16138Member
I confirm the bug. There has been some changes with the information returned by 4.1.3.
This bug will be fixed in 3.8. If you would like to beta-test 3.8 then send me a mail. I would add you in our beta testers list 😀
-
-
AuthorPosts
- You must be logged in to reply to this topic.
