[Unicode]   Common Locale Data Repository : Bug Tracking Home | Site Map | Search
 
Modify

CLDR Ticket #10255(accepted survey)

Opened 3 months ago

Last modified 6 weeks ago

ST: Votes by day in statistics page gives an SQL Exception

Reported by: emmons Owned by: emmons
Component: unknown Data Locale:
Phase: rc Review:
Weeks: Data Xpath:
Xref:

ticket:10314

Description

*** MESSAGE com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'surveytool.cldr_vote_value_32_beta.last_mod' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'surveytool.cldr_vote_value_32_beta.last_mod' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
*** STACK sun.reflect.GeneratedConstructorAccessor28.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
com.mysql.jdbc.Util.getInstance(Util.java:387)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
org.unicode.cldr.web.DBUtils.queryToJSONLimit(DBUtils.java:1384)
org.unicode.cldr.web.DBUtils.queryToJSON(DBUtils.java:1367)
org.unicode.cldr.web.DBUtils.queryToCachedJSON(DBUtils.java:1436)
org.unicode.cldr.web.SurveyAjax.processRequest(SurveyAjax.java:375)
org.unicode.cldr.web.SurveyAjax.doGet(SurveyAjax.java:302)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

Attachments

Change History

comment:1 Changed 3 months ago by emmons

  • Summary changed from Votes by day in statistics page gives an SQL Exception to ST: Votes by day in statistics page gives an SQL Exception

comment:2 Changed 3 months ago by emmons

  • Status changed from new to accepted
  • Priority changed from assess to minor
  • Phase changed from dsub to rc
  • Milestone changed from UNSCH to 32
  • Owner changed from anybody to srl
  • Type changed from unknown to survey

comment:3 Changed 2 months ago by srl

  • Xref set to 10314

cause of ticket:10314

comment:4 Changed 2 months ago by fredrik

  • Cc fredrik added

comment:5 Changed 2 months ago by srl

Behavior change in mysql. Full details https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
going to try to fix the SQL instead of turning on 'compatibility mode'

comment:6 Changed 7 weeks ago by emmons

  • Owner changed from srl to emmons

comment:7 Changed 6 weeks ago by mark

The symptoms are that in http://st.unicode.org/cldr-apps/v#statistics/// you don't see votes by day:

Votes by Day
Error: SQLException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'surveytool.cldr_vote_value_32.last_mod' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

View

Add a comment

Modify Ticket

Action
as accepted
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.