EFAK icon indicating copy to clipboard operation
EFAK copied to clipboard

[SQLITE_ERROR] no such function: from_unixtime

Open JCereal opened this issue 2 years ago • 0 comments

When using SQLite, the error is thrown constantly:

org.springframework.jdbc.UncategorizedSQLException: 
### Error querying database.  Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime)
### The error may exist in org/smartloli/kafka/eagle/web/dao/TopicDao.xml
### The error may involve org.smartloli.kafka.eagle.web.dao.TopicDao.queryProducerHistoryBar
### The error occurred while executing a query
### SQL: select tm,sum(new_diffval) as total from (         select tm,max(diffval) as new_diffval from ke_logsize where cluster=?                   and diffval > 0         and tm between ? and ? group by from_unixtime(timespan/1000,'%Y-%m-%d %H:%i:%s'),tm         )a group by tm
### Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime)
; uncategorized SQLException; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime); nested exception is org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such function: from_unixtime)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)

JCereal avatar Sep 27 '22 22:09 JCereal