github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-12 10:39:38 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

Failed to initialize ORM engine: sync database struct error [...] BLOB/TEXT column 'key_id' used in key specification without a key length #543

New Issue
Closed
opened 2025-11-02 03:27:36 -06:00 by GiteaMirror · 1 comment
GiteaMirror commented 2025-11-02 03:27:36 -06:00
Owner
Copy Link

Originally created by @otih on GitHub (Mar 19, 2017).

  • Gitea version (or commit ref): 8bcb643a03 (latest master)
  • Git version: 2.7.4
  • Operating system: Ubuntu 16.04.2 LTS
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • Not relevant
  • Log gist:
    2017/03/19 20:46:10 [I] Log Mode: File(Info)
    2017/03/19 20:46:10 [I] XORM Log Mode: File(Info)
    2017/03/19 20:46:10 [I] Cache Service Enabled
    2017/03/19 20:46:10 [I] Session Service Enabled
    2017/03/19 20:46:10 [I] Mail Service Enabled
    2017/03/19 20:46:10 [I] Register Mail Service Enabled
    2017/03/19 20:46:10 [I] Notify Mail Service Enabled
    2017/03/19 20:46:10 [...itea/routers/init.go:54 GlobalInit()] [E] Failed to initialize ORM engine: sync database struct error: Error 1170: BLOB/TEXT column 'key_id' used in key specification without a key length

Description

gitea is not able to start with latest master version. "BLOB/TEXT column 'key_id' used in key specification without a key length"

following SQL error:
2017/03/19 20:49:51 [I] [sql] CREATE INDEX IDX_gpg_key_key_id ON gpg_key (key_id)
Not solvable by creating this index manually.

Originally created by @otih on GitHub (Mar 19, 2017). - Gitea version (or commit ref): 8bcb643a031e4739ca8ead8351ef7f9092969299 (latest master) - Git version: 2.7.4 - Operating system: Ubuntu 16.04.2 LTS - Database (use `[x]`): - [ ] PostgreSQL - [X] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x] No - [ ] Not relevant - Log gist: 2017/03/19 20:46:10 [I] Log Mode: File(Info) 2017/03/19 20:46:10 [I] XORM Log Mode: File(Info) 2017/03/19 20:46:10 [I] Cache Service Enabled 2017/03/19 20:46:10 [I] Session Service Enabled 2017/03/19 20:46:10 [I] Mail Service Enabled 2017/03/19 20:46:10 [I] Register Mail Service Enabled 2017/03/19 20:46:10 [I] Notify Mail Service Enabled 2017/03/19 20:46:10 [...itea/routers/init.go:54 GlobalInit()] [E] Failed to initialize ORM engine: sync database struct error: Error 1170: BLOB/TEXT column 'key_id' used in key specification without a key length ## Description gitea is not able to start with latest master version. "BLOB/TEXT column 'key_id' used in key specification without a key length" following SQL error: 2017/03/19 20:49:51 [I] [sql] CREATE INDEX `IDX_gpg_key_key_id` ON `gpg_key` (`key_id`) Not solvable by creating this index manually.
GiteaMirror commented 2025-11-02 03:27:37 -06:00
Author
Owner
Copy Link

@otih commented on GitHub (Mar 19, 2017):

duplicate with #1327

@otih commented on GitHub (Mar 19, 2017): duplicate with #1327
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
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#543
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?