In some cases, the expanded table is not shown in the list. The problem occurs when table definition have comment with a special character (in my case Polish).
example:
CREATE TABLE IF NOT EXISTS client_list
(
id
int(10) unsigned NOT NULL auto_increment COMMENT 'PK',
name
varchar(255) collate utf8_polish_ci NOT NULL COMMENT 'Nazwa listy',
PRIMARY KEY (id
),
KEY name
(name
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci COMMENT='Przykładowy tekst łńóść' AUTO_INCREMENT=1 ;
Except the missing list, app not display any other message, also not have any entry in the log.
When you click on the + symbol JSON returns: {"message": null, "success": true}
A temporary workaround is to set in confg file:
$cfg['ShowTooltip'] = false;
I have the same bug with russian table comments.
phpMyAdmin 4.0.1
See my comment here:
https://github.com/phpmyadmin/phpmyadmin/commit/42454654
I added a third argument "UTF-8" to htmlentities and now works fine.
Regards
Last edit: Raven77 2013-05-23
Fix accepted, thanks; will be part of version 4.0.3.