An Error occurred
Permalink Browser Info Environment
Hi I purchase the fundamental and use it yesterday, l inserted the slick slide bbutton and then cannot enter my page because of this error.
What should I do next?
Plwase send me some message.
Doctrine\DBAL\Exception\DriverException thrown with message "An exception occurred while executing 'SELECT distinct n.treeNodeID, if(nt.treeNodeTypeHandle='file', fv.fvTitle, n.treeNodeName) as folderItemName, if(nt.treeNodeTypeHandle='file', fv.fvDateAdded, n.dateModified) as folderItemModified, case when nt.treeNodeTypeHandle='search_preset' then 1 when nt.treeNodeTypeHandle='file_folder' then 2 else (10 + fvType) end as folderItemType, fv.fvSize as folderItemSize FROM TreeNodes n INNER JOIN TreeNodeTypes nt ON nt.treeNodeTypeID = n.treeNodeTypeID LEFT JOIN TreeFileNodes tf ON tf.treeNodeID = n.treeNodeID LEFT JOIN FileVersions fv ON tf.fID = fv.fID and fv.fvIsApproved = 1 LEFT JOIN FileSearchIndexAttributes fis ON fv.fID = fis.fID WHERE n.treeNodeParentID = ? ORDER BY fv.fvTitle asc LIMIT 20 OFFSET 0' with params ["7"]:
SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'c5test01.fv.fvTitle' which is not in SELECT list; this is incompatible with DISTINCT"
Stacktrace:
#50 Doctrine\DBAL\Exception\DriverException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
#49 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#48 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#47 Doctrine\DBAL\Driver\PDOException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107
#46 PDOException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#45 PDOStatement:execute in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#44 Doctrine\DBAL\Driver\PDOStatement:execute in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:847
#43 Doctrine\DBAL\Connection:executeQuery in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:206
#42 Doctrine\DBAL\Query\QueryBuilder:execute in /Applications/MAMP/htdocs/c5test01/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Adapter/DoctrineDbalAdapter.php:73
#41 Pagerfanta\Adapter\DoctrineDbalAdapter:getSlice in /Applications/MAMP/htdocs/c5test01/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:319
#40 Pagerfanta\Pagerfanta:getCurrentPageResultsFromAdapter in /Applications/MAMP/htdocs/c5test01/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:303
#39 Pagerfanta\Pagerfanta:getCurrentPageResults in /Applications/MAMP/htdocs/c5test01/concrete/src/Search/Pagination/Pagination.php:111
#38 Concrete\Core\Search\Pagination\Pagination:getCurrentPageResults in /Applications/MAMP/htdocs/c5test01/concrete/blocks/document_library/controller.php:738
#37 Concrete\Block\DocumentLibrary\Controller:view in /Applications/MAMP/htdocs/c5test01/concrete/src/Controller/AbstractController.php:294
#36 call_user_func_array in /Applications/MAMP/htdocs/c5test01/concrete/src/Controller/AbstractController.php:294
#35 Concrete\Core\Controller\AbstractController:runAction in /Applications/MAMP/htdocs/c5test01/concrete/src/Block/View/BlockView.php:469
#34 Concrete\Core\Block\View\BlockView:runControllerTask in /Applications/MAMP/htdocs/c5test01/concrete/src/Block/View/BlockView.php:153
#33 Concrete\Core\Block\View\BlockView:setupRender in /Applications/MAMP/htdocs/c5test01/concrete/src/View/AbstractView.php:148
#32 Concrete\Core\View\AbstractView:render in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Area.php:876
#31 Concrete\Core\Area\Area:display in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Layout/Column.php:210
#30 Concrete\Core\Area\Layout\Column:display in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Layout/Column.php:168
#29 Concrete\Core\Area\Layout\Column:getContents in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Layout/ThemeGridColumn.php:134
#28 Concrete\Core\Area\Layout\ThemeGridColumn:getColumnHtmlObject in /Applications/MAMP/htdocs/c5test01/concrete/blocks/core_area_layout/view.php:7
#27 include in /Applications/MAMP/htdocs/c5test01/concrete/src/Block/View/BlockView.php:277
#26 Concrete\Core\Block\View\BlockView:renderViewContents in /Applications/MAMP/htdocs/c5test01/concrete/src/View/AbstractView.php:151
#25 Concrete\Core\View\AbstractView:render in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Area.php:876
#24 Concrete\Core\Area\Area:display in /Applications/MAMP/htdocs/c5test01/packages/fundamental/themes/fundamental/custom.php:11
#23 include in /Applications/MAMP/htdocs/c5test01/concrete/src/View/View.php:254
#22 Concrete\Core\View\View:renderTemplate in /Applications/MAMP/htdocs/c5test01/concrete/src/View/View.php:216
#21 Concrete\Core\View\View:renderViewContents in /Applications/MAMP/htdocs/c5test01/concrete/src/View/AbstractView.php:151
#20 Concrete\Core\View\AbstractView:render in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/ResponseFactory.php:148
#19 Concrete\Core\Http\ResponseFactory:view in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/ResponseFactory.php:215
#18 Concrete\Core\Http\ResponseFactory:controller in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/ResponseFactory.php:393
#17 Concrete\Core\Http\ResponseFactory:collection in /Applications/MAMP/htdocs/c5test01/concrete/src/Routing/DispatcherRouteCallback.php:34
#16 Concrete\Core\Routing\DispatcherRouteCallback:execute in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/DefaultDispatcher.php:130
#15 Concrete\Core\Http\DefaultDispatcher:handleDispatch in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/DefaultDispatcher.php:57
#14 Concrete\Core\Http\DefaultDispatcher:dispatch in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/DispatcherDelegate.php:39
#13 Concrete\Core\Http\Middleware\DispatcherDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/ThumbnailMiddleware.php:71
#12 Concrete\Core\Http\Middleware\ThumbnailMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#11 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/FrameOptionsMiddleware.php:39
#10 Concrete\Core\Http\Middleware\FrameOptionsMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#9 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/CookieMiddleware.php:37
#8 Concrete\Core\Http\Middleware\CookieMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#7 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/ApplicationMiddleware.php:29
#6 Concrete\Core\Http\Middleware\ApplicationMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#5 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareStack.php:86
#4 Concrete\Core\Http\Middleware\MiddlewareStack:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/DefaultServer.php:85
#3 Concrete\Core\Http\DefaultServer:handleRequest in /Applications/MAMP/htdocs/c5test01/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:119
#2 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /Applications/MAMP/htdocs/c5test01/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#1 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /Applications/MAMP/htdocs/c5test01/concrete/dispatcher.php:36
#0 require in /Applications/MAMP/htdocs/c5test01/index.php:3
What should I do next?
Plwase send me some message.
Doctrine\DBAL\Exception\DriverException thrown with message "An exception occurred while executing 'SELECT distinct n.treeNodeID, if(nt.treeNodeTypeHandle='file', fv.fvTitle, n.treeNodeName) as folderItemName, if(nt.treeNodeTypeHandle='file', fv.fvDateAdded, n.dateModified) as folderItemModified, case when nt.treeNodeTypeHandle='search_preset' then 1 when nt.treeNodeTypeHandle='file_folder' then 2 else (10 + fvType) end as folderItemType, fv.fvSize as folderItemSize FROM TreeNodes n INNER JOIN TreeNodeTypes nt ON nt.treeNodeTypeID = n.treeNodeTypeID LEFT JOIN TreeFileNodes tf ON tf.treeNodeID = n.treeNodeID LEFT JOIN FileVersions fv ON tf.fID = fv.fID and fv.fvIsApproved = 1 LEFT JOIN FileSearchIndexAttributes fis ON fv.fID = fis.fID WHERE n.treeNodeParentID = ? ORDER BY fv.fvTitle asc LIMIT 20 OFFSET 0' with params ["7"]:
SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'c5test01.fv.fvTitle' which is not in SELECT list; this is incompatible with DISTINCT"
Stacktrace:
#50 Doctrine\DBAL\Exception\DriverException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
#49 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#48 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#47 Doctrine\DBAL\Driver\PDOException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107
#46 PDOException in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#45 PDOStatement:execute in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#44 Doctrine\DBAL\Driver\PDOStatement:execute in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:847
#43 Doctrine\DBAL\Connection:executeQuery in /Applications/MAMP/htdocs/c5test01/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:206
#42 Doctrine\DBAL\Query\QueryBuilder:execute in /Applications/MAMP/htdocs/c5test01/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Adapter/DoctrineDbalAdapter.php:73
#41 Pagerfanta\Adapter\DoctrineDbalAdapter:getSlice in /Applications/MAMP/htdocs/c5test01/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:319
#40 Pagerfanta\Pagerfanta:getCurrentPageResultsFromAdapter in /Applications/MAMP/htdocs/c5test01/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php:303
#39 Pagerfanta\Pagerfanta:getCurrentPageResults in /Applications/MAMP/htdocs/c5test01/concrete/src/Search/Pagination/Pagination.php:111
#38 Concrete\Core\Search\Pagination\Pagination:getCurrentPageResults in /Applications/MAMP/htdocs/c5test01/concrete/blocks/document_library/controller.php:738
#37 Concrete\Block\DocumentLibrary\Controller:view in /Applications/MAMP/htdocs/c5test01/concrete/src/Controller/AbstractController.php:294
#36 call_user_func_array in /Applications/MAMP/htdocs/c5test01/concrete/src/Controller/AbstractController.php:294
#35 Concrete\Core\Controller\AbstractController:runAction in /Applications/MAMP/htdocs/c5test01/concrete/src/Block/View/BlockView.php:469
#34 Concrete\Core\Block\View\BlockView:runControllerTask in /Applications/MAMP/htdocs/c5test01/concrete/src/Block/View/BlockView.php:153
#33 Concrete\Core\Block\View\BlockView:setupRender in /Applications/MAMP/htdocs/c5test01/concrete/src/View/AbstractView.php:148
#32 Concrete\Core\View\AbstractView:render in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Area.php:876
#31 Concrete\Core\Area\Area:display in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Layout/Column.php:210
#30 Concrete\Core\Area\Layout\Column:display in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Layout/Column.php:168
#29 Concrete\Core\Area\Layout\Column:getContents in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Layout/ThemeGridColumn.php:134
#28 Concrete\Core\Area\Layout\ThemeGridColumn:getColumnHtmlObject in /Applications/MAMP/htdocs/c5test01/concrete/blocks/core_area_layout/view.php:7
#27 include in /Applications/MAMP/htdocs/c5test01/concrete/src/Block/View/BlockView.php:277
#26 Concrete\Core\Block\View\BlockView:renderViewContents in /Applications/MAMP/htdocs/c5test01/concrete/src/View/AbstractView.php:151
#25 Concrete\Core\View\AbstractView:render in /Applications/MAMP/htdocs/c5test01/concrete/src/Area/Area.php:876
#24 Concrete\Core\Area\Area:display in /Applications/MAMP/htdocs/c5test01/packages/fundamental/themes/fundamental/custom.php:11
#23 include in /Applications/MAMP/htdocs/c5test01/concrete/src/View/View.php:254
#22 Concrete\Core\View\View:renderTemplate in /Applications/MAMP/htdocs/c5test01/concrete/src/View/View.php:216
#21 Concrete\Core\View\View:renderViewContents in /Applications/MAMP/htdocs/c5test01/concrete/src/View/AbstractView.php:151
#20 Concrete\Core\View\AbstractView:render in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/ResponseFactory.php:148
#19 Concrete\Core\Http\ResponseFactory:view in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/ResponseFactory.php:215
#18 Concrete\Core\Http\ResponseFactory:controller in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/ResponseFactory.php:393
#17 Concrete\Core\Http\ResponseFactory:collection in /Applications/MAMP/htdocs/c5test01/concrete/src/Routing/DispatcherRouteCallback.php:34
#16 Concrete\Core\Routing\DispatcherRouteCallback:execute in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/DefaultDispatcher.php:130
#15 Concrete\Core\Http\DefaultDispatcher:handleDispatch in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/DefaultDispatcher.php:57
#14 Concrete\Core\Http\DefaultDispatcher:dispatch in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/DispatcherDelegate.php:39
#13 Concrete\Core\Http\Middleware\DispatcherDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/ThumbnailMiddleware.php:71
#12 Concrete\Core\Http\Middleware\ThumbnailMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#11 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/FrameOptionsMiddleware.php:39
#10 Concrete\Core\Http\Middleware\FrameOptionsMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#9 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/CookieMiddleware.php:37
#8 Concrete\Core\Http\Middleware\CookieMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#7 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/ApplicationMiddleware.php:29
#6 Concrete\Core\Http\Middleware\ApplicationMiddleware:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareDelegate.php:38
#5 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/Middleware/MiddlewareStack.php:86
#4 Concrete\Core\Http\Middleware\MiddlewareStack:process in /Applications/MAMP/htdocs/c5test01/concrete/src/Http/DefaultServer.php:85
#3 Concrete\Core\Http\DefaultServer:handleRequest in /Applications/MAMP/htdocs/c5test01/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:119
#2 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /Applications/MAMP/htdocs/c5test01/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#1 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /Applications/MAMP/htdocs/c5test01/concrete/dispatcher.php:36
#0 require in /Applications/MAMP/htdocs/c5test01/index.php:3
Type: | Discussion |
---|---|
Status: | New |