Forums

8.3.1 post upgrade error

Permalink
once I updated to 8.3.1, I'm getting the below error 

Doctrine\DBAL\Exception\DriverException thrown with message "An exception occurred while executing 'SELECT distinct p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID INNER JOIN CollectionAttributeValues cavTopics ON cv.cID = cavTopics.cID and cv.cvID = cavTopics.cvID INNER JOIN AttributeValues av ON cavTopics.avID = av.avID INNER JOIN atSelectedTopics atst ON av.avID = atst.avID WHERE (cvName != ?) AND (pt.ptID = ?) AND (atst.treeNodeID = ?) AND (ak_exclude_page_list <> 1 or ak_exclude_page_list is null) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND ((cvPublishDate <= ? or cvPublishDate is null)) AND (p.cIsActive = ?) AND (p.siteTreeID = ?) AND (p.cIsSystemPage = ?) ORDER BY cv.cvDatePublic desc LIMIT 5 OFFSET 0' with params ["", "7", 34, "2017-12-24 17:15:31", true, 1, false]:
SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'DB_NAME.cv.cvDatePublic' which is not in SELECT list; this is incompatible with DISTINCT"
Stacktrace:
#43 Doctrine\DBAL\Exception\DriverException in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
#42 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#41 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#40 Doctrine\DBAL\Driver\PDOException in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107
#39 PDOException in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#38 PDOStatement:execute in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#37 Doctrine\DBAL\Driver\PDOStatement:execute in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:847
#36 Doctrine\DBAL\Connection:executeQuery in /var/www/******/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:206
#35 Doctrine\DBAL\Query\QueryBuilder:execute in /var/www/******/public_html/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Adapter/DoctrineDbalAdapter.php:73
#34 Pagerfanta\Adapter\DoctrineDbalAdapter:getSlice in /var/www/******/public_html/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:319
#33 Pagerfanta\Pagerfanta:getCurrentPageResultsFromAdapter in /var/www/******/public_html/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:303
#32 Pagerfanta\Pagerfanta:getCurrentPageResults in /var/www/******/public_html/concrete/src/Search/Pagination/Pagination.php:111
Viewing 15 lines of 47 lines. View entire code block.



Any idea?
 
Ta2Ta2 replied on at Permalink Reply
Found the issue, it is the mysql 5.7+ strict mode..

by disabling the strict mode, all went well.