1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Resolved ERROR 1102 (42000) at line 20: Incorrect database name ''

Discussion in 'Plesk 12.x for Linux' started by LarsenD, Nov 20, 2014.

  1. LarsenD

    LarsenD Regular Pleskian

    22
    23%
    Joined:
    Apr 12, 2011
    Messages:
    131
    Likes Received:
    1
    This is just a bug report. No help needed as it doesn´t seem to cause problems.

    When I update servers via CLI autoinstaller, I sometimes (or on some servers) get this error message:
    Code:
    Trying to start psa...
    Stopping psa... Stopping Plesk engine pool manager: sw-engine-fpm.
    done
    ===> Installing phpMyAdmin
    Trying to create pmadb... ERROR 1102 (42000) at line 20: Incorrect database name ''
    
    Afaik, no server has this DB.
     
  2. UFHH01

    UFHH01 Plesk addicted! Plesk Guru

    44
    64%
    Joined:
    Jun 11, 2013
    Messages:
    6,061
    Articles:
    1
    Likes Received:
    1,392
    Location:
    Hamburg / Germany
    Not all "ERROR" in your log - file might cause issues/problems... it might as well only point to some misconfigurations, or missing features from a complete basic Plesk installation.
     
  3. LarsenD

    LarsenD Regular Pleskian

    22
    23%
    Joined:
    Apr 12, 2011
    Messages:
    131
    Likes Received:
    1
  4. LarsenD

    LarsenD Regular Pleskian

    22
    23%
    Joined:
    Apr 12, 2011
    Messages:
    131
    Likes Received:
    1
    Found the reason and fix myself.

    Plesk uses the old phpMyAdmin config from "/opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php". Probably due to a bug in an old version of Plesk, this did not contain the database name, but this:
    Code:
    $cfg['Servers'][$i]['pmadb'] = $GLOBALS['db_host'] != 'localhost' ? '' : '';
    When it should contain something like this:
    Code:
    $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin__lL4vGxF8vvH';
    Check this by executing:
    Code:
    grep pmadb /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php
    Solution:
    - Delete all phpMyAdmin databases
    - rm -f /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php
    - Upgrade Plesk
     
Loading...