用1panel部署的dataease2.10.8,发布仪表板报错如下:
Request processing failed: org.springframework.jdbc.BadSqlGrammarException: ### Error updating 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 'ccv WHERE ccv.scene_id = 1211409259766616064 ’ at line 3 ### The error may exist in class path resource [mybatis/ExtDataVisualizationMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: DELETE FROM snapshot_core_chart_view ccv WHERE ccv.scene_id = ? and ccv.id not in ( ? ) ### 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 'ccv WHERE ccv.scene_id = 1211409259766616064 ’ at line 3 ; bad SQL grammar []
请大佬分析一下是哪里的问题
数据库需要使用 MySQL 8.0.16 版本以上数据库
多谢指导,1panel的mysql5.7不符合要求,重新离线部署,可以了。
