Error after Updating Plesk Control Panel 9.5

[dschiffner]

After Updating Plesk Control Panel 9.5 when i try to log into Plesk i get following Errors

ERROR: PleskMainDBException

MySQL query failed: Table 'psa.lockout' doesn't exist

0: common_func.php3:206
db_query(string 'delete from lockout where (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(last_wrong)) > (30 * 60)')
1: cmd_loginup.php:82
createSession(string 'admin', string '********')
2: login_up.php3:22

Whats wrong ?

 

[IgorG]

It looks like upgrade was nor successfully completed and database was not correctly upgraded. Recovering broken upgrade is complex and not trivial task. I suggest you contact support team if you can't fix it by yourself.

 

[mariusd]

Had the same problem, solved

Hi,

I had the same error message, I could solve it by connecting to the psa database and then create the table:

mysql> CREATE TABLE `lockout` (
-> `login` varchar(20) character set utf8 NOT NULL default '',
-> `last_wrong` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
-> `attempts` int(11) NOT NULL default '1',
-> PRIMARY KEY (`login`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
-> ;

Maybe that helps you as well.

Best
Marius

 

[Mangoswiss]

I had a similar error after trying to update from Plesk 9 to 10

This worked for me but I make no promises...

You can check the state of your database like this...
$> mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa

You should have a directory full of psa database backups

cd /var/lib/psa/dumps/

In there they'll be something like...

mysql.preupgrade.9.2.2-10.10.1.20110311-005228.dump.gz

Gunzip it somewhere you can remember

$> gunzip mysql.preupgrade.9.2.2-10.10.1.20110311-005228.dump.gz

then take the unzipped file and restore your database like so...

$> mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < mysql.preupgrade.9.2.2-10.10.1.20110311-005223.dump


Check the database again and you should get a load of OKs
$> mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa

then go back to Plesk and all should be good!

 

[spid3r1987]

genius!!

I had the same error message, I could solve it by connecting to the psa database and then create the table:

mysql> CREATE TABLE `lockout` (
-> `login` varchar(20) character set utf8 NOT NULL default '',
-> `last_wrong` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
-> `attempts` int(11) NOT NULL default '1',
-> PRIMARY KEY (`login`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
-> ;

Maybe that helps you as well.

Best
Marius

worked thanks, saved my bacon!!

 

[SalvadorS]

Dear Mangoswiss, you solve my life. Thanks a lot

This worked for me but I make no promises...

You can check the state of your database like this...
$> mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa

You should have a directory full of psa database backups

cd /var/lib/psa/dumps/

In there they'll be something like...

mysql.preupgrade.9.2.2-10.10.1.20110311-005228.dump.gz

Gunzip it somewhere you can remember

$> gunzip mysql.preupgrade.9.2.2-10.10.1.20110311-005228.dump.gz

then take the unzipped file and restore your database like so...

$> mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < mysql.preupgrade.9.2.2-10.10.1.20110311-005223.dump


Check the database again and you should get a load of OKs
$> mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa

then go back to Plesk and all should be good!