Steps to Reproduce:
1) Log in to Evoke Literacy at goo.gl/xv2jqc
2) Log in as a Mentor test user (username and password are MentorLion)
3) Select Review Evidence
4) page does not display evidence
__
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('userfeed', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/eviden...', 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 =392 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('userfeed', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/eviden...', 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: 1) Log in to Evoke Literacy at goo.gl/xv2jqc 2) Log in as a Mentor test user (username and password are MentorLion) 3) Select Review Evidence 4) page does not display evidence __ 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('userfeed', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/eviden...', 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
tagstLEFT JOINevidence_tagsetON et.tag_id = t.id and et.evidence_id =392 LEFT JOINtag_translationsttON tt.tag_id = t.id LEFT JOINlanguageslON 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('userfeed', Array) #11 /var/www/html/protected/vendor/yiisoft/yii2/web/Application.php(84): yii\base\Module->runAction('missions/eviden...', 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 )