LinkinStars commented on PR #1244:
URL: https://github.com/apache/answer/pull/1244#issuecomment-2655727092

   > I have been testing the features over a Postgres database (with require 
ssl mode), but when I try to list the questions I get the following error:
   > 
   > ```
   > 2025-02-11 19:24:02.507 ERROR   handler/handler.go:53   code: 500, reason: 
base.database_error, message: , error: SQL logic error: no such column: 
linked_count (1)
   > 
C:/Users/SelimSoufargi/Desktop/Answer/answer/internal/repo/question/question_repo.go:253
 github.com/apache/answer/internal/repo/question.(*questionRepo).FindByID
   > 
C:/Users/SelimSoufargi/Desktop/Answer/answer/internal/service/question_common/question.go:210
 
github.com/apache/answer/internal/service/question_common.(*QuestionCommon).FindInfoByID
   > 
C:/Users/SelimSoufargi/Desktop/Answer/answer/internal/service/content/question_service.go:1218
 
github.com/apache/answer/internal/service/content.(*QuestionService).PersonalCollectionPage
   > 
C:/Users/SelimSoufargi/Desktop/Answer/answer/internal/controller/question_controller.go:907
 
github.com/apache/answer/internal/controller.(*QuestionController).PersonalCollectionPage
   > 
C:/Users/SelimSoufargi/go/pkg/mod/github.com/gin-gonic/[email protected]/context.go:185
 github.com/gin-gonic/gin.(*Context).Next
   > 
C:/Users/SelimSoufargi/Desktop/Answer/answer/internal/base/middleware/auth.go:168
 
github.com/apache/answer/internal/base/middleware.(*AuthUserMiddleware).MustAuthAndAccountAvailable.func1
   > 
C:/Users/SelimSoufargi/go/pkg/mod/github.com/gin-gonic/[email protected]/context.go:185
 github.com/gin-gonic/gin.(*Context).Next
   > 
C:/Users/SelimSoufargi/go/pkg/mod/github.com/anargu/[email protected]/gin_brotli.go:71
 github.com/anargu/gin-brotli.Brotli.func1
   > 
C:/Users/SelimSoufargi/go/pkg/mod/github.com/gin-gonic/[email protected]/context.go:185
 github.com/gin-gonic/gin.(*Context).Next
   > 
C:/Users/SelimSoufargi/go/pkg/mod/github.com/gin-gonic/[email protected]/gin.go:633 
github.com/gin-gonic/gin.(*Engine).handleHTTPRequest
   > 
C:/Users/SelimSoufargi/go/pkg/mod/github.com/gin-gonic/[email protected]/gin.go:589 
github.com/gin-gonic/gin.(*Engine).ServeHTTP
   > C:/Program Files/Go/src/net/http/server.go:3210 
net/http.serverHandler.ServeHTTP
   > C:/Program Files/Go/src/net/http/server.go:2092 net/http.(*conn).serve
   > C:/Program Files/Go/src/runtime/asm_amd64.s:1700 runtime.goexit
   > ```
   > 
   > Would you know if this relates to the code or the database?
   
   @unical1988 This looks like it was caused by a lack of upgrading. You can 
use the upgrade command to upgrade the version.
   
   ```
   ./answer upgrade -f v1.4.2 -C ./data/
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to