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

Type: Discussion
Status: New
Minori
View Replies:

concrete5 Environment Information

# concrete5 Version
Core Version - 8.4.3
Version Installed - 8.4.3
Database Version - 20180716000000

# concrete5 Packages
Cloneamental (0.9.3), Fruitful (1.2), Fundamental (4.0.6), Manual Nav (2.2.0), Neat (0.9.2), Social Share Lite (2.1.3), Stucco (2.1.6)

# concrete5 Overrides
None

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.2.34 (Unix) mod_wsgi/3.5 Python/2.7.13 PHP/7.2.8 mod_ssl/2.2.34 OpenSSL/1.0.2o DAV/2 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_perl/2.0.9 Perl/v5.24.0

# Server API
apache2handler

# PHP Version
7.2.8

# PHP Extensions
apache2handler, bcmath, bz2, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, Reflection, session, SimpleXML, soap, sockets, sodium, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
upload_max_filesize - 32M
ldap.max_links - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.