github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-07-15 20:09:18 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

[1.18.0] SQL warnings on start-up, which can't be fixed by the doctor. #10024

New Issue
Open
opened 2025-11-02 08:56:04 -06:00 by GiteaMirror · 17 comments
GiteaMirror commented 2025-11-02 08:56:04 -06:00
Owner
Copy Link

Originally created by @tuxmaster5000 on GitHub (Dec 30, 2022).

Description

When I start it, some SQL warnings are shown:

Dez 30 06:50:43  gitea[14648]: 2022/12/30 06:50:43 routers/init.go:145:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
Dez 30 06:50:43  gitea[14648]: 2022/12/30 06:50:43 routers/init.go:145:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
Dez 30 06:50:43  gitea[14648]: 2022/12/30 06:50:43 routers/init.go:145:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED

I have tryed to fix it via:
sudo -u gitea ./gitea -c /etc/gitea/gitea.ini doctor recreate-table project system_setting
But on the next start, the messages are occurs again the the log.

Gitea Version

1.18.0

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

2.18.4

Operating System

CentOS7

How are you running Gitea?

Download binary blob from github.
Running via systemd as an separate user.
DB version: MariaDB-server-10.6.11-1.el7.centos.x86_64

Database

MySQL

Originally created by @tuxmaster5000 on GitHub (Dec 30, 2022). ### Description When I start it, some SQL warnings are shown: ``` Dez 30 06:50:43 gitea[14648]: 2022/12/30 06:50:43 routers/init.go:145:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1 Dez 30 06:50:43 gitea[14648]: 2022/12/30 06:50:43 routers/init.go:145:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED Dez 30 06:50:43 gitea[14648]: 2022/12/30 06:50:43 routers/init.go:145:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED ``` I have tryed to fix it via: `sudo -u gitea ./gitea -c /etc/gitea/gitea.ini doctor recreate-table project system_setting` But on the next start, the messages are occurs again the the log. ### Gitea Version 1.18.0 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version 2.18.4 ### Operating System CentOS7 ### How are you running Gitea? Download binary blob from github. Running via systemd as an separate user. DB version: MariaDB-server-10.6.11-1.el7.centos.x86_64 ### Database MySQL
GiteaMirror added the type/bugtype/upstream labels 2025-11-02 08:56:04 -06:00
GiteaMirror commented 2025-11-02 08:56:05 -06:00
Author
Owner
Copy Link

@hbokh commented on GitHub (Jan 13, 2023):

Also with sqlite3 the same warning occurs regarding table system_setting:

2023/01/13 09:48:58 ...rfave/cli/command.go:173:Run() [W] Table system_setting Column version db default is , struct default is 1
@hbokh commented on GitHub (Jan 13, 2023): Also with `sqlite3` the same warning occurs regarding table `system_setting`: ``` 2023/01/13 09:48:58 ...rfave/cli/command.go:173:Run() [W] Table system_setting Column version db default is , struct default is 1 ```
GiteaMirror commented 2025-11-02 08:56:05 -06:00
Author
Owner
Copy Link

@tacerus commented on GitHub (Feb 6, 2023):

Same issue, but only with system_settings.

@tacerus commented on GitHub (Feb 6, 2023): Same issue, but only with `system_settings`.
GiteaMirror commented 2025-11-02 08:56:05 -06:00
Author
Owner
Copy Link

@zeripath commented on GitHub (Feb 7, 2023):

These are bugs in Xorm and can be ignored.

@zeripath commented on GitHub (Feb 7, 2023): These are bugs in Xorm and can be ignored.
GiteaMirror commented 2025-11-02 08:56:05 -06:00
Author
Owner
Copy Link

@pboguslawski commented on GitHub (May 18, 2023):

After upgrading to v1.19 problem is still present:

2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED

These are bugs in Xorm and can be ignored.

Ignoring error messages should be avoided.

