删除和发布操作都会包这个数据错误，只能预览没法发布

DataEase
1
  • 问问题请带上 DataEase 版本信息、安装部署方式信息、详细错误信息，减少不必要的来回沟通！
  • 不要重复发帖！
    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 MariaDB server version for the right syntax to use near ‘dvi WHERE dvi.id IN ( …’ at line 4 ### 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 data_visualization_info dvi WHERE dvi.id IN ( ? ) ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘dvi WHERE dvi.id IN ( …’ at line 4 ; bad SQL grammar []
2

您是用外部数据库安装的吗?外部的话需要MySQL版本在8.0.16版本以上