/blade-auth/oauth/token接口请求报Unknown column 'background_url' in 'field list'

Blade 未结 1 701
jzhang
jzhang 2021-01-28 11:35
悬赏:5

一、该问题的重现步骤是什么?

1. 请求http://localhost/blade-auth/oauth/token接口,传入租户id为000000

2. 

3.


二、你期待的结果是什么?实际看到的又是什么?

期待访问200

实际报错:

Unknown column 'background_url' in 'field list'


三、你正在使用的是什么产品,什么版本?在什么操作系统上?

正在使用bladex商业版

版本2.7.1

windows操作系统


四、请提供详细的错误堆栈信息,这很重要。

### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'background_url' in 'field list'

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'background_url' in 'field list'

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)

at com.sun.proxy.$Proxy162.selectOne(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:90)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)

at com.sun.proxy.$Proxy206.selectOne(Unknown Source)

at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.getOne(ServiceImpl.java:201)

at com.baomidou.mybatisplus.extension.service.IService.getOne(IService.java:229)

at org.springblade.system.service.impl.TenantServiceImpl.getByTenantId(TenantServiceImpl.java:78)

at org.springblade.system.service.impl.TenantServiceImpl$$FastClassBySpringCGLIB$$dee53e8.invoke()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:119)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)

at org.springblade.system.service.impl.TenantServiceImpl$$EnhancerBySpringCGLIB$$40c1a6d1.getByTenantId()

at org.springblade.system.feign.SysClient.getTenant(SysClient.java:154)



五、若有更多详细信息,请在下面提供。

image.png


image.png

图3

image.png

图4

image.png

图5

image.png

1条回答
  •  admin
    admin (楼主)
    2021-01-28 13:08

    确认下你连的数据库是不是你看的那个数据库,这个明细就是数据库的表没有这个字段才报的错。


    另外业版答疑规则见:https://sns.bladex.cn/article-14990.html

    请将账号邮箱修改为下单购买授权的qq邮箱便可咨询商业版疑问

    作者追问:2021-01-28 13:08

    找到原因了,开源版和商业版用的同一套nacos

    0 讨论(0)
提交回复