SQL Exception when retrieving profile statistics

Description

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)

Environment

MySQL 8.0.11

Activity

Show:

Former user 12 June 2018 at 23:26

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

, 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

Assignee

Reporter

Tested Version/s

Components

Affects versions

Priority

More fields

Created 8 June 2018 at 15:11
Updated 12 June 2018 at 23:26
Resolved 11 June 2018 at 22:35

Flag notifications