• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

MYSQL Query failed psa.skins doesn't exist

Wikibear

Regular Pleskian
I get this error in title:

ERROR: PleskMainDBException
MySQL query failed: Table 'psa.skins' doesn't exist

0: common_func.php3:220
db_query(string 'select `id`,`name`,`place` from Skins where `id`=1')
1: Table.php:154
Table->select()
2: Skin.php:130
Skin->__construct(integer '1')
3: cu.php:523
cu->setSession()
4: cu.php:215
cu->cu()
5: upgrade-complete:18
ERROR: PleskMainDBException
MySQL query failed: Table 'psa.skins' doesn't exist

0: common_func.php3:220
db_query(string 'select `id`,`name`,`place` from Skins where `id`=1')
1: Table.php:154
Table->select()
2: Skin.php:130
Skin->__construct(integer '1')
3: cu.php:523
cu->setSession()
4: cu.php:215
cu->cu()
5: fix_apsc_password:24

What can i do now?
 
After what actions you have this error?
Did you try bootstrapper repair if it is after Plesk upgrade?
 
via autoinstaller via console.

ERROR: PleskMainDBException
MySQL query failed: Table 'psa.skins' doesn't exist

0: common_func.php3:220
db_query(string 'select `id`,`name`,`place` from Skins where `id`=1')
1: Table.php:154
Table->select()
2: Skin.php:130
Skin->__construct(integer '1')
3: common_func.php3:3316
objectMaker(string 'Skin', integer '1', boolean false, NULL null)
4: common_func.php3:3325
objectMakerEx(string 'Skin', integer '1')
5: Skin.php:602
Skin::initSkin()
6: auth.php3:501

And this via Webbrowser

Machine is openSUSE 11.4
 
**** Product repair failed.

***** problem report *****
ERROR while trying to execute SQL query, the query was: REPLACE INTO Repository SET rep_id='1', component_id='3'
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again
STOP Bootstrapper 11.0.9 repair AT Thu Jul 19 11:31:37 CEST 2012

This is output of strapper
 
Looks like psa database is corrupted. I suggest you contact Support Team.
 
Solved but a littlebit mystery....

I restart server. Same error.
I try to connect to mysql with no luck.
Reset mysql password
tell it plesk
restart daemon of plesk
now it works fine... But why? Only password change? I can't believe it...
 
Back
Top