v2.0.1: updating questions returns 5xx error: pq: invalid input syntax for type bigint: "D1jq"

[brocaar]

Describe the bug

It is no longer possible to edit questions, e.g. to update the tags. On saving the edit, I get a 500 error.

Jul 17 09:44:01 chirpstack-support answer[3653083]: 2026-07-17 09:44:01.597        ERROR        handler/handler.go:53        code: 500, reason: base.database_error, message: , error: pq: invalid input syntax for type bigint: "D1jq"
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/repo/tag/tag_rel_repo.go:200 github.com/apache/answer/internal/repo/tag.(*tagRelRepo).GetTagRelDefaultStatusByObjectID
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/service/tag_common/tag_common.go:822 github.com/apache/answer/internal/service/tag_common.(*TagCommonService).CreateOrUpdateTagRelList
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/service/tag_common/tag_common.go:737 github.com/apache/answer/internal/service/tag_common.(*TagCommonService).ObjectChangeTag
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/service/content/question_service.go:1165 github.com/apache/answer/internal/service/content.(*QuestionService).ChangeTag
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/service/content/question_service.go:1057 github.com/apache/answer/internal/service/content.(*QuestionService).UpdateQuestion
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/controller/question_controller.go:691 github.com/apache/answer/internal/controller.(*QuestionController).UpdateQuestion
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/base/middleware/auth.go:176 github.com/apache/answer/internal/base/server.NewHTTPServer.(*AuthUserMiddleware).MustAuthAndAccountAvailable.func11
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/anargu/gin-brotli/gin_brotli.go:71 github.com/apache/answer/internal/base/server.NewHTTPServer.func1.Brotli.1
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/apache/answer/internal/base/server/http.go:59 github.com/apache/answer/internal/base/server.NewHTTPServer.func1
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/gin-gonic/gin/gin.go:633 github.com/gin-gonic/gin.(*Engine).handleHTTPRequest
Jul 17 09:44:01 chirpstack-support answer[3653083]: /builddir/apache-answer-2.0.1-bin-linux-amd64/answer_build910954274/vendor/github.com/gin-gonic/gin/gin.go:589 github.com/gin-gonic/gin.(*Engine).ServeHTTP
Jul 17 09:44:01 chirpstack-support answer[3653083]: /usr/lib/go/src/net/http/server.go:3311 net/http.serverHandler.ServeHTTP
Jul 17 09:44:01 chirpstack-support answer[3653083]: /usr/lib/go/src/net/http/server.go:2073 net/http.(*conn).serve
Jul 17 09:44:01 chirpstack-support answer[3653083]: /usr/lib/go/src/runtime/asm_amd64.s:1771 runtime.goexit

To Reproduce

Steps to reproduce the behavior:

1. Update to v2.0.1
2. Edit a question
3. Try to save it

Screenshots

SEO config:

Platform

• Version: v2.0.1 / AMD64

Related

It seems this might be related to:

• Can't accept answers #1541 / fix: accept answer fails when short links enabled (#1541) #1544

[sy-records]

Could you try v2.0.2-RC2?

[brocaar]

@sy-records I just updated to v2.0.2-RC2, it does not fix the issue.

[sy-records]

OK, I've reproduced it.

[brocaar]

@sy-records thanks for the fast response to this issue. It looks like creating new questions with tags also is affected (and might be fixed by the same PR). I noticed after posting a new question, I get a 500, but the question was created, just the tags were missing.

Once merged, would you mind creating a v2.0.2-RC3 release?

[sy-records]

I can't reproduce the error that occurred when creating the question. Could you post the error stack trace?

[brocaar]

@sy-records, please see below:

Jul 17 10:32:16 chirpstack-support answer[3680777]: 2026-07-17 10:32:16.398        ERROR        handler/handler.go:53        code: 500, reason: base.database_error, message: , error: pq: invalid input syntax for type bigint: "D1nq"
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/repo/tag/tag_rel_repo.go:200 github.com/apache/answer/internal/repo/tag.(*tagRelRepo).GetTagRelDefaultStatusByObjectID
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/service/tag_common/tag_common.go:822 github.com/apache/answer/internal/service/tag_common.(*TagCommonService).CreateOrUpdateTagRelList
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/service/tag_common/tag_common.go:737 github.com/apache/answer/internal/service/tag_common.(*TagCommonService).ObjectChangeTag
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/service/content/question_service.go:1165 github.com/apache/answer/internal/service/content.(*QuestionService).ChangeTag
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/service/content/question_service.go:411 github.com/apache/answer/internal/service/content.(*QuestionService).AddQuestion
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/controller/question_controller.go:471 github.com/apache/answer/internal/controller.(*QuestionController).AddQuestion
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/base/middleware/auth.go:176 github.com/apache/answer/internal/base/server.NewHTTPServer.(*AuthUserMiddleware).MustAuthAndAccountAvailable.func12
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/anargu/gin-brotli/gin_brotli.go:71 github.com/apache/answer/internal/base/server.NewHTTPServer.func1.Brotli.1
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/base/server/http.go:63 github.com/apache/answer/internal/base/server.NewHTTPServer.func1
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/apache/answer/internal/base/middleware/recovery.go:60 github.com/apache/answer/internal/base/server.NewHTTPServer.Recovery.func4
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/gin-gonic/gin/gin.go:633 github.com/gin-gonic/gin.(*Engine).handleHTTPRequest
Jul 17 10:32:16 chirpstack-support answer[3680777]: /builddir/Answer/apache-answer-2.0.2-bin-linux-amd64/answer_build4084100097/vendor/github.com/gin-gonic/gin/gin.go:589 github.com/gin-gonic/gin.(*Engine).ServeHTTP
Jul 17 10:32:16 chirpstack-support answer[3680777]: /usr/lib/go/src/net/http/server.go:3311 net/http.serverHandler.ServeHTTP
Jul 17 10:32:16 chirpstack-support answer[3680777]: /usr/lib/go/src/net/http/server.go:2073 net/http.(*conn).serve
Jul 17 10:32:16 chirpstack-support answer[3680777]: /usr/lib/go/src/runtime/asm_amd64.s:1771 runtime.goexit

This happened when creating a question with tags. On submitting:

• I got a 500 error
• However, the question was created
• The tag associated with the question was missing

[brocaar]

I updated to RC3 and I can confirm that I can no longer reproduce the issue. Thanks 👍