Symptoms
-
It is not possible to install WordPress via WP Toolkit with the error:
Specified column "guid" is not in the row
-
The same error can be found in the file
/var/log/plesk/panel.log:ERR [panel] Zend_Db_Table_Row_Exception: Specified column "guid" is not in the row
-
When updating or reinstalling an existing WordPress instance with WP Toolkit, a similar error to the following is written to
/var/log/plesk/panel.log:DEBUG [extension/wp-toolkit] Exception: Database migration has failed. Log of phinx:
Phinx by CakePHP - https://phinx.org. 0.11.1using config file ./usr/local/psa/admin/plib/modules/wp-toolkit/library/Db/phinx.php
using config parser PHP
using migration paths
- /usr/local/psa/admin/plib/modules/wp-toolkit/library/Db/Migrations
warning no environment specified, defaulting to: production
using adapter sqlite
using database /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3== 20190517060827 ChangeColumnsDefinitionToCorrect: migrating
PDOException: SQLSTATE[HY000]: General error: 11 database disk image is malformed in /usr/local/psa/admin/plib/modules/wp-toolkit/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:168
Cause
Corrupted WP Toolkit SQLite database.
Resolution
Add missing column to WP Toolkit database:
For Plesk Linux
-
Connect to the server via SSH
-
Create a backup of the SQLite3 database:
# cp /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3 /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3.bak
-
Access the SQLite3 database:
# sqlite3 /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3
-
Update the table
Instances# sqlite> ALTER TABLE Instances ADD COLUMN
guidVARCHAR(36) NULL; -
Disconnect from the SQLite database:
# sqlite> .q
For Plesk Windows
-
Connect to the server via RDP
-
Create a backup of the original database at
%plesk_dir%varmoduleswp-toolkitwp-toolkit.sqlite3 -
Open a command-line window and access the database using the SQLite3 utility with the following command:
C:> "%plesk_bin%sqlite3" "%plesk_dir%varmoduleswp-toolkitwp-toolkit.sqlite3"
-
Update the table
Instances:C:> sqlite> ALTER TABLE Instances ADD COLUMN `guid` VARCHAR(36) NULL;
-
Disconnect from the SQLite database:
C:> sqlite> .q
Note: In case the resolution above does not fix the issue remove the extension WP Toolkit and install it again.
with