@pboguslawski commented on GitHub (May 18, 2023): After upgrading to v1.19 problem is still present: ``` 2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1 2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED 2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED 2023/05/18 14:36:28 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED ``` > These are bugs in Xorm and can be ignored. Ignoring error messages should be avoided.
GiteaMirror commented 2025-11-02 08:56:05 -06:00
Author
Owner
Copy Link

@tuxmaster5000 commented on GitHub (Jul 19, 2023):

It will also affect PostgreSQL. Tested with gitea 1.20.0

@tuxmaster5000 commented on GitHub (Jul 19, 2023): It will also affect PostgreSQL. Tested with gitea 1.20.0
GiteaMirror commented 2025-11-02 08:56:06 -06:00
Author
Owner
Copy Link

@coderkun commented on GitHub (Jul 19, 2023):

On MariaDB I went ahead and fixed most of these warnings

[W] Table system_setting Column version db default is , struct default is 1
[W] Table email_address Column lower_email db nullable is true, struct nullable is false
[W] Table gpg_key Column content db nullable is true, struct nullable is false
[W] Table gpg_key_import Column content db nullable is true, struct nullable is false
[W] Table public_key Column content db nullable is true, struct nullable is false
[W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
[W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
[W] Table project Column card_type db default is 0, struct default is
[W] Table project Column card_type db nullable is false, struct nullable is true
[W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
[W] Table hook_task has column repo_id but struct has not related field

manually with these SQL statements

ALTER TABLE system_setting MODIFY COLUMN version INT(11) NULL DEFAULT 1;
ALTER TABLE email_address MODIFY COLUMN lower_email VARCHAR(255) NOT NULL;
ALTER TABLE gpg_key MODIFY COLUMN content MEDIUMTEXT NOT NULL;
ALTER TABLE gpg_key_import MODIFY COLUMN content MEDIUMTEXT NOT NULL;
ALTER TABLE public_key MODIFY COLUMN content MEDIUMTEXT NOT NULL;
ALTER TABLE project MODIFY COLUMN board INT UNSIGNED;
ALTER TABLE project MODIFY COLUMN card_type INT UNSIGNED;
ALTER TABLE project MODIFY COLUMN type INT UNSIGNED;
ALTER TABLE hook_task DROP COLUMN repo_id;

After that, I got these warnings left:

[W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
[W] Table project column card_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
[W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
@coderkun commented on GitHub (Jul 19, 2023): On MariaDB I went ahead and fixed most of these warnings ``` [W] Table system_setting Column version db default is , struct default is 1 [W] Table email_address Column lower_email db nullable is true, struct nullable is false [W] Table gpg_key Column content db nullable is true, struct nullable is false [W] Table gpg_key_import Column content db nullable is true, struct nullable is false [W] Table public_key Column content db nullable is true, struct nullable is false [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED [W] Table project Column card_type db default is 0, struct default is [W] Table project Column card_type db nullable is false, struct nullable is true [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED [W] Table hook_task has column repo_id but struct has not related field ``` manually with these SQL statements ``` ALTER TABLE system_setting MODIFY COLUMN version INT(11) NULL DEFAULT 1; ALTER TABLE email_address MODIFY COLUMN lower_email VARCHAR(255) NOT NULL; ALTER TABLE gpg_key MODIFY COLUMN content MEDIUMTEXT NOT NULL; ALTER TABLE gpg_key_import MODIFY COLUMN content MEDIUMTEXT NOT NULL; ALTER TABLE public_key MODIFY COLUMN content MEDIUMTEXT NOT NULL; ALTER TABLE project MODIFY COLUMN board INT UNSIGNED; ALTER TABLE project MODIFY COLUMN card_type INT UNSIGNED; ALTER TABLE project MODIFY COLUMN type INT UNSIGNED; ALTER TABLE hook_task DROP COLUMN repo_id; ``` After that, I got these warnings left: ``` [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED [W] Table project column card_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED ```
GiteaMirror commented 2025-11-02 08:56:06 -06:00
Author
Owner
Copy Link

@markshep commented on GitHub (Jul 30, 2023):

Still happening with 1.20.2:

2023/07/30 16:15:44 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/07/30 16:15:44 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/07/30 16:15:44 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
@markshep commented on GitHub (Jul 30, 2023): Still happening with 1.20.2: ``` 2023/07/30 16:15:44 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2023/07/30 16:15:44 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2023/07/30 16:15:44 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true ```
GiteaMirror commented 2025-11-02 08:56:06 -06:00
Author
Owner
Copy Link

@somera commented on GitHub (Jul 30, 2023):

Gitea 1.20.2 with PostgreSQL

2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE
2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table session has column created_unix but struct has not related field
2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false
2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1
2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project column board_type db type is INTEGER, struct type is BIGINT
2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT
2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is
2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project column type db type is INTEGER, struct type is BIGINT
2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field
@somera commented on GitHub (Jul 30, 2023): Gitea 1.20.2 with PostgreSQL ``` 2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE 2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table session has column created_unix but struct has not related field 2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false 2023/07/30 17:21:16 cmd/web.go:175:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1 2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project column board_type db type is INTEGER, struct type is BIGINT 2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT 2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true 2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table project column type db type is INTEGER, struct type is BIGINT 2023/07/30 17:21:17 cmd/web.go:175:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field ```
GiteaMirror commented 2025-11-02 08:56:07 -06:00
Author
Owner
Copy Link

@johansmitsnl commented on GitHub (Aug 21, 2023):

Also on 1.20.3:

2023/08/21 11:06:42 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/08/21 11:06:42 cmd/web.go:175:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE
2023/08/21 11:06:42 cmd/web.go:175:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1
2023/08/21 11:06:43 cmd/web.go:175:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT
2023/08/21 11:06:43 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/08/21 11:06:43 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/08/21 11:06:44 cmd/web.go:175:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field
@johansmitsnl commented on GitHub (Aug 21, 2023): Also on `1.20.3`: ``` 2023/08/21 11:06:42 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2023/08/21 11:06:42 cmd/web.go:175:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE 2023/08/21 11:06:42 cmd/web.go:175:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1 2023/08/21 11:06:43 cmd/web.go:175:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT 2023/08/21 11:06:43 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2023/08/21 11:06:43 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true 2023/08/21 11:06:44 cmd/web.go:175:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field ```
GiteaMirror commented 2025-11-02 08:56:07 -06:00
Author
Owner
Copy Link

@Leontyev1003 commented on GitHub (Sep 8, 2023):

1.20.4
sqlite3

2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false
2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table user Column keep_activity_private db default is , struct default is 0
2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table user Column keep_activity_private db nullable is true, struct nullable is false
2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field
@Leontyev1003 commented on GitHub (Sep 8, 2023): 1.20.4 sqlite3 ``` 2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false 2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table user Column keep_activity_private db default is , struct default is 0 2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table user Column keep_activity_private db nullable is true, struct nullable is false 2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true 2023/09/08 14:52:39 cmd/web.go:175:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field ```
GiteaMirror commented 2025-11-02 08:56:07 -06:00
Author
Owner
Copy Link

@gaojs commented on GitHub (Dec 22, 2023):

[xorm] [warn] 2023/12/22 11:40:13.763410 Table user_info Column version db default is , struct default is 1

@gaojs commented on GitHub (Dec 22, 2023): [xorm] [warn] 2023/12/22 11:40:13.763410 Table user_info Column version db default is , struct default is 1
GiteaMirror commented 2025-11-02 08:56:07 -06:00
Author
Owner
Copy Link

@0x6d61726b commented on GitHub (Jan 6, 2024):

The same issue is present in Gitea version 1.21.3 built with GNU Make 4.3, go1.21.5 : bindata, sqlite, sqlite_unlock_notify and SQLite database:

2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table user Column keep_activity_private db default is , struct default is 0 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table user Column keep_activity_private db nullable is true, struct nullable is false 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table tracked_time Column time db nullable is true, struct nullable is false 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table webhook Column is_system_webhook db default is 0, struct default is 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table webhook Column is_system_webhook db nullable is false, struct nullable is true

@0x6d61726b commented on GitHub (Jan 6, 2024): The same issue is present in `Gitea version 1.21.3 built with GNU Make 4.3, go1.21.5 : bindata, sqlite, sqlite_unlock_notify` and SQLite database: `2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table user Column keep_activity_private db default is , struct default is 0 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table user Column keep_activity_private db nullable is true, struct nullable is false 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table tracked_time Column time db nullable is true, struct nullable is false 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table webhook Column is_system_webhook db default is 0, struct default is 2024/01/06 12:33:58 cmd/web.go:194:serveInstalled() [W] Table webhook Column is_system_webhook db nullable is false, struct nullable is true`
GiteaMirror commented 2025-11-02 08:56:08 -06:00
Author
Owner
Copy Link

@somera commented on GitHub (Jan 17, 2024):

1.21.4 with PostgreSQL

2024/01/17 09:41:13 cmd/web.go:194:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE
2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table session has column created_unix but struct has not related field
2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1
2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false
2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1
2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project column board_type db type is INTEGER, struct type is BIGINT
2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT
2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db default is 0, struct default is
2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project column type db type is INTEGER, struct type is BIGINT
2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table label Column archived_unix db default is , struct default is NULL
2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field
@somera commented on GitHub (Jan 17, 2024): 1.21.4 with PostgreSQL ``` 2024/01/17 09:41:13 cmd/web.go:194:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE 2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table session has column created_unix but struct has not related field 2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false 2024/01/17 09:41:14 cmd/web.go:194:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1 2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project column board_type db type is INTEGER, struct type is BIGINT 2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT 2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true 2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table project column type db type is INTEGER, struct type is BIGINT 2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table label Column archived_unix db default is , struct default is NULL 2024/01/17 09:41:15 cmd/web.go:194:serveInstalled() [W] Table hook_task has column repo_id but struct has not related field ```
GiteaMirror commented 2025-11-02 08:56:08 -06:00
Author
Owner
Copy Link

@yp05327 commented on GitHub (Apr 10, 2024):

image
got same warning info

@yp05327 commented on GitHub (Apr 10, 2024): ![image](https://github.com/go-gitea/gitea/assets/18380374/220631b2-1a75-475c-abad-0e92ce860208) got same warning info
GiteaMirror commented 2025-11-02 08:56:08 -06:00
Author
Owner
Copy Link

@foretix commented on GitHub (Aug 23, 2024):

image

Gitea 1.22.1, MariaDB 10.11.9, Collation utf8mb4_uca1400_as_cs

@foretix commented on GitHub (Aug 23, 2024): ![image](https://github.com/user-attachments/assets/8c161aa2-9648-459a-b058-dfa307ae6749) Gitea 1.22.1, MariaDB 10.11.9, Collation utf8mb4_uca1400_as_cs
GiteaMirror commented 2025-11-02 08:56:08 -06:00
Author
Owner
Copy Link

@Android-KitKat commented on GitHub (Nov 12, 2024):

  • Gitea 1.22.3
  • PostgreSQL 16.1
[git@localhost ~]$ gitea doctor recreate-table -c /etc/gitea/app.ini user label system_setting oauth2_application
2024/11/12 16:40:09 ...2@v2.27.2/command.go:269:Run() [I] PING DATABASE postgres
2024/11/12 16:40:10 ...igrations/base/db.go:39:func2() [I] Recreating Table: user for Bean: User
2024/11/12 16:40:10 ...igrations/base/db.go:39:func2() [I] Recreating Table: label for Bean: Label
2024/11/12 16:40:11 ...igrations/base/db.go:39:func2() [I] Recreating Table: system_setting for Bean: Setting
2024/11/12 16:40:11 ...igrations/base/db.go:39:func2() [I] Recreating Table: oauth2_application for Bean: OAuth2Application
2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE
2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table system_setting Column version db default is , struct default is 1
2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table user Column max_repo_creation db default is '-1', struct default is -1
2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table label Column archived_unix db default is , struct default is NULL
@Android-KitKat commented on GitHub (Nov 12, 2024): - Gitea `1.22.3` - PostgreSQL `16.1` ```bash [git@localhost ~]$ gitea doctor recreate-table -c /etc/gitea/app.ini user label system_setting oauth2_application 2024/11/12 16:40:09 ...2@v2.27.2/command.go:269:Run() [I] PING DATABASE postgres 2024/11/12 16:40:10 ...igrations/base/db.go:39:func2() [I] Recreating Table: user for Bean: User 2024/11/12 16:40:10 ...igrations/base/db.go:39:func2() [I] Recreating Table: label for Bean: Label 2024/11/12 16:40:11 ...igrations/base/db.go:39:func2() [I] Recreating Table: system_setting for Bean: Setting 2024/11/12 16:40:11 ...igrations/base/db.go:39:func2() [I] Recreating Table: oauth2_application for Bean: OAuth2Application 2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE 2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table system_setting Column version db default is , struct default is 1 2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table user Column max_repo_creation db default is '-1', struct default is -1 2024/11/12 16:40:11 ...2@v2.27.2/command.go:269:Run() [W] Table label Column archived_unix db default is , struct default is NULL ```
GiteaMirror commented 2025-11-02 08:56:09 -06:00
Author
Owner
Copy Link

@jleroy commented on GitHub (Jul 25, 2025):

Same issue with version 1.24.3 and Postgres:

2025/07/25 19:16:42 routers/common/db.go:24:InitDBEngine() [I] Beginning ORM engine initialization.
2025/07/25 19:16:42 routers/common/db.go:31:InitDBEngine() [I] ORM engine initialization attempt #1/10...
2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [I] PING DATABASE postgres
2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE
2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table oauth2_application Column skip_secondary_authorization db default is false, struct default is FALSE
2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1
2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false
2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1
2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT
2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table project Column card_type db default is 0, struct default is
2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table label Column archived_unix db default is , struct default is NULL
2025/07/25 19:16:43 routers/init.go:145:InitWebInstalled() [I] ORM engine initialization successful!
@jleroy commented on GitHub (Jul 25, 2025): Same issue with version `1.24.3` and Postgres: ``` 2025/07/25 19:16:42 routers/common/db.go:24:InitDBEngine() [I] Beginning ORM engine initialization. 2025/07/25 19:16:42 routers/common/db.go:31:InitDBEngine() [I] ORM engine initialization attempt #1/10... 2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [I] PING DATABASE postgres 2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table oauth2_application Column confidential_client db default is true, struct default is TRUE 2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table oauth2_application Column skip_secondary_authorization db default is false, struct default is FALSE 2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table system_setting Column version db default is , struct default is 1 2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table email_address Column lower_email db nullable is true, struct nullable is false 2025/07/25 19:16:42 cmd/web.go:207:serveInstalled() [W] Table user Column max_repo_creation db default is '-1', struct default is -1 2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table project column card_type db type is INTEGER, struct type is BIGINT 2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table project Column card_type db default is 0, struct default is 2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true 2025/07/25 19:16:43 cmd/web.go:207:serveInstalled() [W] Table label Column archived_unix db default is , struct default is NULL 2025/07/25 19:16:43 routers/init.go:145:InitWebInstalled() [I] ORM engine initialization successful! ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label type/bug type/upstream
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#10024
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?