How to move a domain between subscriptions in Plesk
Which ports should be opened in the firewall on a Plesk server?
Error during Plesk upgrade procedure: rsync: [Receiver] failed to connect to rsync.autoinstall.plesk.com
Error on Plesk for Windows server: Module "IsapiCachesModule" could not be found
How to troubleshoot the website availability via Website Log Check in Plesk?
On a Plesk server, information from plesk bin service_plan --info differs from plesk bin service_plan --xml-info
Error when deleting a domain on a Plesk server: Result of interface implementation call: failure: Can not find domain by id
Error when trying to log in to Plesk UI: Base table or view not found: 1146 Table 'psa.smarthosts' doesn't exist
Warning when applying Performance Booster on a website on a Plesk server: Custom PHP directives are specified in this domain's PHP settings.
Error on Login: "TypeError: Cannot read properties of undefined (reading 'toLowerCase')"

See more

Unable to access Plesk Interface: 500 Plesk\Exception\Database Unknown column 'd.monthlyTraffic' in 'field list'

Taras Ermoshin

Updated November 04, 2024 18:22

Plesk for Windows Plesk for Linux

Applicable to:

Plesk for Linux
Plesk for Windows

Symptoms

Plesk interface is not accessible with the following error:

CONFIG_TEXT: 500 Plesk\Exception\Database
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

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request