Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Foreign keys display issue

alexlkv's profile image alexlkv posted 5 months ago in General Permalink

existing foreign key does not display on the list. it having issue on this latest version 10.3.0.5858

2 attachment(s):
  • 2020-02-03_14h19_14
  • 2020-02-03_14h19_56
ansgar's profile image ansgar posted 5 months ago Permalink

Which server system?

alexlkv's profile image alexlkv posted 5 months ago Permalink

My server ( mysql server ) it display empty as long as the table created foreign key.

before that, i can see the foreign key

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 5 months ago Permalink

Ok, then what MySQL version is it? Please be more detailed. Probably you should also post the result of SHOW CREATE TABLE mytable so I can make a deeper analysis.

alexlkv's profile image alexlkv posted 5 months ago Permalink

image descriptionCREATE TABLE usergroups ( UserID varchar(6) NOT NULL, GroupID int(11) NOT NULL, PRIMARY KEY (UserID,GroupID), KEY UserID (UserID), KEY GroupID (GroupID), CONSTRAINT GroupID FOREIGN KEY (GroupID) REFERENCES modulegroups (GroupID), CONSTRAINT UserID FOREIGN KEY (UserID) REFERENCES userpassword (UserID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1

1 attachment(s):
  • 2020-02-12_16h37_58
alexlkv's profile image alexlkv posted 5 months ago Permalink

I use Mysql 5.0 only , stable version still able to see the foreign key after i update nightly build then problem already.

1 attachment(s):
  • 2020-02-12_16h41_01
tjannk's profile image tjannk posted 3 months ago Permalink

hi, i'm facing the same issue with mysql 4 & mysql 5... MySQL 8 nno issue for me.

i'm using the latest Heidi 11.0.0.5931 as of today.

Any workaround?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.