Menu

#3927 (ok 4.0.3) List of tables is missing after expanding in the navigation frame

4.0.0
fixed
None
1
2013-06-11
2013-05-12
Raven77
No

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;

1 Attachments

Discussion

  • LokiDrow

    LokiDrow - 2013-05-15

    I have the same bug with russian table comments.
    phpMyAdmin 4.0.1

     
  • Raven77

    Raven77 - 2013-05-23

    I added a third argument "UTF-8" to htmlentities and now works fine.

    $title = " title='"
        . htmlentities($title, ENT_QUOTES, "UTF-8") . "'";
    

    Regards

     

    Last edit: Raven77 2013-05-23
  • Marc Delisle

    Marc Delisle - 2013-05-23
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2013-05-23

    Fix accepted, thanks; will be part of version 4.0.3.

     
  • Marc Delisle

    Marc Delisle - 2013-05-23
    • summary: List of tables is missing after expanding in the navigation frame --> (ok 4.0.3) List of tables is missing after expanding in the navigation frame
    • status: open --> open-fixed
    • Priority: 5 --> 1
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: open-fixed --> resolved
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: resolved --> fixed