15:42:37.905 [http-nio-8083-exec-3] ERROR c.r.f.w.e.GlobalExceptionHandler - [handleRuntimeException,86] - 请求地址'/api/users/admin/getBackUsersList',发生未知异常. org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: 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 ') FROM users' at line 1 ### The error may exist in com/ruoyi/chaperonebed/mapper/UsersMapper.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT COUNT() FROM users ### Cause: 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 ') FROM users' at line 1 ; bad SQL grammar []; 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 ') FROM users' at line 1
时间: 2023-08-28 09:05:25 浏览: 197
这段错误信息表示在执行SELECT COUNT() FROM users
语句时发生了语法错误,具体错误信息为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 ') FROM users' at line 1
。这可能是由于SQL语句中的语法错误导致的,可能是由于COUNT()
函数中未提供要计数的列,导致MySQL无法解析该语句。建议检查SQL语句是否正确,并确保在COUNT()
函数中提供要计数的列。
相关推荐















