Table 'psa.sessions' doesn't exist hatası çözümü

Plesk panelde aşağıdaki hatayı alıyorsanız sebebi tabloların bozulmuş olması.

SSH ile bağlantı yaptıktan sonra aşağıdaki komutlar ile en son geçerli yedekten tablolar tekrar yüklenebilir.

 

ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist
ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessioncontexts' doesn't exist
ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.servicenodes' doesn't exist
  Çözüm
cd /var/lib/psa/dumps
 
ls -l mysql.daily*
-rw------- 1 root root 236253 Feb 3 01:51 mysql.daily.dump.0.gz
-rw------- 1 root root 229653 Feb 2 01:48 mysql.daily.dump.1.gz
-rw------- 1 root root 222485 Feb 1 01:56 mysql.daily.dump.2.gz
 
zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin --default-character-set=utf8
  • 0 Users Found This Useful
Was this answer helpful?