Wrong `project_board_id` for newly created issue

[bilogic]

Description

If I create an issue and add it to a project, its project_board_id is 0, but it should not be.

Instead, project_board_id should either be the value of the default board or board with lowest sorting

Gitea Version

1.21.11+9-g0e20ccfe32

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

No response

How are you running Gitea?

docker

Database

None

[wxiaoguang]

It seems a release blocker

Hmm, not a new problem, not that "blocker" .... the newly added issue should use "default board"

[lunny]

That table column name should be renamed project_column_id, #30170 is the first step to correct the names.

[lunny]

This should be caused by #29874 and will be fixed by #30696

[bilogic]

Will it be in the nightly release?

[lunny]

Will it be in the nightly release?

Yes, once it merged and I expect it can be backported to v1.22

[bilogic]

I'm on 1.22.0-rc1 now, let me know what to do to test it. Thank you.

[KazzmanK]

It is still created with 0 instead of default board ID.
Why it is not Okay ?

If i move issue to other column (board) and take it back, 0-> actual board id.

May be, having issue without actual appointments to be shown on currently default board is normal ?

[lunny]

Because v1.22, all project_issue should have a column id. 0 will not be displayed on the project board view UI. #30696 will fix this and will be backport to v1.22

[bilogic]

It is still created with 0 instead of default board ID. Why it is not Okay ?

I have not come across any project that uses 0 as a database ID, it typically starts from 1 and null if it does not have an ID