我在本地的数据库测试的统计昨天的销量详情没一点问题，可是当我测试远程服务器数据库时就报如下错误，貌似提示我SQL语法错误，可是我把SQL语句粘贴到远程数据库执行没一点问题，能添加成功，就是用junit测试时报错，本地数据库junit也正常插入数据，就是远程的数据库不行，麻烦老师看一下吧
org.springframework.jdbc.BadSqlGrammarException:

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘o2o.tb_user_product_map.shop_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The error may involve com.imooc.o2o.dao.ProductSellDailyDao.insertProductSellDaily-Inline

The error occurred while setting parameters

SQL: INSERT INTO tb_product_sell_daily(product_id,shop_id,create_time,total) ( SELECT product_id,shop_id,date_format(create_time,’%Y-%m-%d’),count(product_id) AS total FROM tb_user_product_map WHERE date_format(create_time,’%Y-%m-%d’) = date_sub(curdate(),interval 1 day) GROUP BY product_id)

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘o2o.tb_user_product_map.shop_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

; bad SQL grammar []; nested exception IS com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘o2o.tb_user_product_map.shop_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
AT org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:91)
AT org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
AT org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
AT org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
AT org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)ATcom.sun.proxy.$Proxy72.insert(UNKNOWN Source)
AT org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
AT org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57)
AT org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
AT com.sun.proxy.$Proxy73.insertProductSellDaily(UNKNOWN Source)
AT com.imooc.o2o.dao.ProductSellDailyDaoTest.testAInsertProductSellDaily(ProductSellDailyDaoTest.java:34)
AT sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
AT sun.reflect.NativeMethodAccessorImpl.invoke(UNKNOWN Source)
AT sun.reflect.DelegatingMethodAccessorImpl.invoke(UNKNOWN Source)
AT java.lang.reflect.Method.invoke(UNKNOWN Source)
AT org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
AT org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
AT org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
AT org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
AT org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
AT org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
AT org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
AT org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
AT org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)
AT org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
AT org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
AT org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
AT org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
AT org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
AT org.junit.runners.ParentRunnerKaTeX parse error: Expected 'EOF', got '#' at position 1090: …on: Expression #̲2 of SELECT lis…Proxy109.execute(UNKNOWN Source)
AT org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
AT org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
AT org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
AT org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
AT org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
AT org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
AT org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
AT sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
AT sun.reflect.NativeMethodAccessorImpl.invoke(UNKNOWN Source)
AT sun.reflect.DelegatingMethodAccessorImpl.invoke(UNKNOWN Source)
AT java.lang.reflect.Method.invoke(UNKNOWN Source)
AT org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
… 35 more