エラーが発生し対処の仕方がわかりません。

2018年11月3日 at 7:42

お世話になります。
初歩的な質問かもしれませんが、エラーが発生しサイトに入れない状態です。。

こちらはどういった種類のエラーでしょうか?
また、対処の仕方がわかる方はいらっしゃいますでしょうか。
お手数お掛けいたしますが、よろしくお願いいたします。

・MAC/OSバージョン:10.11.6
・concrete5バージョン 8.4.3
・MAMP使用
・環境情報
# 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 - no value
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

・エラー内容
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

タグ:

Re: エラーが発生し対処の仕方がわかりません。

2019年3月5日 at 14:50
お疲れ様です。
私も同じエラーになってしまいました。

そうやらドキュメントライブラリに問題があるようです。
8.4.2か8.4.3で起きるようです。
http://github.com/concrete5/concrete5/issues/7311

回避策も記載がありましたがさくらインターネットの環境では変数の変更ができずお手上げ状態です。
どなたか他の回避策をご存じないでしょうか?