github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-11 17:46:29 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

NewPullRequest: newIssue: Error 3988: Conversion from collation utf8mb4_0900_ai_ci into utf8_general_ci impossible for parameter #10251

New Issue
Closed
opened 2025-11-02 09:02:14 -06:00 by GiteaMirror · 4 comments
GiteaMirror commented 2025-11-02 09:02:14 -06:00
Owner
Copy Link

Originally created by @ThraaxSession on GitHub (Feb 11, 2023).

Description

Renovate can creates a branch but not create a PR. It leads to a conversion error in the db. Gitea is migrate. I assume unicode can't be handled. See the question emoticon in "Screenshots".

Gitea Version

1.18.3

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

   ---

    ❓ Got questions? Check out Renovate's [Docs](https://docs.renovatebot.com/), particularly the Getting Started section.
    If you need any further assistance then you can also [request help here](https://github.com/renovatebot/renovate/discussions).


    ---

This PR has been generated by Renovate Bot.
0 0 false true 0 0 1676108759 1676108759 0 false] - 769.507µs
2023/02/11 10:45:59 .../api/v1/repo/pull.go:420:CreatePullRequest() [I] [63e763d7] [SQL] ROLLBACK [] - 2.040923ms
2023/02/11 10:45:59 .../api/v1/repo/pull.go:425:CreatePullRequest() [E] [63e763d7] NewPullRequest: newIssue: Error 3988: Conversion from collation utf8mb4_0900_ai_ci into utf8_general_ci impossible for parameter
2023/02/11 10:45:59 [63e763d7] router: completed POST /api/v1/repos/SpaceUp/SWS/pulls for 162.55.152.199:0, 500 Internal Server Error in 282.1ms @ repo/pull.go:251(repo.CreatePullRequest)
2023/02/11 10:45:59 models/auth/token.go:160:GetAccessTokenBySHA() [I] [63e763d7-32] [SQL] SELECT id, uid, name, token_hash, token_salt, token_last_eight, created_unix, updated_unix FROM access_token WHERE (token_last_eight = ?) [c37d6d3b] - 824.249µs

Git Version

2.30.2

Operating System

Debian

How are you running Gitea?

It's self-hosted and scheduled by supervisor.

Database

MySQL

Originally created by @ThraaxSession on GitHub (Feb 11, 2023). ### Description Renovate can creates a branch but not create a PR. It leads to a conversion error in the db. Gitea is migrate. I assume unicode can't be handled. See the question emoticon in "Screenshots". ### Gitea Version 1.18.3 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots --- ❓ Got questions? Check out Renovate's [Docs](https://docs.renovatebot.com/), particularly the Getting Started section. If you need any further assistance then you can also [request help here](https://github.com/renovatebot/renovate/discussions). --- This PR has been generated by [Renovate Bot](https://github.com/renovatebot/renovate). 0 0 false true 0 0 1676108759 1676108759 0 false] - 769.507µs 2023/02/11 10:45:59 .../api/v1/repo/pull.go:420:CreatePullRequest() [I] [63e763d7] [SQL] ROLLBACK [] - 2.040923ms **2023/02/11 10:45:59 .../api/v1/repo/pull.go:425:CreatePullRequest() [E] [63e763d7] NewPullRequest: newIssue: Error 3988: Conversion from collation utf8mb4_0900_ai_ci into utf8_general_ci impossible for parameter** 2023/02/11 10:45:59 [63e763d7] router: completed POST /api/v1/repos/SpaceUp/SWS/pulls for 162.55.152.199:0, 500 Internal Server Error in 282.1ms @ repo/pull.go:251(repo.CreatePullRequest) 2023/02/11 10:45:59 models/auth/token.go:160:GetAccessTokenBySHA() [I] [63e763d7-32] [SQL] SELECT `id`, `uid`, `name`, `token_hash`, `token_salt`, `token_last_eight`, `created_unix`, `updated_unix` FROM `access_token` WHERE (token_last_eight = ?) [c37d6d3b] - 824.249µs ### Git Version 2.30.2 ### Operating System Debian ### How are you running Gitea? It's self-hosted and scheduled by supervisor. ### Database MySQL
GiteaMirror added the type/bug label 2025-11-02 09:02:14 -06:00
GiteaMirror commented 2025-11-02 09:02:15 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Feb 12, 2023):

Please check all your database tables has the same collation.

@lunny commented on GitHub (Feb 12, 2023): Please check all your database tables has the same collation.
GiteaMirror commented 2025-11-02 09:02:15 -06:00
Author
Owner
Copy Link

@ThraaxSession commented on GitHub (Feb 12, 2023):

Shouldn't migrate fix it? What should be the right one for all tables?

@ThraaxSession commented on GitHub (Feb 12, 2023): Shouldn't `migrate` fix it? What should be the right one for all tables?
GiteaMirror commented 2025-11-02 09:02:15 -06:00
Author
Owner
Copy Link

@zeripath commented on GitHub (Feb 12, 2023):

Use gitea convert

@zeripath commented on GitHub (Feb 12, 2023): Use `gitea convert`
GiteaMirror commented 2025-11-02 09:02:15 -06:00
Author
Owner
Copy Link

@ThraaxSession commented on GitHub (Feb 16, 2023):

Worked, thanks!

@ThraaxSession commented on GitHub (Feb 16, 2023): Worked, thanks!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label type/bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#10251
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?