error during dump command: Failed to dump database: no such table: user #2712

Closed
opened 2025-11-02 04:45:18 -06:00 by GiteaMirror · 4 comments
Owner

Originally created by @jryan128 on GitHub (Jan 5, 2019).

  • Gitea version (or commit ref): 1.6.2 built with: bindata, sqlite
  • Git version: git version 2.11.0
  • Operating system: Debian
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • Not relevant

Description

git@gitea:~$` gitea dump -c /etc/gitea/app.ini
2019/01/05 20:38:55 Creating tmp work dir: /tmp/gitea-dump-249881383
2019/01/05 20:38:55 Dumping local repositories.../home/git/gitea-repositories
2019/01/05 20:38:56 Dumping database...
2019/01/05 20:38:56 Failed to dump database: no such table: user

Originally created by @jryan128 on GitHub (Jan 5, 2019). <!-- 1. Please speak English, this is the language all of us can speak and write. 2. Please ask questions or configuration/deploy problems on our Discord server (https://discord.gg/NsatcWJ) 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.6.2 built with: bindata, sqlite - Git version: git version 2.11.0 - Operating system: Debian - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [ ] MSSQL - [X] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x] Not relevant ## Description git@gitea:~$` gitea dump -c /etc/gitea/app.ini 2019/01/05 20:38:55 Creating tmp work dir: /tmp/gitea-dump-249881383 2019/01/05 20:38:55 Dumping local repositories.../home/git/gitea-repositories 2019/01/05 20:38:56 Dumping database... 2019/01/05 20:38:56 Failed to dump database: no such table: user
GiteaMirror added the type/bug label 2025-11-02 04:45:18 -06:00
Author
Owner

@mikescandy commented on GitHub (Jan 24, 2019):

Confirm the issue also with version 1.7.0 (also using SQLite)

@mikescandy commented on GitHub (Jan 24, 2019): Confirm the issue also with version 1.7.0 (also using SQLite)
Author
Owner

@Lord-Y commented on GitHub (Jan 25, 2019):

Got the same issue. In your app.ini if you change PATH = data/gitea.db by PATH = YOUR_FULL_PATH/data/gitea.db, it'll works.

@Lord-Y commented on GitHub (Jan 25, 2019): Got the same issue. In your app.ini if you change `PATH = data/gitea.db` by `PATH = YOUR_FULL_PATH/data/gitea.db`, it'll works.
Author
Owner

@jryan128 commented on GitHub (Jan 25, 2019):

Replacing relative path with absolute path in db.PATH does fix the issue for me.

@jryan128 commented on GitHub (Jan 25, 2019): Replacing relative path with absolute path in db.PATH does fix the issue for me.
Author
Owner

@msreedata commented on GitHub (Apr 13, 2019):

As @jryan128 mentioned, absolute path works fine.
Also if you do a pushd/cd to the gitea workdir and run the backup command (without changing the db.PATH to absolute path in app.ini), the backup goes through fine.

@msreedata commented on GitHub (Apr 13, 2019): As @jryan128 mentioned, absolute path works fine. Also if you do a pushd/cd to the gitea workdir and run the backup command (without changing the db.PATH to absolute path in app.ini), the backup goes through fine.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#2712