Cannot install Plesk: ERROR 1146 (42S02) at line 1: Table 'psa.misc' doesn't exist

Symptoms

Plesk cannot be installed, the following error appears:

PLESK_INFO: ERROR 1146 (42S02) at line 1: Table 'psa.misc' doesn't exist

Plesk autoinstaller cannot create psa database. Also, it is not possible to create database manually:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa < /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/db/psa_db.sql
ERROR 1364 (HY000) at line 141: Field 'pname' doesn't have a default value

MySQL server is running in strict mode:

# plesk db "show variables like 'sql_mode'"
sql_mode      | STRICT_TRANS_TABLES,STRICT_ALL_TABLES

Cause

In this case, NULL value cannot be inserted into a column defined as NOT NULL. Without strict mode the NULL value would be replaced with empty string or 0.


Resolution

1. Login to the server over SSH

2. Disable the strict mode in /etc/my.cnf (RHEL/Centos) or /etc/mysql/my.cnf (Debian/Ubuntu):

CONFIG_TEXT: [mysqld]
sql_mode=""

3. Restart MySQL server:

For Ubuntu/Debian:

# service mysqld restart

For CentOS:

# service mariadb restart