Migration Issue: missing issue_watch table #2304

New Issue

2025-11-02T04:31:55-06:00

GiteaMirror commented

2025-11-02 04:31:55 -06:00

Originally created by @psywhale on GitHub (Sep 6, 2018).

Gitea version (or commit ref): bd1bf2a072
Git version: 2
Operating system: ubuntu
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 issue #4882 now another migration issue

2018/09/06 12:21:34 [I] Log Mode: File(Info)
2018/09/06 12:21:34 [I] XORM Log Mode: File(Info)
2018/09/06 12:21:34 [I] Cache Service Enabled
2018/09/06 12:21:34 [I] Session Service Enabled
2018/09/06 12:21:34 [I] Mail Service Enabled
2018/09/06 12:21:34 [I] Register Mail Service Enabled
2018/09/06 12:21:34 [I] Notify Mail Service Enabled
2018/09/06 12:21:34 [I] Migration: remove stale watches
2018/09/06 12:21:34 [...itea/routers/init.go:60 GlobalInit()] [E] Failed to initialize ORM engine: migrate: do migrate: Error 1146: Table 'gogs.issue_watch' doesn't exist

Screenshots

Originally created by @psywhale on GitHub (Sep 6, 2018).  - Gitea version (or commit ref): bd1bf2a0720b771cfe2fac3fef0fd9edd68f6317 - Git version: 2 - Operating system: ubuntu - 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 issue #4882 now another migration issue 2018/09/06 12:21:34 [I] Log Mode: File(Info) 2018/09/06 12:21:34 [I] XORM Log Mode: File(Info) 2018/09/06 12:21:34 [I] Cache Service Enabled 2018/09/06 12:21:34 [I] Session Service Enabled 2018/09/06 12:21:34 [I] Mail Service Enabled 2018/09/06 12:21:34 [I] Register Mail Service Enabled 2018/09/06 12:21:34 [I] Notify Mail Service Enabled 2018/09/06 12:21:34 [I] Migration: remove stale watches 2018/09/06 12:21:34 [...itea/routers/init.go:60 GlobalInit()] [E] Failed to initialize ORM engine: migrate: do migrate: Error 1146: Table 'gogs.issue_watch' doesn't exist ## Screenshots

GiteaMirror added the type/question label 2025-11-02 04:31:55 -06:00

GiteaMirror closed this issue

2025-11-02 04:31:55 -06:00

GiteaMirror commented

2025-11-02 04:31:56 -06:00

@psywhale commented on GitHub (Sep 6, 2018):

For others having this problem...

create table issue_watch (
id bigint(20) primary key auto_increment,
user_id bigint(20) not null,
issue_id bigint(20) not null,
is_watching bool not null,
created_unix bigint(20) not null,
updated_unix bigint(20) not null
);

@psywhale commented on GitHub (Sep 6, 2018): For others having this problem... ``` create table issue_watch ( id bigint(20) primary key auto_increment, user_id bigint(20) not null, issue_id bigint(20) not null, is_watching bool not null, created_unix bigint(20) not null, updated_unix bigint(20) not null ); ```

GiteaMirror commented

2025-11-02 04:31:57 -06:00