Notice @ Relations View

[OlafvdSpek]

V: 5.0+snapshot

Notice in ./libraries/classes/Controllers/Table/RelationController.php#203
 Undefined index: foreign_keys_data

Backtrace

./tbl_relation.php#90: PhpMyAdmin\Controllers\Table\RelationController->indexAction()

[williamdes]

@OlafvdSpek can you please send the table structure so I can understand what I am fixing ?

[williamdes]

And if It could affect 4.9

[OlafvdSpek]

CREATE TABLE `pma__bookmark` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `dbase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `label` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
 `query` text COLLATE utf8_bin NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks'

[williamdes]

Thank you, reproduced !
I will use this issue to fix #15590 ;)

[williamdes]

Param	Value
Error Type	Notice
Error Message	Undefined index: foreign_keys_data
Exception Type	php
phpMyAdmin version	5.0.0-rc1
Incident count	1
Link	Report#61383

This comment is posted automatically by phpMyAdmin's error-reporting-server.

[williamdes]

Param	Value
Error Type	Notice
Error Message	Undefined index: foreign_keys_data
Exception Type	php
phpMyAdmin version	4.9.1
Incident count	2
Link	Report#60888

This comment is posted automatically by phpMyAdmin's error-reporting-server.

[williamdes]

This issue occurs on 4.9 when user has column level privileges and tries to see the relations.
Similar to #15228