Conversion from collation utf8mb4_general_ci into latin1_swedish_ci impossible for parameter #14903

Closed
opened 2025-11-02 11:25:30 -06:00 by GiteaMirror · 3 comments
Owner

Originally created by @wenqvip on GitHub (Aug 25, 2025).

Description

when open some repository, the web page shows internal server error, and show this message: Conversion from collation utf8mb4_general_ci into latin1_swedish_ci impossible for parameter

Gitea Version

1.24.5

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

No response

Git Version

2.34.1

Operating System

ubuntu

How are you running Gitea?

I download the binary version of linux amd64 platform, and run it on ubuntu, use mysql as database

Database

MySQL/MariaDB

Originally created by @wenqvip on GitHub (Aug 25, 2025). ### Description when open some repository, the web page shows internal server error, and show this message: Conversion from collation utf8mb4_general_ci into latin1_swedish_ci impossible for parameter ### Gitea Version 1.24.5 ### Can you reproduce the bug on the Gitea demo site? Yes ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version 2.34.1 ### Operating System ubuntu ### How are you running Gitea? I download the binary version of linux amd64 platform, and run it on ubuntu, use mysql as database ### Database MySQL/MariaDB
GiteaMirror added the issue/needs-feedback label 2025-11-02 11:25:30 -06:00
Author
Owner

@techknowlogick commented on GitHub (Aug 25, 2025):

Utf8mb4 is recommended. It's your database configured to use latin1?

@techknowlogick commented on GitHub (Aug 25, 2025): Utf8mb4 is recommended. It's your database configured to use latin1?
Author
Owner

@wxiaoguang commented on GitHub (Aug 26, 2025):

Actually neither (utf8mb4_general_ci/latin1_swedish_ci) is recommended. Please go to your admin panel -> self check, you will see guides.

@wxiaoguang commented on GitHub (Aug 26, 2025): Actually neither (utf8mb4_general_ci/latin1_swedish_ci) is recommended. Please go to your admin panel -> self check, you will see guides.
Author
Owner

@wenqvip commented on GitHub (Aug 27, 2025):

Actually neither (utf8mb4_general_ci/latin1_swedish_ci) is recommended. Please go to your admin panel -> self check, you will see guides.

thanks a lot, use 'gitea doctor convert' fix this.

@wenqvip commented on GitHub (Aug 27, 2025): > Actually neither (utf8mb4_general_ci/latin1_swedish_ci) is recommended. Please go to your admin panel -> self check, you will see guides. thanks a lot, use 'gitea doctor convert' fix this.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#14903