warning in gitea.log about mysql tables #7346

New Issue

GiteaMirror · 2025-11-02T07:23:33-06:00

GiteaMirror commented

2025-11-02 07:23:33 -06:00

Originally created by @lds-lds on GitHub (May 17, 2021).

Gitea version (or commit ref): 1.14.2
Git version: 2.7.4
Operating system: ubuntu xenial, gitea launch with systemd
Database (use [x]):
- PostgreSQL
- [x ] MySQL
- MSSQL
- SQLite
Can you reproduce the bug at https://try.gitea.io:
- Yes (provide example URL)
- [x ] No
Log gist: gitea/log/gitea.log

Description

Hello
I see this warnings in logs gitea/log/gitea.log. Will these warnings be corrected in the next version of gitea, or do i have to manually correct something in the mariadb database?

2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table user Column keep_activity_private db default is , struct default is false
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table user Column keep_activity_private db nullable is true, struct nullable is false
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table repository Column original_service_type db default is 0, struct default is 
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table comment has column old_assignee_id but struct has not related field
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table webhook Column is_system_webhook db default is 0, struct default is 
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table webhook Column is_system_webhook db nullable is false, struct nullable is true
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table webhook Column http_method db default is 'POST', struct default is 
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table tracked_time Column time db nullable is true, struct nullable is false
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table review column type db type is VARCHAR(255), struct type is INT
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table language_stat Column language db nullable is true, struct nullable is false
2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table session has column created_unix but struct has not related field

Screenshots

Originally created by @lds-lds on GitHub (May 17, 2021). - Gitea version (or commit ref): 1.14.2 - Git version: 2.7.4 - Operating system: ubuntu xenial, gitea launch with systemd - Database (use `[x]`): - [ ] PostgreSQL - [x ] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x ] No - Log gist: gitea/log/gitea.log ## Description Hello I see this warnings in logs gitea/log/gitea.log. Will these warnings be corrected in the next version of gitea, or do i have to manually correct something in the mariadb database? ``` 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table user Column keep_activity_private db default is , struct default is false 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table user Column keep_activity_private db nullable is true, struct nullable is false 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table repository Column original_service_type db default is 0, struct default is 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table comment has column old_assignee_id but struct has not related field 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table webhook Column is_system_webhook db default is 0, struct default is 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table webhook Column is_system_webhook db nullable is false, struct nullable is true 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table webhook Column http_method db default is 'POST', struct default is 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table tracked_time Column time db nullable is true, struct nullable is false 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table review column type db type is VARCHAR(255), struct type is INT 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table language_stat Column language db nullable is true, struct nullable is false 2021/05/17 09:29:42 ...rfave/cli/command.go:173:Run() [W] Table session has column created_unix but struct has not related field ``` ## Screenshots

GiteaMirror added the type/question label 2025-11-02 07:23:33 -06:00

GiteaMirror closed this issue

2025-11-02 07:23:33 -06:00

GiteaMirror commented

2025-11-02 07:23:34 -06:00

@zeripath commented on GitHub (May 17, 2021):

gitea doctor recreate-table should fix this. (Please take a backup first just in case.)

@zeripath commented on GitHub (May 17, 2021): `gitea doctor recreate-table` should fix this. (Please take a backup first just in case.)

GiteaMirror commented

2025-11-02 07:23:34 -06:00

@lds-lds commented on GitHub (May 17, 2021):

thanks, the command gitea doctor recreate-table corrects the problem

@lds-lds commented on GitHub (May 17, 2021): thanks, the command gitea doctor recreate-table corrects the problem

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#7346