phpmyadmin feature problem

Discussion in 'Server Operation' started by concept21, Oct 5, 2017.

  1. concept21

    concept21 Member

    I log into my phpmyadmin control panel the first time and it shows this alert. How do I correct it?
    My system is ISPConfig 3.1.7, OS Ubuntu 16.04.3 :rolleyes:
     

    Attached Files:

  2. HSorgYves

    HSorgYves Active Member

    Did you click on "Find out why?"
     
  3. concept21

    concept21 Member

    :rolleyes:
     
  4. ztk.me

    ztk.me ISPConfig Developer ISPConfig Developer

    so did you do a system update recently and by chance got a new phpmyadmin version which did not populate all sql tables?
    maybe something has been fixed meanwhile and phpmyadmin wasn't able to access it's configuration before and you had this all the time?

    useful hints to look at are:
    phpmyadmin pma sql setup

    it's easy to fix - unfortunally I don't know ubuntu, even it should be similar to debian ;

    On debian you could just run
    /usr/share/phpmyadmin/sql/create_tables.sql
    into the phpmyadmin database.

    and adjust the /etc/phpmyadmin/config.inc.php
    Code:
        $cfg['Servers'][$i]['pmadb'] = $dbname;
        $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
        $cfg['Servers'][$i]['relation'] = 'pma__relation';
        $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
        $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
        $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
        $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
        $cfg['Servers'][$i]['history'] = 'pma__history';
        $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
        $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
        $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
        $cfg['Servers'][$i]['recent'] = 'pma__recent';
        $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
        $cfg['Servers'][$i]['users'] = 'pma__users';
        $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
        $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
        $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
        $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
        $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
        $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
    
    oh btw I think I'm missing one there, it's not a complete setup yet where I'm copying from - sry
    but I think you may need to do some checkings for yourself anyway - or wait for someone who speaks ubuntu :)
     
    concept21 likes this.
  5. concept21

    concept21 Member

    Yes, it is the correct solution for a common phpmyadmin frontend config storage. :)
     
  6. ztk.me

    ztk.me ISPConfig Developer ISPConfig Developer

    Code:
    $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
    
    is missing in my first post

    Code:
        $cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
    
        $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
        $cfg['Servers'][$i]['relation'] = 'pma__relation';
        $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
        $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
        $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
        $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
        $cfg['Servers'][$i]['history'] = 'pma__history';
        $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
        $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
        $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
        $cfg['Servers'][$i]['recent'] = 'pma__recent';
        $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
        $cfg['Servers'][$i]['users'] = 'pma__users';
        $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
        $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
        $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
        $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
        $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
        $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
    
    should be the complete stuff
     

Share This Page