SQL Exception when retrieving profile statistics
Description
Environment
MySQL 8.0.11
Activity
Show:
Former user 12 June 2018 at 23:26
@Michal Petrov I would recommend to recreate your DB.
Docs: http://docs.zanata.org/en/release/user-guide/system-admin/configuration/installation/#setting-up-the-zanata-database
`CREATE DATABASE zanata /**!40100 DEFAULT CHARACTER SET utf8 **/`
Michal Petrov 12 June 2018 at 09:59
@Former user, it's possible this is caused by some MySQL setting on my end but I'm using a default installation, the problem persists in the latest snapshot.
Former user 11 June 2018 at 22:35
Issue cannot reproduce in 4.5 and 4.6
Cannot Reproduce
Details
Details
Assignee
Unassigned
UnassignedReporter
Michal Petrov
Michal Petrov(Deactivated)Tested Version/s
None
Components
Affects versions
Priority

More fields
Time tracking
More fields
Time trackingCreated 8 June 2018 at 15:11
Updated 12 June 2018 at 23:26
Resolved 11 June 2018 at 22:35
When accessing the profile view I'm getting this exception:
16:58:11,173 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-54) Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'all_translation.lastChanged' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 16:58:11,179 ERROR [org.zanata.rest.HibernateExceptionMapper] (default task-54) Hibernate Exception in REST request: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79) at org.hibernate.loader.Loader.getResultSet(Loader.java:2117) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876) at org.hibernate.loader.Loader.doQuery(Loader.java:919) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336) at org.hibernate.loader.Loader.doList(Loader.java:2617) at org.hibernate.loader.Loader.doList(Loader.java:2600) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429) at org.hibernate.loader.Loader.list(Loader.java:2424) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:336) at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1967) at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:322) at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:125) at org.zanata.dao.TextFlowTargetHistoryDAO.getUserTranslationMatrix(TextFlowTargetHistoryDAO.java:321) …