Confluence update issue

[Basil]

Hello!

I updated confluence to 5.4.3 version. But I got error: "Detected tables with non-default collation. See https://confluence.atlassian.com/x/TABrFw<span< a="">lang="en">"

But:

mysql> SELECT * FROM information_schema.COLUMNS WHERE table_schema = 'confluence' AND collation_name != 'utf8_bin';
Empty set (0,01 sec)

mysql> SELECT * FROM information_schema.TABLES WHERE table_schema = 'confluence' AND table_collation != 'utf8_bin';
Empty set (0,00 sec)

[jing_hwa_cheok]

Hi Basil,

Did any of the queries in this knowledge base article troubleshooting character and collation issue in mysql return any result?

I would suggest you to run all the queries in the article first to ensure all the collation and character is correctly set.

Regards,

Jing Hwa

[Basil]

Hello. As I wrote above:

mysql> SELECT * FROM information_schema.COLUMNS WHERE table_schema = 'confluence' AND collation_name != 'utf8_bin';
Empty set (0,01 sec)

mysql> SELECT * FROM information_schema.TABLES WHERE table_schema = 'confluence' AND table_collation != 'utf8_bin';
Empty set (0,00 sec)

[jing_hwa_cheok]

Hi Basil,

Have you run all the queries under second solution in the knowledge base article troubleshooting character and collation issue in mysql ?

There are three queries which you are suppose to run but froom what I can see in the comment you have not run this query:

SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = '<databasename>';

Let me know if this return no result as well.

[Basil]

Thanks!
It was necessary to make:

alter database confluence CHARACTER SET utf8 COLLATE utf8_bin;

[jing_hwa_cheok]

Glad you managed to find the cause of the issue. :)

[brian lee]

Hi everyone,

I encountered the exact same issue. The Kb saved me.

Basil, you should accept the answer if it fixed your issue to show your thanks :).

Cheers,
Brian

[Basil]

alter database confluence CHARACTER SET utf8 COLLATE utf8_bin; solved this issue