Issue [Debian] Plesk\Exception\Database: DB query failed: SQLSTATE

[PluginDB]

Hello! Today i encounter a problem with Plesk Onyx on Debian 8.7

ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Mysql.php:53)

The follwing article in the kb is not helpful at all since its for plesk 12 and not for debian.

https://kb.plesk.com/en/122876

 

[Bitpalast]

In this order:

You could first try
# plesk repair db -y

Then, if that did not solve the issue,
# plesk repair installation

If that still did not solve the issue:
# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components

If that still did not solve the issue:
# /usr/local/psa/bootstrapper/pp17.0.17-bootstrapper/bootstrapper.sh repair

If that still did not solve the issue:
Open a support ticket with Plesk support. https://support.plesk.com/hc/en-us/requests/new

 

[PluginDB]

Currently reinstalling plesk onto another system and than migrating it... I'll let you know if that fixed the issue

But thanks for you reply!

 

[PluginDB]

Another problem occured...

After Installing plesk onto the other server it is not possible to migrate because it shows that the source server is empty..

 

[Bitpalast]

Different topic -> New thread please.

 

[PluginDB]

Update: Issue not solved, unable to create a ticket because i bought at a reseller... Tried to do Peter's steps.

 

[Bitpalast]

Support option for reseller license users: https://support.plesk.com/hc/en-us/articles/213953025

 

[PluginDB]

So... i do have to pay to get support? Thats not normal... i try to fix this issue myself but thanks for the help

 

[Bitpalast]

The reseller from where you bought the license should provide support. Unfortunately, many of them just don't.

 

[PluginDB]

The've provided support. They gave me a new server, they ran the reinstaller program but that didnt fixed it