#1146 - Table 'phpmyadmin.pma__table_uiprefs' doesn't exist

Discussion in 'Installation/Configuration' started by M.Meintjes, Jul 15, 2018.

  1. M.Meintjes

    M.Meintjes New Member

    Hi there I recently updated the server with
    Code:
    apt-get update and apt-get upgrade
    and one of the updates was phpmyadmin.

    The apt history log shows the following:
    Code:
    phpmyadmin:amd64 (4.2.12-2+deb8u2, 4.2.12-2+deb8u3)
    Now my problem is, every time I try to edit a one of the database in phpmyadmin I get the following error:
    Code:
    SELECT `prefs` FROM `phpmyadmin`.`pma__table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'db-name' AND `table_name` = 'table-name'
    
    #1146 - Table 'phpmyadmin.pma__table_uiprefs' doesn't exist

    The following is shown on the main page when loged in as "root":
    Code:
    $cfg['Servers'][$i]['pmadb'] ...    OK
    $cfg['Servers'][$i]['relation'] ...    not OK [ Documentation ]
    General relation features: Disabled
    
    $cfg['Servers'][$i]['table_info'] ...    not OK [ Documentation ]
    Display Features: Disabled
    
    $cfg['Servers'][$i]['table_coords'] ...    not OK [ Documentation ]
    $cfg['Servers'][$i]['pdf_pages'] ...    not OK [ Documentation ]
    Creation of PDFs: Disabled
    
    $cfg['Servers'][$i]['column_info'] ...    not OK [ Documentation ]
    Displaying Column Comments: Disabled
    Browser transformation: Disabled
    
    $cfg['Servers'][$i]['bookmarktable'] ...    not OK [ Documentation ]
    Bookmarked SQL query: Disabled
    
    $cfg['Servers'][$i]['history'] ...    not OK [ Documentation ]
    SQL history: Disabled
    
    $cfg['Servers'][$i]['designer_coords'] ...    not OK [ Documentation ]
    Designer: Disabled
    
    $cfg['Servers'][$i]['recent'] ...    not OK [ Documentation ]
    Persistent recently used tables: Disabled
    
    $cfg['Servers'][$i]['table_uiprefs'] ...    not OK [ Documentation ]
    Persistent tables' UI preferences: Disabled
    
    $cfg['Servers'][$i]['tracking'] ...    not OK [ Documentation ]
    Tracking: Disabled
    
    $cfg['Servers'][$i]['userconfig'] ...    not OK [ Documentation ]
    User preferences: Disabled
    
    $cfg['Servers'][$i]['users'] ...    not OK [ Documentation ]
    $cfg['Servers'][$i]['usergroups'] ...    not OK [ Documentation ]
    Configurable menus: Disabled
    
    $cfg['Servers'][$i]['navigationhiding'] ...    not OK [ Documentation ]
    Hide/show navigation items: Disabled
    
    $cfg['Servers'][$i]['savedsearches'] ...    not OK [ Documentation ]
    Saving Query-By-Example searches: Disabled
    
    Quick steps to setup advanced features:
    
    Create the needed tables with the examples/create_tables.sql. Documentation
    Create a pma user and give access to these tables. Documentation
    Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php. Documentation
    Re-login to phpMyAdmin to load the updated configuration file.
    In this thread the guy fixed it by issueing the following command:
    Code:
    dpkg-reconfigure -plow phpmyadmin
    Will this work in my situation? I'm only asking because the thread is a couple of years old and we currently host a couple of site on that server so breaking the databases is kind of not the goal here :D
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This should work.
     
  3. M.Meintjes

    M.Meintjes New Member

    Thanks Till, it did indeed work.
     

Share This Page