got HTTP Error 50X page when rerun with postgresql only

[seepine]

Describe the bug

got HTTP Error 50X page when rerun with postgresql only

To Reproduce

1. deploy with docker compose

services:
  answer:
    image: apache/answer:1.7.0
    environment:
      AUTO_INSTALL: 'true'
      DB_TYPE: postgres
      DB_HOST: 172.17.0.1:5432
      DB_USERNAME: answer
      DB_PASSWORD: answer_pwd_pg
      DB_NAME: answer
      ADMIN_EMAIL: admin@example.com
      ADMIN_NAME: admin
      ADMIN_PASSWORD: 123456
      CONTACT_EMAIL: admin@example.com
      LANGUAGE: zh_CN
      SITE_NAME: Answer
      SITE_URL: https://answer.example.com
      EXTERNAL_CONTENT_DISPLAY: 'always_display'
      LOG_LEVEL: debug

    #volumes:
    #  - /root/apps/answer/uploads:/data/uploads

2. rerun got 50x

stop docker compose and rerun docker compose, got HTTP Error 50X page

3. the log

I cannot found error log

2025-12-15 16:36:26.421	DEBUG	translator/provider.go:71	try to read file: zh_TW.yaml
[auto-install] try to install by environment variable
[config-file] try to create at  /data/conf/config.yaml
[config-file] create directory success, config file is /data/conf/config.yaml
[config-file] install success
2025-12-15 16:36:26.476	WARN	install/install_controller.go:226	database is already initialized
[SUCCESS] answer installation service will run at: http://localhost:80/install/ 
2025-12-15 16:36:52.497	DEBUG	install/install_server.go:45	open static path build/static/js/3926.ad240c86.chunk.js
2025-12-15 16:36:52.497	DEBUG	install/install_server.go:45	open static path build/static/js/3926.ad240c86.chunk.js

Expected behavior

can use

Screenshots

Platform

• Device: Desktop
• OS: macOS
• Browser and version: Chrome
• Version: v1.7.0

[seepine]

I must clear all database data, this doesn't seem like the design in container cloud that a good program should have.

[seepine]

But visit post are 50X also, whether it is an example post generated by initialization or a newly created post.

https://answer.example.com/questions/10010000000000023

/usr/local/go/src/runtime/asm_amd64.s:1700 runtime.goexit
/usr/local/go/src/net/http/server.go:2092 net/http.(*conn).serve
/usr/local/go/src/net/http/server.go:3210 net/http.serverHandler.ServeHTTP
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/gin-gonic/gin/gin.go:589 github.com/gin-gonic/gin.(*Engine).ServeHTTP
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/gin-gonic/gin/gin.go:633 github.com/gin-gonic/gin.(*Engine).handleHTTPRequest
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/gin-gonic/gin/context.go:185 github.com/gin-gonic/gin.(*Context).Next
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/anargu/gin-brotli/gin_brotli.go:71 github.com/apache/answer/internal/base/server.NewHTTPServer.Brotli.func3
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/apache/answer/internal/base/middleware/auth.go:75 github.com/apache/answer/internal/base/server.NewHTTPServer.(*AuthUserMiddleware).Auth.func8
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/apache/answer/internal/base/middleware/auth.go:88 github.com/apache/answer/internal/base/server.NewHTTPServer.(*AuthUserMiddleware).EjectUserBySiteInfo.func9
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/apache/answer/internal/controller/comment_controller.go:261 github.com/apache/answer/internal/controller.(*CommentController).GetCommentWithPage
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/apache/answer/internal/service/comment/comment_service.go:399 github.com/apache/answer/internal/service/comment.(*CommentService).GetCommentWithPage
/go/src/github.com/apache/answer/answer_build1622443579/vendor/github.com/apache/answer/internal/repo/comment/comment_repo.go:112 github.com/apache/answer/internal/repo/comment.(*commentRepo).GetComment
2025-12-15 16:58:21.534	ERROR	handler/handler.go:53	code: 500, reason: base.database_error, message: , error: pq: invalid input syntax for type bigint: "null"

[shuashuai]

First, check here to see if it's the same issue?

#1426

[seepine]

@shuashuai 50x in question fixed in 1.7.1, but the problem of reinitializing 50x still exists.

[shuashuai]

@shuashuai 50x in question fixed in 1.7.1, but the problem of reinitializing 50x still exists.

Open the browser console to check for any JavaScript errors. Focus on examining network requests to see if there are any 50x server errors.

[seepine]

@shuashuai
console logs

docker logs

[shuashuai]

@shuashuai console logs

docker logs

Check whether there is an interface error in the network request？normally, there should be a supply-demand error of more than 500.
eg:

[seepine]

@shuashuai Hi has 200 204 302, not 500

[LinkinStars]

but the problem of reinitializing 50x still exists.

@seepine When reinstalling, did you encounter a 50x error on the /install page or the / root page? When reinstalling, you must ensure your database contains no data and the old configuration files must not be present. Apache Answer cannot delete any databases or tables you have created.

[seepine]

@LinkinStars Does this mean that even if I lose the /data directory but not the database, I cannot recover any data?

[seepine]

I'm not certain about the architecture design of the Answer. However, typically, the data should be divided into database storage and file storage.
In this way, even if the file storage is lost, the user data and question data should still remain, and the system should still be accessible normally. But currently, it doesn't seem to be the case.

[LinkinStars]

@seepine You may have misunderstood. Installation and recovery are two distinct scenarios. When you data loss—such as deleting the data directory—you should not attempt recovery through the installation process. Installation is solely intended to provide users with a clean environment to complete the setup.