autonomic-cooperative/git.autonomic.zone
Archived
3
0
Fork 0
Code Issues 2 Pull Requests Releases Wiki Activity

Investigate charset issue with database #13

New Issue
Closed
opened 2020-07-21 20:27:00 +00:00 by decentral1se · 8 comments
decentral1se commented 2020-07-21 20:27:00 +00:00
Contributor
Copy Link
Copy Source

If you post an emoji or sometimes an image, the database explodes...

If you post an emoji or sometimes an image, the database explodes...
gunnarm commented 2020-07-22 10:20:06 +00:00
Copy Link
Copy Source

Have we checked what collation we are using for the database?

Have we checked what collation we are using for the database?
🎉 1
decentral1se commented 2020-09-09 05:13:33 +00:00
Author
Contributor
Copy Link
Copy Source

OK, confirmed on charset/collation!

MariaDB [gitea]> SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;
+--------------------+---------+-------------------+
| database           | charset | collation         |
+--------------------+---------+-------------------+
| information_schema | utf8    | utf8_general_ci   |
| gitea              | latin1  | latin1_swedish_ci |
| mysql              | latin1  | latin1_swedish_ci |
| performance_schema | utf8    | utf8_general_ci   |
+--------------------+---------+-------------------+
4 rows in set (0.002 sec)
OK, confirmed on charset/collation! ``` MariaDB [gitea]> SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA; +--------------------+---------+-------------------+ | database | charset | collation | +--------------------+---------+-------------------+ | information_schema | utf8 | utf8_general_ci | | gitea | latin1 | latin1_swedish_ci | | mysql | latin1 | latin1_swedish_ci | | performance_schema | utf8 | utf8_general_ci | +--------------------+---------+-------------------+ 4 rows in set (0.002 sec) ```
decentral1se commented 2020-09-09 05:14:45 +00:00
Author
Contributor
Copy Link
Copy Source

Annndddd, it works! 🎉 🎉 🎉

Annndddd, it works! :tada: :tada: :tada:
decentral1se commented 2020-09-09 05:14:59 +00:00
Author
Contributor
Copy Link
Copy Source

ALTER DATABASE gitea CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

`ALTER DATABASE gitea CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;`
3wordchant commented 2020-09-25 19:45:00 +00:00
Copy Link
Copy Source

Emojis still give me a 500 sadly :/ Also gitea crashes and doesn't trigger drone if you use an emoji in the first line of a commit message in a repo with a webhook. Regretfully reopening.

Emojis still give me a 500 sadly :/ Also gitea crashes and doesn't trigger drone if you use an emoji in the first line of a commit message in a repo with a webhook. Regretfully reopening.
3wordchant self-assigned this 2020-09-25 19:45:13 +00:00
decentral1se self-assigned this 2020-09-27 05:34:44 +00:00
decentral1se commented 2020-09-27 05:52:01 +00:00
Author
Contributor
Copy Link
Copy Source

🕴️

🕴️
decentral1se commented 2020-09-27 05:53:21 +00:00
Author
Contributor
Copy Link
Copy Source

8f78bd6862

I also had to run https://docs.gitea.io/en-us/command-line/#convert.

I will push a commit with an emoji now just to test again.

https://git.autonomic.zone/autonomic-cooperative/git.autonomic.zone/commit/8f78bd6862b82a54c21497f47d9df06abc4e6b21 I also had to run https://docs.gitea.io/en-us/command-line/#convert. I will push a commit with an emoji now just to test again.
❤️ 1
decentral1se commented 2020-09-27 05:54:53 +00:00
Author
Contributor
Copy Link
Copy Source

943958846a

https://git.autonomic.zone/autonomic-cooperative/git.autonomic.zone/commit/943958846ada367b5b52844445ecc6b2699bb3de
This repo is archived. You cannot comment on issues.
No Branch/Tag Specified
Branches Tags
Labels
No items
No labels
Milestone
No items
No Milestone
Assignees
Clear assignees
aadil (Aadil Ayub) analuisa autono-bot (Autono-bot) autonomic cas (Cassowary Rusnov) kawaiipunk (KawaiiPunk) knoflook lucas maazah notplants renovate-bot (Renovate Bot) tma trav (Trav Fryer) veganvenom
No Assignees 3wordchant decentral1se
3 Participants
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: autonomic-cooperative/git.autonomic.zone#13