nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

The database setup is not supporting utf8mb4 but it is.

Joshua Conboy

Database: We've found an error in MySQL supported version!

The database setup is not supporting utf8mb4
See our documentation for more information on setting up MySQL 5.7.

I am running all of this on Windows Server 2012. Jira, Confluence, and mysql.

MYSQL is version 5.7.25.0

I followed the Jira Instructions Step by step and I can't get passed this error.

Accepted answers

All comments

JP _AC Bielefeld Leader_

Hi,

which Jira version are you trying to install?

Best

Joshua Conboy

8.0.0

Daniel Eads

Hey there Joshua,

We see errors like this when the MySQL collation is not set to what Jira expects to use. Luckily this is an easy fix! The process is documented on our knowledgebase, but I'll also paste the info here.

We recommend backing up your MySQL instance before making changes! If Jira is the only thing you've got on this MySQL instance (since Jira isn't working for you yet) go ahead and skip a backup if you wish. But if you're not sure that Jira is the only database there, better safe than sorry.

Changing the Database Collation

Change yourDB to suit your database name:

<span>ALTER</span> <span>DATABASE</span> yourDB <span>CHARACTER SET</span> utf8 <span>COLLATE</span> utf8_bin

Changing Table Collation

The following query will produce a series of ALTER TABLE statements, which you must then run against your database. Change yourDB to suit your database name:

<span>SELECT</span> CONCAT<span>(</span><span>'ALTER TABLE '</span><span>,</span>  table_name<span>,</span> <span>' CHARACTER SET utf8 COLLATE utf8_bin;'</span><span>)</span>
<span>FROM</span> information_schema<span>.</span><span>TABLES</span> <span>AS</span> T<span>,</span> information_schema<span>.</span><span>`</span>COLLATION_CHARACTER_SET_APPLICABILITY<span>`</span> <span>AS</span> C
<span>WHERE</span> C<span>.</span>collation_name <span>=</span> T<span>.</span>table_collation
<span>AND</span> T<span>.</span>table_schema <span>=</span> <span>'yourDB'</span>
<span>AND</span>
<span>(</span>
    C<span>.</span>CHARACTER_SET_NAME <span>!=</span> <span>'utf8'</span>
    <span>OR</span>
    C<span>.</span>COLLATION_NAME <span>!=</span> <span>'utf8_bin'</span>
<span>)</span><span>;</span>

Changing Column Collation

The following queries (one for varchar columns, and one for non-varchar columns) will produce a series of ALTER TABLE statements, which you must then run against your database. Change yourDB to suit your database name:

<span>SELECT</span> CONCAT<span>(</span><span>'ALTER TABLE `'</span><span>,</span> table_name<span>,</span> <span>'` MODIFY `'</span><span>,</span> column_name<span>,</span> <span>'` '</span><span>,</span> DATA_TYPE<span>,</span> <span>'('</span><span>,</span> CHARACTER_MAXIMUM_LENGTH<span>,</span> <span>') CHARACTER SET UTF8 COLLATE utf8_bin'</span><span>,</span> <span>(</span><span>CASE</span> <span>WHEN</span> IS_NULLABLE <span>=</span> <span>'NO'</span> <span>THEN</span> <span>' NOT NULL'</span> <span>ELSE</span> <span>''</span> <span>END</span><span>)</span><span>,</span> <span>';'</span><span>)</span>
<span>FROM</span> information_schema<span>.</span><span>COLUMNS</span> 
<span>WHERE</span> TABLE_SCHEMA <span>=</span> <span>'yourDB'</span>
<span>AND</span> DATA_TYPE <span>=</span> <span>'varchar'</span>
<span>AND</span>
<span>(</span>
    CHARACTER_SET_NAME <span>!=</span> <span>'utf8'</span>
    <span>OR</span>
    COLLATION_NAME <span>!=</span> <span>'utf8_bin'</span>
<span>)</span><span>;</span>

<span>SELECT</span> CONCAT<span>(</span><span>'ALTER TABLE `'</span><span>,</span> table_name<span>,</span> <span>'` MODIFY `'</span><span>,</span> column_name<span>,</span> <span>'` '</span><span>,</span> DATA_TYPE<span>,</span> <span>' CHARACTER SET UTF8 COLLATE utf8_bin'</span><span>,</span> <span>(</span><span>CASE</span> <span>WHEN</span> IS_NULLABLE <span>=</span> <span>'NO'</span> <span>THEN</span> <span>' NOT NULL'</span> <span>ELSE</span> <span>''</span> <span>END</span><span>)</span><span>,</span> <span>';'</span><span>)</span>
<span>FROM</span> information_schema<span>.</span><span>COLUMNS</span> 
<span>WHERE</span> TABLE_SCHEMA <span>=</span> <span>'yourDB'</span>
<span>AND</span> DATA_TYPE <span>!=</span> <span>'varchar'</span>
<span>AND</span>
<span>(</span>
    CHARACTER_SET_NAME <span>!=</span> <span>'utf8'</span>
    <span>OR</span>
    COLLATION_NAME <span>!=</span> <span>'utf8_bin'</span>
<span>)</span><span>;</span>

Dealing with Foreign Key Constraints

It may be necessary to ignore foreign key constraints when making changes to a large number of columns. You can use the SET FOREIGN_KEY_CHECKS command to ignore foreign key constraints while you update the database.

<span>SET</span> FOREIGN_KEY_CHECKS<span>=</span><span>0</span><span>;</span>
 
<span>-- Insert your other SQL Queries here...</span>
 
<span>SET</span> FOREIGN_KEY_CHECKS<span>=</span><span>1</span><span>;</span>

Let us know if you still have any issues getting set up!

Cheers,
Daniel | Atlassian Support

Joshua Conboy

Followed these instructions.

No errors on the queries

Restarted Jira

Database: We've found an error in MySQL supported version!

The database setup is not supporting utf8mb4
See our documentation for more information on setting up MySQL 5.7.

Joshua Conboy

Still broken. Still Down

FG Bee

Did you ever receive a resolution for this?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software