Symptoms
Plesk UI 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 domains
table of the psa
database.
Resolution
1. Connect to the server via SSH.
2. Execute the command below to re-create the correct table structure:
# plesk repair db