phpMyAdmin errors after > upgrade

Discussion in 'Installation/Configuration' started by drewb0y, Apr 27, 2014.

  1. drewb0y

    drewb0y Member

    I upgraded from to and now am getting phpMyAdmin errors when trying to import an sql file into a database.

    I performed this operation successfully yesterday prior to the upgrade.
    Today on a different blank database, when I go to import it it looks like it was successful, but there is a little yellow triangle icon with an exclamation point and a message: (also none of the info was actually imported and db is still blank)

    The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
    And when I click for more info:
    $cfg['Servers'][$i]['pmadb'] ...	not OK [ Documentation ]
    $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]['tracking'] ...	not OK [ Documentation ]
    Tracking: Disabled
    $cfg['Servers'][$i]['userconfig'] ...	not OK [ Documentation ]
    User preferences: Disabled
    Quick steps to setup advanced features:
    Create the needed tables with the script/create_tables.sql. Documentation
    Create a pma user and give access to these tables. Documentation
    Enable advanced features in configuration file (, for example by starting from Documentation
    Re-login to phpMyAdmin to load the updated configuration file.
    Just wondering if anyone else has seen this. Thanks in advance for any suggestions.
    Last edited: Apr 27, 2014
  2. drewb0y

    drewb0y Member

    In the meantime I will do this via command line just wanted to get it fixed for future customer use.
  3. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    The above phpmyadmin message is completely normal when you don't have configured phpmyadmin for using an extended storage (its own database).
    I never configure those extended functions and pma is working as it should.

    What error messages do you get when you try to import? Maybe it is just related to memory limit, upload limit or something like that.
  4. drewb0y

    drewb0y Member

    Got it all resolved now. Somehow the phpmyadmin database either did not get created or did not get the info put in its tables when originally installed.

    I fixed this by just reconfiguring it using

    dpkg-reconfigure -plow phpmyadmin

Share This Page