商城功能启用后新建任何东西都报错 #199

wshlyl · 2026-06-26T03:41:47Z

wshlyl
Jun 26, 2026

halo 基本信息如：

版本: 2.25.4
构建时间: 2026-06-24 18:09
Git Commit: f16cb70
Java: OpenJDK Runtime Environment / 21.0.11+10-LTS
数据库: PostgreSQL / 18.3
操作系统: Linux / 5.14.0-587.el9.x86_64
已激活主题: microimmersion 1.5.1
已启动插件:
- 域名主题路由 1.0.0-beta1
  *** 其他插件不展示了，太多了
- 应用市场 1.17.0
  以前数据库是mysql，然后启用了商城功能，后面因为服务器调整，就改为了pgsql，换成这个pgsql后新建打开商城相关的所有页面全部报错。
  本来以为是数据有问题，商城相关的表全部清理干净，新建还是报错。
  报错内容如下：

2026-06-26T11:30:26.252+08:00 ERROR 1 --- [reactor-tcp-epoll-3] b.w.a.e.AbstractErrorWebExceptionHandler : [8a8dd8d7-1714]  500 Server Error for HTTP POST "/apis/console.api.ecommerce.halo.run/v1alpha1/payment-methods"

org.springframework.r2dbc.BadSqlGrammarException: executeMany; bad SQL grammar [INSERT INTO payment_methods (provider, scene, name, icon, config, is_enabled) VALUES ($1, $2, $3, $4, $5, $6)]
	at org.springframework.r2dbc.connection.ConnectionFactoryUtils.convertR2dbcException(ConnectionFactoryUtils.java:255) ~[spring-r2dbc-7.0.8.jar:7.0.8]
	Suppressed: The stacktrace has been enhanced by Reactor, refer to additional information below: 
Error has been observed at the following site(s):
	*__checkpoint ⇢ run.halo.app.security.InitializeRedirectionWebFilter@3722f39d
	*__checkpoint ⇢ run.halo.cache.page.PageCacheWebFilter@c2151b4
	*__checkpoint ⇢ SecurityWebFilterChainProxy [DefaultWebFilterChain]

Original Stack Trace:
		at org.springframework.r2dbc.connection.ConnectionFactoryUtils.convertR2dbcException(ConnectionFactoryUtils.java:255) ~[spring-r2dbc-7.0.8.jar:7.0.8]
		at org.springframework.r2dbc.core.DefaultDatabaseClient.lambda$inConnectionMany$3(DefaultDatabaseClient.java:156) ~[spring-r2dbc-7.0.8.jar:7.0.8]
		at reactor.core.publisher.Flux.lambda$onErrorMap$1(Flux.java:7350) ~[reactor-core-3.8.6.jar:3.8.6]
		at reactor.core.publisher.Flux.lambda$onErrorResume$0(Flux.java:7403) ~[reactor-core-3.8.6.jar:3.8.6]

Caused by: io.r2dbc.postgresql.ExceptionFactory$PostgresqlBadGrammarException: [42804] column "is_enabled" is of type smallint but expression is of type boolean
	at io.r2dbc.postgresql.ExceptionFactory.createException(ExceptionFactory.java:96) ~[r2dbc-postgresql-1.1.1.RELEASE.jar:1.1.1.RELEASE]
	at io.r2dbc.postgresql.ExceptionFactory.createException(ExceptionFactory.java:65) ~[r2dbc-postgresql-1.1.1.RELEASE.jar:1.1.1.RELEASE]
	at io.r2dbc.postgresql.ExceptionFactory.handleErrorResponse(ExceptionFactory.java:132) ~[r2dbc-postgresql-1.1.1.RELEASE.jar:1.1.1.RELEASE]