View repo failed #11309

Closed
opened 2025-11-02 09:34:01 -06:00 by GiteaMirror · 4 comments
Owner

Originally created by @hiifong on GitHub (Jul 23, 2023).

Description

build from main branch,a12a5f3652

An error occurred:

GetRecentlyPushedBranches, Error 1267 (HY000): Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

image

Gitea Version

1.20.0+rc0-353-ga12a5f365

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

No response

How are you running Gitea?

./gitea web

Database

MySQL

Originally created by @hiifong on GitHub (Jul 23, 2023). ### Description build from main branch,https://github.com/go-gitea/gitea/commit/a12a5f3652c339b17b187ff424a480631a3c1e1e ``` An error occurred: GetRecentlyPushedBranches, Error 1267 (HY000): Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' ``` ![image](https://github.com/go-gitea/gitea/assets/89133723/7c457f41-67cd-4d28-9c78-28711837999b) ### Gitea Version 1.20.0+rc0-353-ga12a5f365 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version _No response_ ### Operating System _No response_ ### How are you running Gitea? ./gitea web ### Database MySQL
GiteaMirror added the type/bugissue/workaround labels 2025-11-02 09:34:01 -06:00
Author
Owner

@delvh commented on GitHub (Jul 23, 2023):

Oh, woohoo.
I start to hate MySQL.

@delvh commented on GitHub (Jul 23, 2023): Oh, woohoo. I start to hate MySQL.
Author
Owner

@wxiaoguang commented on GitHub (Jul 23, 2023):

It's not really related to MySQL, but it's Gitea's fatal.

In history, Gitea allows users to customize everything, including the MySQL's charset (but not other database's ....)

Then, incorrect charset causes this problem.

@wxiaoguang commented on GitHub (Jul 23, 2023): It's not really related to MySQL, but it's Gitea's fatal. In history, Gitea allows users to customize everything, including the MySQL's charset (but not other database's ....) Then, incorrect charset causes this problem.
Author
Owner

@hiifong commented on GitHub (Jul 23, 2023):

temporary solution: run ./gitea convertcommand

@hiifong commented on GitHub (Jul 23, 2023): temporary solution: run `./gitea convert`command
Author
Owner

@lunny commented on GitHub (Jul 24, 2023):

We need to have a fixed charset and collation for all supported databases.

@lunny commented on GitHub (Jul 24, 2023): We need to have a fixed charset and collation for all supported databases.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#11309