MigratePost: pq: value too long for type character varying(255) #3692

New Issue

GiteaMirror · 2025-11-02T05:21:52-06:00

GiteaMirror commented

2025-11-02 05:21:52 -06:00

Originally created by @Alir3z4 on GitHub (Jul 28, 2019).

Gitea version 1.9.0+rc2-16-gd789170e3 built with GNU Make 4.1, go1.12.7 : bindata, sqlite, sqlite_unlock_notify
Git version: 2.7.4
Operating system: Ubuntu 16.04 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:

2019/07/28 17:26:12 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT "id", "owner_id", "lower_name", "name", "description", "website", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "is_private", "is_empty", "is_archived", "is_mirror", "is_fork", "fork_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 []interface {}{1, "heroku3.py"}
2019/07/28 17:26:12 .../xorm/session_raw.go:143:queryBytes() [I] [SQL] INSERT INTO "repository" ("owner_id","lower_name","name","description","website","default_branch","num_watches","num_stars","num_forks","num_issues","num_closed_issues","num_pulls","num_closed_pulls","num_milestones","num_closed_milestones","is_private","is_empty","is_archived","is_mirror","is_fork","fork_id","size","is_fsck_enabled","close_issues_via_commit_in_any_branch","topics","avatar","created_unix","updated_unix") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28) RETURNING "id" []interface {}{1, "heroku3.py", "heroku3.py", "This is the updated Python wrapper for the Heroku API V3. https://devcenter.heroku.com/articles/platform-api-reference The Heroku REST API allows Heroku users to manage their accounts, applications, addons, and other aspects related to Heroku. It allows you to easily utilize the Heroku platform from your applications.", "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, false, false, false, false, false, 0, 0, true, false, "null", "", 1564334772, 1564334772}
2019/07/28 17:26:12 ...xorm/xorm/session.go:845:saveLastSQL() [I] [SQL] ROLL BACK
2019/07/28 17:26:12 routers/repo/repo.go:315:MigratePost() [E] MigratePost: pq: value too long for type character varying(255)

Description

I'm trying to import a github repo (https://github.com/Alir3z4/heroku3.py) with all the issues, pull requests etc.
After hitting migrate button, it shows 500 page.

The last error is:

2019/07/28 17:26:12 routers/repo/repo.go:315:MigratePost() [E] MigratePost: pq: value too long for type character varying(255)

Screenshots

Originally created by @Alir3z4 on GitHub (Jul 28, 2019). - Gitea version 1.9.0+rc2-16-gd789170e3 built with GNU Make 4.1, go1.12.7 : bindata, sqlite, sqlite_unlock_notify - Git version: 2.7.4 - Operating system: Ubuntu 16.04 LTS - Database (use `[x]`): - [x] PostgreSQL - [ ] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x] Not relevant - Log gist: ``` 2019/07/28 17:26:12 .../xorm/session_get.go:99:nocacheGet() [I] [SQL] SELECT "id", "owner_id", "lower_name", "name", "description", "website", "default_branch", "num_watches", "num_stars", "num_forks", "num_issues", "num_closed_issues", "num_pulls", "num_closed_pulls", "num_milestones", "num_closed_milestones", "is_private", "is_empty", "is_archived", "is_mirror", "is_fork", "fork_id", "size", "is_fsck_enabled", "close_issues_via_commit_in_any_branch", "topics", "avatar", "created_unix", "updated_unix" FROM "repository" WHERE "owner_id"=$1 AND "lower_name"=$2 LIMIT 1 []interface {}{1, "heroku3.py"} 2019/07/28 17:26:12 .../xorm/session_raw.go:143:queryBytes() [I] [SQL] INSERT INTO "repository" ("owner_id","lower_name","name","description","website","default_branch","num_watches","num_stars","num_forks","num_issues","num_closed_issues","num_pulls","num_closed_pulls","num_milestones","num_closed_milestones","is_private","is_empty","is_archived","is_mirror","is_fork","fork_id","size","is_fsck_enabled","close_issues_via_commit_in_any_branch","topics","avatar","created_unix","updated_unix") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28) RETURNING "id" []interface {}{1, "heroku3.py", "heroku3.py", "This is the updated Python wrapper for the Heroku API V3. https://devcenter.heroku.com/articles/platform-api-reference The Heroku REST API allows Heroku users to manage their accounts, applications, addons, and other aspects related to Heroku. It allows you to easily utilize the Heroku platform from your applications.", "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, false, false, false, false, false, 0, 0, true, false, "null", "", 1564334772, 1564334772} 2019/07/28 17:26:12 ...xorm/xorm/session.go:845:saveLastSQL() [I] [SQL] ROLL BACK 2019/07/28 17:26:12 routers/repo/repo.go:315:MigratePost() [E] MigratePost: pq: value too long for type character varying(255) ``` ## Description I'm trying to import a github repo (https://github.com/Alir3z4/heroku3.py) with all the issues, pull requests etc. After hitting migrate button, it shows 500 page. The last error is: ``` 2019/07/28 17:26:12 routers/repo/repo.go:315:MigratePost() [E] MigratePost: pq: value too long for type character varying(255) ``` ## Screenshots ![image](https://user-images.githubusercontent.com/591113/62009951-61179d80-b16d-11e9-977c-8b0e120d4c55.png)

GiteaMirror added the type/bug label 2025-11-02 05:21:52 -06:00

GiteaMirror closed this issue

2025-11-02 05:21:53 -06:00

GiteaMirror referenced this issue

2025-11-02 12:25:00 -06:00

[PR #3692] [MERGED] Backport: Escape branch name in dropdown menu #17045

Sign in to join this conversation.