Unable to create a KVM VPS in SolusVM: There seems to have been a slight problem with our database, please try again later.

Symptoms 

• Unable to create a KVM VPS in SolusVM. The following error is displayed after clicking the button Create Virtual Server at SolusVM > Virtual Servers > Add Virtual Server:

  CONFIG_TEXT: There seems to have been a slight problem with our database, please try again later.

Cause

When checking the browser Dev Tool(F12) > Network tab > Response tab there is the following error:

CONFIG_TEXT: Unknown column 'tablet_input' in 'field list'

This means the column 'tablet_input' is absent in SolusVM database table 'kvmdata'.

Resolution

1. Connect to Master node via SSH
2. Create SolusVM database backup
3. Access the database with the following query:

   # awk -F: '{ system("MYSQL_PWD='"'"'" $3 "'"'"' mysql -u " $2 " "$1)}' /usr/local/solusvm/includes/solusvm.conf

4. Add the missing column with the query:

   MYSQL_LIN: alter table kvmdata add column `tablet_input` int(1) NOT NULL DEFAULT '0';