荆州港车阳河港务有限公司招聘信息-湖北-荆州市-荆州区-国企-2026-国央企正式-荆州港车阳河港务有限公司-粉笔资讯

程序出错！

org.springframework.jdbc.BadSqlGrammarException:###Errorqueryingdatabase.Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Expression#1ofORDERBYclauseisnotinGROUPBYclauseandcontainsnonaggregatedcolumn'jzg_door_prd.s.top'whichisnotfunctionallydependentoncolumnsinGROUPBYclause;thisisincompatiblewithsql_mode=only_full_group_by###Theerrormayexistin"/opt/wildfly-servlet-9.0.2.Final/standalone/deployments/purvarDoor.war/WEB-INF/classes/mybatis/mapper/mybatis-information.xml"###TheerrormayinvolveMYBATIS_MAPPER.Information.getInformationListByKeyWord-Inline###Theerroroccurredwhilesettingparameters###SQL:SELECTt.information_id,t.infor_id,t.title,t.content,t.thumbnail_id,t.source,t.read_number,t.remark,t.create_user,t.create_time,t.update_user,t.update_time,t.key_word1,t.key_word2,t.key_word3,t.key_word4,t.key_word5,t.del_flag,t.top,t.deployed_time,t.subhead,t.forward_urlFROMtbl_informationtINNERJOIN(SELECTDISTINCTmin(s.information_id)asid2FROMtbl_informationsWHERE?in(key_word1,key_word2,key_word3,key_word4,key_word5)ands.state=1ands.del_flag='N'ands.information_id!=?GROUPBYs.titleORDERBYs.topDESC,s.deployed_timedesc)aaONaa.id2=t.information_idlimit0,6###Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Expression#1ofORDERBYclauseisnotinGROUPBYclauseandcontainsnonaggregatedcolumn'jzg_door_prd.s.top'whichisnotfunctionallydependentoncolumnsinGROUPBYclause;thisisincompatiblewithsql_mode=only_full_group_by;badSQLgrammar[];nestedexceptioniscom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Expression#1ofORDERBYclauseisnotinGROUPBYclauseandcontainsnonaggregatedcolumn'jzg_door_prd.s.top'whichisnotfunctionallydependentoncolumnsinGROUPBYclause;thisisincompatiblewithsql_mode=only_full_group_by

org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:92)

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)

org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)

com.sun.proxy.$Proxy13.selectList(UnknownSource)

org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:205)

com.purvar.cm.common.dao.impl.CommonDaoImpl.selectList(CommonDaoImpl.java:179)

com.purvar.system.service.impl.InformationServiceImpl.getInformationListByKeyWord(InformationServiceImpl.java:484)

sun.reflect.GeneratedMethodAccessor146.invoke(UnknownSource)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

java.lang.reflect.Method.invoke(Method.java:606)

org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)

org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)

org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

com.sun.proxy.$Proxy29.getInformationListByKeyWord(UnknownSource)

com.purvar.front.FrontAction.newsDetail(FrontAction.java:255)

sun.reflect.GeneratedMethodAccessor139.invoke(UnknownSource)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

java.lang.reflect.Method.invoke(Method.java:606)

ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:892)

ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1294)

ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)

com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117)

com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108)

ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1370)

ognl.ASTMethod.getValueBody(ASTMethod.java:91)

ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)

ognl.SimpleNode.getValue(SimpleNode.java:258)

ognl.Ognl.getValue(Ognl.java:467)

ognl.Ognl.getValue(Ognl.java:431)

com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:352)

com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:404)

com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:350)

com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:430)

com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:290)

com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:251)

org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)