检查清单

• 已经在 GitHub Issues 中搜索过该问题

是什么版本出现了此问题？

1.0.8

使用的什么数据库？

SQLite3

使用的哪种方式部署？

Executable file

在线站点地址

No response

发生了什么？

服务器 腾讯云

镜像名称 OpenCloudOS

镜像类型 系统镜像

操作系统 OpenCloudOS 8.6

系统显示版本：CentOS 8.6.2205 x86_64(Py3.7.9)

版本：go1.19.4

数据库：SQLite 3.39.2

运行模式：production

启用主题：Anatole

sonic软件版本：1.0.8

以下几个错误：
1.
预览文章和预览自定义页面提示 sheetID parameter does not exisit

发布文章的时候预览 提示：服务器错误

删除标签或者清空未使用的标签，和发布文章添加2个以上的标签都会提示 Internal Server Error

发布文章添加2个以上的标签都会提示 Internal Server Error

日志页面点赞不计数，页面刷新还是归0

附件设置腾讯云，保存的时候提示错误信息，option key not exist 无法保存。

相关日志输出

2023-03-03T22:22:33.832+0800 INFO [GIN] {"beginTime": "2023-03-03T22:22:33.832+0800", "status": 200, "latency": 0.000497121, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:22:38.833+0800 INFO [GIN] {"beginTime": "2023-03-03T22:22:38.832+0800", "status": 200, "latency": 0.000504986, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:22:43.831+0800 INFO [GIN] {"beginTime": "2023-03-03T22:22:43.831+0800", "status": 200, "latency": 0.000541535, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:22:48.831+0800 INFO [GIN] {"beginTime": "2023-03-03T22:22:48.830+0800", "status": 200, "latency": 0.000611235, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:22:53.832+0800 INFO [GIN] {"beginTime": "2023-03-03T22:22:53.831+0800", "status": 200, "latency": 0.000852838, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:22:58.823+0800 INFO [GIN] {"beginTime": "2023-03-03T22:22:58.823+0800", "status": 200, "latency": 0.000488575, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:23:00.539+0800 INFO [GIN] {"beginTime": "2023-03-03T22:23:00.538+0800", "status": 200, "latency": 0.001019481, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/options/map_view"}
2023-03-03T22:23:12.199+0800 ERROR handler/server.go:229 handler error {"error": "key=api_enabled", "errorVerbose": "key=api_enabled\ngithub.com/go-sonic/sonic/util/xerr.ErrorType.New\n\tgithub.com/go-sonic/sonic/util/xerr/error.go:41\ngithub.com/go-sonic/sonic/service/impl.(*optionServiceImpl).Save\n\tgithub.com/go-sonic/sonic/service/impl/option.go:217\ngithub.com/go-sonic/sonic/handler/admin.(*OptionHandler).SaveOptionWithMap\n\tgithub.com/go-sonic/sonic/handler/admin/option.go:104\ngithub.com/go-sonic/sonic/handler.(*Server).wrapHandler.func1\n\tgithub.com/go-sonic/sonic/handler/server.go:227\ngithub.com/gin-gonic/gin.(*Context).Next\n\tgithub.com/gin-gonic/gin@v1.8.2/context.go:173\ngithub.com/go-sonic/sonic/handler/middleware.(*InstallRedirectMiddleware).InstallRedirect.func1\n\tgithub.com/go-sonic/sonic/handler/middleware/install.go:43\ngithub.com/gin-gonic/gin.(*Context).Next\n\tgithub.com/gin-gonic/gin@v1.8.2/context.go:173\ngithub.com/go-sonic/sonic/handler/middleware.(*RecoveryMiddleware).RecoveryWithLogger.func1\n\tgithub.com/go-sonic/sonic/handler/middleware/recovery.go:62\ngithub.com/gin-gonic/gin.(*Context).Next\n\tgithub.com/gin-gonic/gin@v1.8.2/context.go:173\ngithub.com/go-sonic/sonic/handler/middleware.(*GinLoggerMiddleware).LoggerWithConfig.func1\n\tgithub.com/go-sonic/sonic/handler/middleware/log.go:50\ngithub.com/gin-gonic/gin.(*Context).Next\n\tgithub.com/gin-gonic/gin@v1.8.2/context.go:173\ngithub.com/gin-gonic/gin.(*Engine).handleHTTPRequest\n\tgithub.com/gin-gonic/gin@v1.8.2/gin.go:616\ngithub.com/gin-gonic/gin.(*Engine).ServeHTTP\n\tgithub.com/gin-gonic/gin@v1.8.2/gin.go:572\nnet/http.serverHandler.ServeHTTP\n\tnet/http/server.go:2947\nnet/http.(*conn).serve\n\tnet/http/server.go:1991\nruntime.goexit\n\truntime/asm_amd64.s:1594\n\noption key not exist\n"}
2023-03-03T22:23:12.199+0800 INFO [GIN] {"beginTime": "2023-03-03T22:23:12.198+0800", "status": 400, "latency": 0.001257485, "clientIP": "120.88.205.29", "method": "POST", "path": "/api/admin/options/map_view/saving"}
2023-03-03T22:23:12.251+0800 INFO [GIN] {"beginTime": "2023-03-03T22:23:12.250+0800", "status": 200, "latency": 0.001067541, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/options/map_view"}
2023-03-03T22:23:12.317+0800 INFO [GIN] {"beginTime": "2023-03-03T22:23:12.316+0800", "status": 200, "latency": 0.00103041, "clientIP": "120.88.205.29", "method": "POST", "path": "/api/admin/options/map_view/keys"}
2023-03-03T22:23:12.349+0800 INFO [GIN] {"beginTime": "2023-03-03T22:23:12.348+0800", "status": 200, "latency": 0.000236724, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/users/profiles"}
2023-03-03T22:24:44.546+0800 INFO [GIN] {"beginTime": "2023-03-03T22:24:44.543+0800", "status": 200, "latency": 0.002933286, "clientIP": "167.248.133.185", "method": "GET", "path": "/"}
2023-03-03T22:26:27.505+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:27.505+0800", "status": 200, "latency": 0.000397015, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/themes/activation/template/custom/post"}
2023-03-03T22:26:27.506+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:27.505+0800", "status": 200, "latency": 0.000546173, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/categories?more=true"}
2023-03-03T22:26:27.507+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:27.506+0800", "status": 200, "latency": 0.00078427, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts?page=0&size=10&statuses=PUBLISHED&statuses=DRAFT&statuses=INTIMATE"}
2023-03-03T22:26:33.598+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:33.597+0800", "status": 200, "latency": 0.000852999, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts/3"}
2023-03-03T22:26:33.599+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:33.598+0800", "status": 200, "latency": 0.000274764, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/categories?more=false"}
2023-03-03T22:26:33.599+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:33.598+0800", "status": 200, "latency": 0.000532749, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/tags?sort=name%2Casc&more=true"}
2023-03-03T22:26:33.599+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:33.599+0800", "status": 200, "latency": 0.00017576, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/categories"}
2023-03-03T22:26:33.661+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:33.661+0800", "status": 200, "latency": 0.000611346, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts/comments/3/tree_view?page=0&size=10"}
2023-03-03T22:26:37.255+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:37.255+0800", "status": 200, "latency": 0.000283782, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts/comments/0/tree_view?page=0&size=10"}
2023-03-03T22:26:37.943+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:37.943+0800", "status": 200, "latency": 0.000583373, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts/3"}
2023-03-03T22:26:37.943+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:37.943+0800", "status": 200, "latency": 0.000233688, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/themes/activation/template/custom/post"}
2023-03-03T22:26:39.711+0800 INFO [GIN] {"beginTime": "2023-03-03T22:26:39.701+0800", "status": 200, "latency": 0.009345201, "clientIP": "120.88.205.29", "method": "PUT", "path": "/api/admin/posts/3/status/draft/content"}
2023-03-03T22:27:31.870+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:31.870+0800", "status": 200, "latency": 0.000377528, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/themes/activation/template/custom/post"}
2023-03-03T22:27:31.871+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:31.870+0800", "status": 200, "latency": 0.00029875, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/categories?more=true"}
2023-03-03T22:27:31.871+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:31.871+0800", "status": 200, "latency": 0.000700863, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts?page=0&size=10&statuses=PUBLISHED&statuses=DRAFT&statuses=INTIMATE"}
2023-03-03T22:27:34.288+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:34.288+0800", "status": 200, "latency": 0.000337031, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/tags?more=true"}
2023-03-03T22:27:38.878+0800 ERROR impl/tag.go:101 no such column: post_tag.tag_id [0.020ms] [rows:0] DELETE FROM tag WHERE post_tag.tag_id = 1
2023-03-03T22:27:38.878+0800 ERROR handler/server.go:229 handler error {"error": "no such column: post_tag.tag_id"}
2023-03-03T22:27:38.878+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:38.877+0800", "status": 500, "latency": 0.000739084, "clientIP": "120.88.205.29", "method": "DELETE", "path": "/api/admin/tags/1"}
2023-03-03T22:27:38.912+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:38.911+0800", "status": 200, "latency": 0.000380422, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/tags?more=true"}
2023-03-03T22:27:55.601+0800 ERROR impl/tag.go:101 no such column: post_tag.tag_id [0.021ms] [rows:0] DELETE FROM tag WHERE post_tag.tag_id = 1
2023-03-03T22:27:55.601+0800 ERROR handler/server.go:229 handler error {"error": "no such column: post_tag.tag_id"}
2023-03-03T22:27:55.601+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:55.600+0800", "status": 500, "latency": 0.000670637, "clientIP": "120.88.205.29", "method": "DELETE", "path": "/api/admin/tags/1"}
2023-03-03T22:27:55.645+0800 INFO [GIN] {"beginTime": "2023-03-03T22:27:55.645+0800", "status": 200, "latency": 0.000349695, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/tags?more=true"}
2023-03-03T22:29:51.151+0800 INFO [GIN] {"beginTime": "2023-03-03T22:29:51.150+0800", "status": 200, "latency": 0.001623893, "clientIP": "220.196.160.45", "method": "GET", "path": "/"}
2023-03-03T22:30:35.735+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:35.734+0800", "status": 200, "latency": 0.000862236, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts?page=0&size=10&statuses=PUBLISHED&statuses=DRAFT&statuses=INTIMATE"}
2023-03-03T22:30:35.735+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:35.735+0800", "status": 200, "latency": 0.000217468, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/categories?more=true"}
2023-03-03T22:30:35.736+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:35.736+0800", "status": 200, "latency": 0.000216064, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/themes/activation/template/custom/post"}
2023-03-03T22:30:36.382+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:36.382+0800", "status": 200, "latency": 0.000542256, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:30:36.383+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:36.383+0800", "status": 200, "latency": 0.000225391, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/logs/latest?top=5"}
2023-03-03T22:30:36.383+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:36.383+0800", "status": 200, "latency": 0.000231113, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/posts/latest?top=5"}
2023-03-03T22:30:41.343+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:41.343+0800", "status": 200, "latency": 0.000539721, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:30:46.849+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:46.849+0800", "status": 200, "latency": 0.000506249, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:30:51.860+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:51.860+0800", "status": 200, "latency": 0.000557354, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:30:56.853+0800 INFO [GIN] {"beginTime": "2023-03-03T22:30:56.852+0800", "status": 200, "latency": 0.000561532, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:01.850+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:01.850+0800", "status": 200, "latency": 0.000494296, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:06.858+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:06.857+0800", "status": 200, "latency": 0.000518782, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:11.860+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:11.859+0800", "status": 200, "latency": 0.000593752, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:16.845+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:16.845+0800", "status": 200, "latency": 0.000564377, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:21.852+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:21.852+0800", "status": 200, "latency": 0.000566702, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:26.850+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:26.850+0800", "status": 200, "latency": 0.000628327, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:31.857+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:31.856+0800", "status": 200, "latency": 0.000630671, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:36.851+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:36.850+0800", "status": 200, "latency": 0.000574897, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:41.858+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:41.857+0800", "status": 200, "latency": 0.000601667, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}
2023-03-03T22:31:46.854+0800 INFO [GIN] {"beginTime": "2023-03-03T22:31:46.853+0800", "status": 200, "latency": 0.000635119, "clientIP": "120.88.205.29", "method": "GET", "path": "/api/admin/statistics"}

详细日志查看最底部附件。

附加信息

设置第三方附件保存错误

预览文章错误

删除标签提示错误