Cannot recover from backup of gitea 1.4.0 #2178

New Issue

GiteaMirror · 2025-11-02T04:26:17-06:00

GiteaMirror commented

2025-11-02 04:26:17 -06:00

Originally created by @fbettag on GitHub (Aug 12, 2018).

Gitea version (or commit ref):
Git version: 1.4.0
Operating system: FreeBSD 11.1 / Ubuntu 16.04
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:

Description

Trying to migrate (dump/restore) on gitea 1.4.0 on FreeBSD and move it to Ubuntu 16.04 running 1.5.0. I also tried every major release from 1.0.0 to 1.5.0 and i always get "[E] Fail to initialize ORM engine: sync database struct error: Unknown col name in indexe" with a different column in each version.

This database dump works fine on FreeBSD but when i try to start gitea web on 1.4.0 on Ubuntu, it won't start. Ideally i want 1.5.0 but best of all would be a running version.

If i remove all columns in question, this goes as far as ssh keys owner_id, which gets removed. is there any manual way to do db migration?
...

Originally created by @fbettag on GitHub (Aug 12, 2018).  - Gitea version (or commit ref): - Git version: 1.4.0 - Operating system: FreeBSD 11.1 / Ubuntu 16.04 - 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: ## Description Trying to migrate (dump/restore) on gitea 1.4.0 on FreeBSD and move it to Ubuntu 16.04 running 1.5.0. I also tried every major release from 1.0.0 to 1.5.0 and i always get "[E] Fail to initialize ORM engine: sync database struct error: Unknown col name in indexe" with a different column in each version. This database dump works fine on FreeBSD but when i try to start gitea web on 1.4.0 on Ubuntu, it won't start. Ideally i want 1.5.0 but best of all would be a running version. If i remove all columns in question, this goes as far as ssh keys owner_id, which gets removed. is there any manual way to do db migration? ...

GiteaMirror added the type/question issue/stale labels 2025-11-02 04:26:17 -06:00

GiteaMirror closed this issue

2025-11-02 04:26:17 -06:00

GiteaMirror commented

2025-11-02 04:26:18 -06:00

@lafriks commented on GitHub (Aug 12, 2018):

It would be recommended to first run same version as you were running on freebsd. Does it give you any error?

@lafriks commented on GitHub (Aug 12, 2018): It would be recommended to first run same version as you were running on freebsd. Does it give you any error?

GiteaMirror commented

2025-11-02 04:26:18 -06:00

@fbettag commented on GitHub (Aug 13, 2018):

I already tried the 1.4.0 that my pkg info on freebsd shows me :) i downloaded the binary on Ubuntu with wget and i tried to alter table user drop column XYZ whatever it was reporting me.

To be totally honest, this was an old gogs installation that got migrated over with gitea 1.1. So i assume that there is still some db-fields that didn't get migrated.

@fbettag commented on GitHub (Aug 13, 2018): I already tried the 1.4.0 that my pkg info on freebsd shows me :) i downloaded the binary on Ubuntu with wget and i tried to alter table user drop column XYZ whatever it was reporting me. To be totally honest, this was an old gogs installation that got migrated over with gitea 1.1. So i assume that there is still some db-fields that didn't get migrated.

GiteaMirror commented

2025-11-02 04:26:18 -06:00

@stale[bot] commented on GitHub (Jan 14, 2019):

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.

@stale[bot] commented on GitHub (Jan 14, 2019): This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs during the next 2 weeks. Thank you for your contributions.

GiteaMirror referenced this issue

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

[PR #2178] [MERGED] Fix profile update for non-local users #16272

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/gitea#2178