• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Server Error: 500 Zend_Db_Statement_Exception

jjonsson

New Pleskian
Server operating system version
Debian 10
Plesk version and microupdate number
Obsidian 18.0.50
If I try to enter Wordpress in the menu I get the following error:
1675757770195.png

If I check Wordpress database, it's corrupt. How do I recover it ?


Code:
root@plesk:/usr/local/psa/var/modules/wp-toolkit# sqlite3 /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> pragma integrity_check;
Error: database disk image is malformed
sqlite>

I don't have a backup :oops:
 
Without a backup this will be a problem. I am not aware of a way to restore the SQLite DB. In my documentation here it is suggested to remove the module affected (which would be WP Toolkit) from the server and reinstall it. This however will mean that the WP Toolkit configuration data will be lost. Before doing this I also recommend to create a full server backup, because a corrupt file is mostly seen on a corrupt file system. It can mean that there are general underlying issues with the file system.
 
# ll /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3
Does it still exist? Could you try to rename it if still exists?
 
Back
Top