#3478 - Difficulty installing Composr CMS — Step 5 of 10 Installer Error Occurred
-
By JasBrouwer
- Added
- 0 views
| Identifier | #3478 |
|---|---|
| Issue type | Major issue (breaks an entire feature) |
| Title | Difficulty installing Composr CMS — Step 5 of 10 Installer Error Occurred |
| Status | Closed (not fixable) |
| Handling member | Chris Graham |
| Addon | installer |
| Description | The error message received was
Unfortunately a query has failed [CREATE TABLE cms_db_meta ( m_table varchar(80) NOT NULL, m_name varchar(80) NOT NULL, m_type varchar(80) NOT NULL, PRIMARY KEY (m_table, m_name) ) CHARACTER SET=utf8mb4 engine=MyISAM] [Unknown character set: 'utf8mb4'] |
| Steps to reproduce | |
| Additional information | I'm informed by the hosting company (iX Web Hosting) that utf8mb4 is not supported by the server and needs to be changed to utf8.
I've attached a .pdf file of the installation stack trace. |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
We require at least MySQL 5.5.3, which was released in 2010.
Often webhosts don't upgrade their software for very long periods, which is also a security risk.
The reason we need utf8mb4 is because it is required to save emojis. Without it, pasting in an emoji would cause query errors, as the database would not recognise the character.
Basically utf8mb4 is as close to real utf-8 that MySQL can do. MySQL's utf8 is very much not proper utf-8.