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

[LarsenD]

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:

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.

 

[UFHH01]

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.

 

[LarsenD]

@parallels: will this be fixed?

 

[LarsenD]

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:

$cfg['Servers'][$i]['pmadb'] = $GLOBALS['db_host'] != 'localhost' ? '' : '';

When it should contain something like this:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin__lL4vGxF8vvH';

Check this by executing:

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