gitea backup errors #3053

Closed
opened 2025-11-02 04:59:01 -06:00 by GiteaMirror · 2 comments
Owner

Originally created by @mariuspana on GitHub (Mar 15, 2019).

  • Gitea version (or commit ref): 1.7.3
  • Git version: 2.7.4
  • Operating system: Ubuntu 16.04.6 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:

Description

After upgrading to 1.7.3 from 1.6.3 running gitea dump produces the following error:

$ ./gitea dump
2019/03/15 13:28:43 Creating tmp work dir: /tmp/gitea-dump-370916781
2019/03/15 13:28:43 Dumping local repositories.../gitea
2019/03/15 13:29:29 Dumping database...
2019/03/15 13:29:31 Failed to dump database: Error 1054: Unknown column 'approvals_whitelist_user_i_ds' in 'field list'

We can still dump the database using mysqldump however it was a convenience to use gitea dump directly.

Thank you,
Marius

Originally created by @mariuspana on GitHub (Mar 15, 2019). <!-- NOTE: If your issue is a security concern, please send an email to security@gitea.io instead of opening a public issue --> <!-- 1. Please speak English, this is the language all maintainers can speak and write. 2. Please ask questions or configuration/deploy problems on our Discord server (https://discord.gg/gitea) or forum (https://discourse.gitea.io). 3. Please take a moment to check that your issue doesn't already exist. 4. Please give all relevant information below for bug reports, because incomplete details will be handled as an invalid report. --> - Gitea version (or commit ref): 1.7.3 - Git version: 2.7.4 - Operating system: Ubuntu 16.04.6 LTS - Database (use `[x]`): - [ ] PostgreSQL - [x] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x] Not relevant - Log gist: ## Description After upgrading to 1.7.3 from 1.6.3 running gitea dump produces the following error: $ ./gitea dump 2019/03/15 13:28:43 Creating tmp work dir: /tmp/gitea-dump-370916781 2019/03/15 13:28:43 Dumping local repositories.../gitea 2019/03/15 13:29:29 Dumping database... 2019/03/15 13:29:31 Failed to dump database: Error 1054: Unknown column 'approvals_whitelist_user_i_ds' in 'field list' We can still dump the database using mysqldump however it was a convenience to use gitea dump directly. Thank you, Marius
Author
Owner

@jolheiser commented on GitHub (Mar 15, 2019):

Has your database been updated since you updated Gitea?
This should happen when you first start Gitea after updating, or alternatively by running gitea -c path/to/app.ini migrate

@jolheiser commented on GitHub (Mar 15, 2019): Has your database been updated since you updated Gitea? This should happen when you first start Gitea after updating, or alternatively by running `gitea -c path/to/app.ini migrate`
Author
Owner

@mariuspana commented on GitHub (Mar 17, 2019):

Thank you @jolheiser, I forgot to run gitea migrate and it seems that it did not run after the upgrade or it did not finish. I do not have logs to look through in this particular case to chase this further.

@mariuspana commented on GitHub (Mar 17, 2019): Thank you @jolheiser, I forgot to run `gitea migrate` and it seems that it did not run after the upgrade or it did not finish. I do not have logs to look through in this particular case to chase this further.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#3053