Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

why do i use mysql 5.7 is no work for jira 8.13 and 8.17

i config mysql 5.7 ,and jira notice me my databases version is  no support version

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

why ?

and i config jira 8.17 ,use mysql 8 ,and jira install ,create database and create tables

2021-06-16 21:44:44,438+0800 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "issueswithvalue" to table "customfield"
2021-06-16 21:44:44,438+0800 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
ALTER TABLE customfield ADD issueswithvalue DECIMAL(18,0)
Error was: java.sql.SQLSyntaxErrorException: Table 'jiradb2.customfield' doesn't exist
 

1 answer

0 votes
Dirk Ronsmans Community Leader Jun 16, 2021

Hi @X ,

did you do the step "See our documentation for more information on setting up MySQL 5.7"

Seems you have created the DB with the wrong table collation.

You can follow the steps here: 

https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html

i have to follow jira install step to do , mysql 5.7 or mysql 8.0 have set utf8mb4 and utf8mb4_bin,but jira alway show me error...

why??

Dirk Ronsmans Community Leader Jun 16, 2021

And where are you seeing the error? during the install? in a healthcheck?

I don't think I fully understand your problem.

You should create the DB, set the collation (preferably at time of creation) and then run the setup.

a screenshot can also help ..

i init jira 8.17,use mysql 8

截屏2021-06-16 22.54.07.png

jira just create three table , and to error, over init

web redirect /secure/errors.jsp,it's empy page

why

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

👁‍🗨 Confluence Team planning dashboard_Atlympics 🌈

Hi Atlassian's, How is your journey with #Atlympics 2021 so far....excited! Me too, same excitement. Here's my typical team planning and vision dashboard which I used to share to my management and ...

113 views 1 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you