Symptoms
Plesk interface is not accessible with the following error:
500 PleskExceptionDatabase
DB query failed: SQLSTATE[42S22] Column not found: 1054 Unknown column 'd.monthlyTraffic' in 'field list'
Cause
The column monthlyTraffic
is absent in the table domains
of the Plesk configuration database psa
.
Resolution
1. Connect to the server via SSH.
2. Execute the command below to re-create the correct table structure of the Plesk configuration database:
# plesk repair db