225 Star 975 Fork 425

欧福 / ofcms

 / 详情

新增公告失败

Done
Opened this issue  
2018-12-20 16:44

新增公告,提示处理失败请稍后重试,后台显示

2018-12-20 15:48:20 Thread:http-nio-8080-exec-5-com.alibaba.druid.filter.logging.Log4jFilter.statementLogError(): {conn-10001, pstmt-20042} execute error. 	insert into of_sys_announce (
		 	 title, 
		 	 content, 
		 	 type, 
		 	 user_id, 
		 	 create_time, 
		 	 sort, 
		 	 remark, 
		 	 status 
	) values(
		 	 ?, 
		 	 ?, 
		 	 ?, 
		 	 ?, 
		 	 now(), 
		 	 ?, 
		 	 ?, 
		 	 '1' 
	)

java.sql.SQLException: Field 'release_terminal' doesn't have a default value
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2723)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1070)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2721)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1070)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2721)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1070)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2721)
	at com.alibaba.druid.wall.WallFilter.preparedStatement_executeUpdate(WallFilter.java:616)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2721)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1070)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2721)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:145)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:253)
	at com.jfinal.plugin.activerecord.DbPro.update(DbPro.java:285)
	at com.jfinal.plugin.activerecord.DbPro.update(DbPro.java:302)
	at com.jfinal.plugin.activerecord.DbPro.update(DbPro.java:1248)
	at com.jfinal.plugin.activerecord.Db.update(Db.java:652)
	at com.ofsoft.cms.admin.controller.ComnController.update(ComnController.java:80)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:73)
	at com.ofsoft.cms.core.spring.IocInterceptor.intercept(IocInterceptor.java:41)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
	at com.jfinal.weixin.sdk.jfinal.ApiInterceptor.intercept(ApiInterceptor.java:21)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
	at com.jfinal.ext.interceptor.SessionInViewInterceptor.intercept(SessionInViewInterceptor.java:44)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
	at com.ofsoft.cms.core.plugin.shiro.ShiroInterceptor.intercept(ShiroInterceptor.java:60)
	at com.jfinal.aop.Invocation.invoke(Invocation.java:67)
	at com.jfinal.core.ActionHandler.handle(ActionHandler.java:82)
	at com.ofsoft.cms.core.handler.WebSocketHandler.handle(WebSocketHandler.java:14)
	at com.jfinal.plugin.druid.DruidStatViewHandler.handle(DruidStatViewHandler.java:75)
	at com.ofsoft.cms.core.handler.ActionHandler.handle(ActionHandler.java:48)
	at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:73)
com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Field 'release_terminal' doesn't have a default value

Comments (1)

青稚 createdtask
luoyafeng set assignee to luoyafeng
luoyafeng added
 
bug
label
luoyafeng set branch to
luoyafeng set deadline to 2018-12-21
luoyafeng set start time to 2018-12-20
luoyafeng changed deadline from 2018-12-21 to 2018-12-20
luoyafeng set priority to Main
Expand operation logs

修改"通知管理"的"增加"sql

输入图片说明
增加"release_terminal"字段,并且赋值默认为"1".
已更新上传最新代码,可自行修改或下载最新项目。

luoyafeng changed issue state from 待办的 to 已完成
luoyafeng changed branch from 1.1 to not link

Sign in to comment

Status
Assignees
Milestones
Pull Requests
Successfully merging a pull request will close this issue.
Branches
Planed to start   -   Planed to end
-
Top level
Priority
参与者(2)
1576753 examsystem 1578954987
Java
1
https://gitee.com/oufu/ofcms.git
git@gitee.com:oufu/ofcms.git
oufu
ofcms
ofcms

Search

344bd9b3 5694891 D2dac590 5694891