- Plesk Onyx for Linux
The following error occurs on attempt to access Wordpress Toolkit:
A table must have a primary key, but none was found for table 'Instances'
- The following error occurs on attempt to access Wordpress Toolkit:
CONFIG_TEXT: Server Error500
SQLSTATE[HY000]: General error: 1 no such column: serverId
The error like below is shown in Plesk log
CONFIG_TEXT: ERR [panel] A table must have a primary key, but none was found for table 'Instances':
Zend_Db_Table_Select->setTable(object of type PleskExt\WpToolkit\Db\Broker\Instances)
Output of the following commands shows that Wordpress Toolkit SQLITE3 database, used to store information about instances, does not contain any Wordpress-related tables:
# sqlite3 /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3
Wordpress Toolkit SQLITE3 database was not created correctly or has been corrupted.
It is required to reinstall WordPress Toolkit. It is possible to do that via Plesk Interface or via SSH.
- Log into Plesk;
- Go to Tools & Settings > Updates and Upgrades > Add/Remove Components;
- Select WordPress Toolkit under Plesk Extensions and select Remove:
- Use the same steps to install WordPress Toolkit back.
Log into the server via SSH.
Remove Wordpress Toolkit component:
# plesk installer remove --components wp-toolkit
Install Wordpress Toolkit component:
# plesk installer add --components wp-toolkit