NutzCN Logo
问答 mysql5.7之后开始支持json数据格式类型 保存数据的时候报如下错误
发布于 249天前 作者 Rekoe 858 次浏览 复制 上一个帖子 下一个帖子
标签:

org.nutz.dao.DaoException: !Nutz SQL Error: 'UPDATE mumshop_product SET pid=576898202150,name='CW-0114-DAMAOXIAN',url='https://detail.1688.com/offer/576898202150.html',shop_url='https://shop1470675225377.1688.com',price=38000.0,original_price=50000.0,images='["https://rk-cdn.oss-cn-hongkong.aliyuncs.com/cache/upload/2020/0114/20200114162035.jpg"]',time='2020-01-15 05:27:38',type='YDUCKMM',category=204,is_pushed=true,is_translated=false,props='["颜色"]',status=1,is_deleted=false,push_time='2020-01-15 05:27:38',provider_id=922,size_status=0,image_index=0,sort=1000000 WHERE id='7213524845999423488'' PreparedStatement: 'UPDATE mumshop_product SET pid=?,name=?,url=?,shop_url=?,price=?,original_price=?,images=?,time=?,type=?,category=?,is_pushed=?,is_translated=?,props=?,status=?,is_deleted=?,push_time=?,provider_id=?,size_status=?,image_index=?,sort=? WHERE id=?' CaseMessage=Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'. at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:110) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:65) at org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:23) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63) at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63) at org.nutz.plugins.cache.dao.DaoCacheInterceptor._exec(DaoCacheInterceptor.java:28) at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:188) at org.nutz.plugins.cache.dao.DaoCacheInterceptor.filter(DaoCacheInterceptor.java:18) at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63) at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:138) at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:163) at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:130) at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:97) at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:86) at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:242) at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:254) at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:58) at org.nutz.dao.impl.NutDao.update(NutDao.java:275) at com.kunnit.cloud.web.module.ApiModule.t(ApiModule.java:345)

这个问题有解决办法么?

0 回复
添加回复
请先登陆
回到顶部