Error message: Index column size too large...

The message appears in the dashboard for the "Jobs" database table:

Index column size too large. The maximum column size is 767 bytes.

Index column size too large. The maximum column size is 767 bytes.

Cause

The database software used (MySQL or MariaDB) is outdated.

Due to the use of the utf8mb4 character set, the maximum allowed index size of 767 bytes is exceeded. Since each character in utf8mb4 requires four bytes and the index is designed to support up to 255 characters, the resulting index size is 1,020 bytes (255 × 4 = 1,020 bytes).

Solution

Your database software must be updated. Please contact your web host or your server administrator. In current versions, the available index size is 3,072 bytes.