• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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

LarsenD

Regular Pleskian
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.
 
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.
 
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
 
Back
Top