Steps to Reproduce:
Log in to goo.gl/xv2jqc as "MentorLion" and use password, "MentorLion" (no quotes).
Access Review Evidences
Pick one Agent from a team
Note that the Evidences fail to load at screen bottom below Agent's statistics; the screen only shows the refresh bubbles
Error Log:
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'literacy_db_002.tt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' in /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php:840 Stack trace: #0 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(840): PDOStatement->execute() #1 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(362): yii\db\Command->queryInternal('fetchAll', NULL) #2 /var/www/html/protected/vendor/yiisoft/yii2/db/Query.php(210): yii\db\Command->queryAll() #3 /var/www/html/protected/modules/missions/widgets/WallEntry.php(29): yii\db\Query->all() #4 /var/www/html/protected/humhub/modules/content/widgets/WallEntry.php(109): humhub\modules\missions\widgets\WallEntry->run() #5 /var/www/html/protected/humhub/modules/content/components/ContentActiveRecord.php(124): humhub\modules\content\widgets\WallEntry->renderWallEntry() #6 /var/www/html/protected/modules/missions/components/actions/FixedStream.php(261): humhub\modules\content\components\ContentActiveRecord->getWallOut() #7 [internal function]: humhub\modules\missions\components\actions\FixedStream->run() #8 /var/www/html/protected/vendor/yiisoft/yii2/base/Action.php(92): call_user_func_array(Array, Array) #9 /var/www/html/protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\base\Action->runWithParams(Array) #10 /var/www/html/protected/vendor/yiisoft/yii2/base/Module.php(454): yii\base\Controller->runAction('stream', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/dashbo...', Array) #12 /var/www/html/protected/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(humhub\components\Request)) #13 /var/www/html/index.php(25): yii\base\Application->run() #14 {main} Next exception 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'literacy_db_002.tt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by The SQL being executed was: SELECT count(et.id) as 'amount', tt.title as 'translation', t.title as 'title' FROM tagst LEFT JOIN evidence_tagset ON et.tag_id = t.id and et.evidence_id =796 LEFT JOIN tag_translationstt ON tt.tag_id = t.id LEFT JOIN languagesl ON l.id = tt.language_id and l.code ="en-US" GROUP BY t.id' in /var/www/html/protected/vendor/yiisoft/yii2/db/Schema.php:628 Stack trace: #0 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(855): yii\db\Schema->convertException(Object(PDOException), 'SELECT count(et...') #1 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(362): yii\db\Command->queryInternal('fetchAll', NULL) #2 /var/www/html/protected/vendor/yiisoft/yii2/db/Query.php(210): yii\db\Command->queryAll() #3 /var/www/html/protected/modules/missions/widgets/WallEntry.php(29): yii\db\Query->all() #4 /var/www/html/protected/humhub/modules/content/widgets/WallEntry.php(109): humhub\modules\missions\widgets\WallEntry->run() #5 /var/www/html/protected/humhub/modules/content/components/ContentActiveRecord.php(124): humhub\modules\content\widgets\WallEntry->renderWallEntry() #6 /var/www/html/protected/modules/missions/components/actions/FixedStream.php(261): humhub\modules\content\components\ContentActiveRecord->getWallOut() #7 [internal function]: humhub\modules\missions\components\actions\FixedStream->run() #8 /var/www/html/protected/vendor/yiisoft/yii2/base/Action.php(92): call_user_func_array(Array, Array) #9 /var/www/html/protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\base\Action->runWithParams(Array) #10 /var/www/html/protected/vendor/yiisoft/yii2/base/Module.php(454): yii\base\Controller->runAction('stream', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/dashbo...', Array) #12 /var/www/html/protected/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(humhub\components\Request)) #13 /var/www/html/index.php(25): yii\base\Application->run() #14 {main} Additional Information: Array ( [0] => 42000 [1] => 1055 [2] => Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'literacy_db_002.tt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by )
Steps to Reproduce: Log in to goo.gl/xv2jqc as "MentorLion" and use password, "MentorLion" (no quotes). Access Review Evidences Pick one Agent from a team Note that the Evidences fail to load at screen bottom below Agent's statistics; the screen only shows the refresh bubbles
Error Log:
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'literacy_db_002.tt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' in /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php:840 Stack trace: #0 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(840): PDOStatement->execute() #1 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(362): yii\db\Command->queryInternal('fetchAll', NULL) #2 /var/www/html/protected/vendor/yiisoft/yii2/db/Query.php(210): yii\db\Command->queryAll() #3 /var/www/html/protected/modules/missions/widgets/WallEntry.php(29): yii\db\Query->all() #4 /var/www/html/protected/humhub/modules/content/widgets/WallEntry.php(109): humhub\modules\missions\widgets\WallEntry->run() #5 /var/www/html/protected/humhub/modules/content/components/ContentActiveRecord.php(124): humhub\modules\content\widgets\WallEntry->renderWallEntry() #6 /var/www/html/protected/modules/missions/components/actions/FixedStream.php(261): humhub\modules\content\components\ContentActiveRecord->getWallOut() #7 [internal function]: humhub\modules\missions\components\actions\FixedStream->run() #8 /var/www/html/protected/vendor/yiisoft/yii2/base/Action.php(92): call_user_func_array(Array, Array) #9 /var/www/html/protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\base\Action->runWithParams(Array) #10 /var/www/html/protected/vendor/yiisoft/yii2/base/Module.php(454): yii\base\Controller->runAction('stream', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/dashbo...', Array) #12 /var/www/html/protected/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(humhub\components\Request)) #13 /var/www/html/index.php(25): yii\base\Application->run() #14 {main} Next exception 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'literacy_db_002.tt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by The SQL being executed was: SELECT count(et.id) as 'amount', tt.title as 'translation', t.title as 'title' FROM
tags
t
LEFT JOINevidence_tags
et
ON et.tag_id = t.id and et.evidence_id =796 LEFT JOINtag_translations
tt
ON tt.tag_id = t.id LEFT JOINlanguages
l
ON l.id = tt.language_id and l.code ="en-US" GROUP BYt
.id
' in /var/www/html/protected/vendor/yiisoft/yii2/db/Schema.php:628 Stack trace: #0 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(855): yii\db\Schema->convertException(Object(PDOException), 'SELECT count(et...') #1 /var/www/html/protected/vendor/yiisoft/yii2/db/Command.php(362): yii\db\Command->queryInternal('fetchAll', NULL) #2 /var/www/html/protected/vendor/yiisoft/yii2/db/Query.php(210): yii\db\Command->queryAll() #3 /var/www/html/protected/modules/missions/widgets/WallEntry.php(29): yii\db\Query->all() #4 /var/www/html/protected/humhub/modules/content/widgets/WallEntry.php(109): humhub\modules\missions\widgets\WallEntry->run() #5 /var/www/html/protected/humhub/modules/content/components/ContentActiveRecord.php(124): humhub\modules\content\widgets\WallEntry->renderWallEntry() #6 /var/www/html/protected/modules/missions/components/actions/FixedStream.php(261): humhub\modules\content\components\ContentActiveRecord->getWallOut() #7 [internal function]: humhub\modules\missions\components\actions\FixedStream->run() #8 /var/www/html/protected/vendor/yiisoft/yii2/base/Action.php(92): call_user_func_array(Array, Array) #9 /var/www/html/protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\base\Action->runWithParams(Array) #10 /var/www/html/protected/vendor/yiisoft/yii2/base/Module.php(454): yii\base\Controller->runAction('stream', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/dashbo...', Array) #12 /var/www/html/protected/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(humhub\components\Request)) #13 /var/www/html/index.php(25): yii\base\Application->run() #14 {main} Additional Information: Array ( [0] => 42000 [1] => 1055 [2] => Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'literacy_db_002.tt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by )