Crash in V75 Migration and old database #2670

Closed
opened 2025-11-02 04:44:00 -06:00 by GiteaMirror · 1 comment
Owner

Originally created by @trebonian on GitHub (Dec 18, 2018).

  • Gitea version (or commit ref): fe55ab2a68
  • Git version:
  • Operating system: Linux
  • Database (use [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

Latest version errors out with no such table "stop_watch" when migrating V75 on the following statement:

  • if _, err := x.Exec(builder.Delete(condDelete("user_id")).From("stop_watch")); err != nil {
      return err
    }
     
    In my version of SQLite - the table is called stopwatch (no underscore character). I have a very old database so this may be related to that. I replaced the tablename with "stopwatch", rebuilt gitea and it worked.

...

Screenshots

Originally created by @trebonian on GitHub (Dec 18, 2018). <!-- 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): fe55ab2a68 - Git version: - Operating system: Linux - 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 - Log gist: ## Description Latest version errors out with no such table "stop_watch" when migrating V75 on the following statement: + if _, err := x.Exec(builder.Delete(condDelete("user_id")).From("stop_watch")); err != nil { --   return err }   In my version of SQLite - the table is called stopwatch (no underscore character). I have a very old database so this may be related to that. I replaced the tablename with "stopwatch", rebuilt gitea and it worked. ... ## Screenshots <!-- **If this issue involves the Web Interface, please include a screenshot** -->
GiteaMirror added the type/bug label 2025-11-02 04:44:00 -06:00
Author
Owner

@jlelse commented on GitHub (Dec 19, 2018):

I have the same error running the latest docker image

@jlelse commented on GitHub (Dec 19, 2018): I have the same error running the latest docker image
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#2670