一、该问题的重现步骤是什么?
1. 我用的是2.5的,现在登入的用户不是你们user表的用户,是自己新建表的用户。 然后没有角色id ,执行任何sql都报错,
3.
二、你期待的结果是什么?实际看到的又是什么?
我只想普普通通的执行我写的sql,不要给我拦截数据权限
三、你正在使用的是什么产品,什么版本?在什么操作系统上?
用的2.5 ,在win10上
四、请提供详细的错误堆栈信息,这很重要。
axios.js?b5c6:69 Uncaught (in promise) Error: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in ())]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1
### The error may exist in file [F:\workspace\jnds\bladex-boot\target\classes\org\springblade\common\utils\keyValue\mapper\KeyValueMapper.xml]
### The error may involve org.springblade.common.utils.keyValue.mapper.KeyValueMapper.getKeyValueList
### The error occurred while executing a query
### Cause: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in ())]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1
五、若有更多详细信息,请在下面提供。
扫一扫访问 Blade技术社区 移动端