Only Full Group By Exception

[JeRoNZ]

An exception occurred while executing 'SELECT DISTINCT m0_.id AS id_0, m0_.type AS type_1, m0_.name AS name_2, m0_.custom_template AS custom_template_3, m0_.position AS position_4, m0_.defaults_output_identifier AS defaults_output_identifier_5, m0_.value_type AS value_type_6, m0_.block_value_id AS block_value_id_7, m0_.style_set_id AS style_set_id_8, m0_.area_id AS area_id_9 FROM MigrationImportBlocks m0_ WHERE m0_.value_type IN ('block') GROUP BY m0_.type ORDER BY m0_.type ASC': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'maddison_9.m0_.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I am migrating a 5.6.40 site to 9.3.9

Exported all pages, mapped content, opened another tab, added a custom block that was missing, edit map content again - exception happened. Reloaded the /migration page, and tried to map content again, same issue.

MySQL Server version: 8.0.40-0ubuntu0.20.04.1 (Ubuntu)

'driverOptions' => [
PDO::MYSQL_ATTR_INIT_COMMAND => "SET sql_mode=''"
],

in the database.php appears to fix the Exception.

Doctrine\DBAL\Exception\DriverException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php128
42
Doctrine\DBAL\Driver\AbstractMySQLDriver convertException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php182
41
Doctrine\DBAL\DBALException wrapException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php159
40
Doctrine\DBAL\DBALException driverExceptionDuringQuery
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php2226
39
Doctrine\DBAL\Connection handleExceptionDuringQuery
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php1313
38
Doctrine\DBAL\Driver\PDO\Exception
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php18
37
Doctrine\DBAL\Driver\PDO\Exception new
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php143
36
PDOException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php141
35
PDO query
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php141
34
Doctrine\DBAL\Driver\PDOConnection doQuery
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php38
33
Doctrine\DBAL\Driver\PDOConnection query
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php1309
32
Doctrine\DBAL\Connection executeQuery
…/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php31
31
Doctrine\ORM\Query\Exec\SingleSelectExecutor execute
…/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php325
30
Doctrine\ORM\Query _doExecute
…/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php1212
29
Doctrine\ORM\AbstractQuery executeIgnoreQueryCache
…/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php1166
28
Doctrine\ORM\AbstractQuery execute
…/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php901
27
Doctrine\ORM\AbstractQuery getResult
/var/www/m/maddison9/packages/migration_tool/src/PortlandLabs/Concrete5/MigrationTool/Batch/ContentMapper/Type/ComposerOutputContent.php101
26
PortlandLabs\Concrete5\MigrationTool\Batch\ContentMapper\Type\ComposerOutputContent getInstalledTargetItems
/var/www/packages/migration_tool/src/PortlandLabs/Concrete5/MigrationTool/Batch/ContentMapper/TargetItemList.php34
25
PortlandLabs\Concrete5\MigrationTool\Batch\ContentMapper\TargetItemList getMapperInstalledTargetItems
/var/www/packages/migration_tool/single_pages/dashboard/system/migration/map_content.php90
24
include
…/src/View/View.php318