Control panel - Manage media bug?

[ddrury]

File app/services/MediaFileService.php was changed in commit 83c3c27 where line 333 was changed from
->pluck(new Expression("COALESCE(setting_value, 'media/') || multimedia_file_refn AS path"))
to
->pluck(new Expression("COALESCE(setting_value, 'media/') || multimedia_file_refn"))
this causes the following exception

NOTE: haven't check for other similar occurrences

Undefined property: stdClass::$COALESCE(setting_value, 'media/') || multimedia_file_refn …\vendor\illuminate\database\Query\Builder.php:3420
#0 …\vendor\illuminate\database\Query\Builder.php(3420): Fisharebest\Webtrees\Http\Middleware\ErrorHandler->errorHandler(2, 'Undefined prope...', 'D:\\Server\\html\\...', 3420)
#1 …\vendor\illuminate\database\Query\Builder.php(3381): Illuminate\Database\Query\Builder->pluckFromObjectColumn(Array, 'COALESCE(settin...', NULL)
#2 …\app\Services\MediaFileService.php(333): Illuminate\Database\Query\Builder->pluck('COALESCE(settin...')
#3 …\app\Http\RequestHandlers\ManageMediaPage.php(62): Fisharebest\Webtrees\Services\MediaFileService->allMediaFolders(Object(League\Flysystem\Filesystem))
#4 …\app\Http\Middleware\RequestHandler.php(52): Fisharebest\Webtrees\Http\RequestHandlers\ManageMediaPage->handle(Object(Nyholm\Psr7\ServerRequest))
#5 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\RequestHandler->process(Object(Nyholm\Psr7\ServerRequest), Object(Fisharebest\Webtrees\Http\RequestHandlers\NotFound))
#6 …\app\Module\CheckForNewVersion.php(112): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#7 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Module\CheckForNewVersion->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#8 …\app\Http\Middleware\CheckCsrf.php(80): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#9 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CheckCsrf->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#10 …\app\Http\Middleware\AuthAdministrator.php(53): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#11 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\AuthAdministrator->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#12 …\app\Http\Dispatcher.php(47): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#13 …\app\Http\Middleware\Router.php(136): Fisharebest\Webtrees\Http\Dispatcher::dispatch(Array, Object(Nyholm\Psr7\ServerRequest))
#14 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\Router->process(Object(Nyholm\Psr7\ServerRequest), Object(Fisharebest\Webtrees\Http\RequestHandlers\NotFound))
#15 …\app\Http\Middleware\BootModules.php(58): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#16 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\BootModules->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#17 …\app\Http\Middleware\RegisterGedcomTags.php(54): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#18 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\RegisterGedcomTags->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#19 …\app\Http\Middleware\LoadRoutes.php(75): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#20 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\LoadRoutes->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#21 …\app\Http\Middleware\CheckForNewVersion.php(57): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#22 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CheckForNewVersion->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#23 …\app\Http\Middleware\UseTransaction.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#24 …\vendor\illuminate\database\Concerns\ManagesTransactions.php(32): Fisharebest\Webtrees\Http\Middleware\UseTransaction::{closure:Fisharebest\Webtrees\Http\Middleware\UseTransaction::process():44}(Object(Illuminate\Database\MySqlConnection))
#25 …\app\Http\Middleware\UseTransaction.php(44): Illuminate\Database\Connection->transaction(Object(Closure), 3)
#26 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseTransaction->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#27 …\app\Http\Middleware\DoHousekeeping.php(71): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#28 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\DoHousekeeping->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#29 …\app\Http\Middleware\UseTheme.php(66): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#30 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseTheme->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#31 …\app\Http\Middleware\CheckForMaintenanceMode.php(51): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#32 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CheckForMaintenanceMode->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#33 …\app\Http\Middleware\UseLanguage.php(69): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#34 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseLanguage->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#35 …\app\Http\Middleware\UseSession.php(79): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#36 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseSession->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#37 …\app\Http\Middleware\UpdateDatabaseSchema.php(57): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#38 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UpdateDatabaseSchema->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#39 …\app\Http\Middleware\UseDatabase.php(60): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#40 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#41 …\app\Http\Middleware\BadBotBlocker.php(310): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#42 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#43 …\app\Http\Middleware\CompressResponse.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#44 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#45 …\app\Http\Middleware\ContentLength.php(40): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#46 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ContentLength->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#47 …\vendor\middlewares\client-ip\src\ClientIp.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#48 …\app\Http\Middleware\ClientIp.php(47): Middlewares\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#49 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ClientIp->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#50 …\app\Http\Middleware\PublicFiles.php(62): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#51 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\PublicFiles->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#52 …\app\Http\Middleware\HandleExceptions.php(88): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#53 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#54 …\app\Http\Middleware\SecurityHeaders.php(49): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#55 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#56 …\app\Http\Middleware\BaseUrl.php(73): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#57 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#58 …\app\Http\Middleware\ReadConfigIni.php(68): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#59 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#60 …\app\Http\Middleware\EmitResponse.php(55): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#61 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#62 …\app\Http\Middleware\ErrorHandler.php(38): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#63 …\app\Http\Dispatcher.php(76): Fisharebest\Webtrees\Http\Middleware\ErrorHandler->process(Object(Nyholm\Psr7\ServerRequest), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#64 …\app\Http\Dispatcher.php(47): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Nyholm\Psr7\ServerRequest))
#65 …\app\Webtrees.php(277): Fisharebest\Webtrees\Http\Dispatcher::dispatch(Array, Object(Nyholm\Psr7\ServerRequest))
#66 …\app\Webtrees.php(250): Fisharebest\Webtrees\Webtrees->httpRequest()
#67 …\index.php(24): Fisharebest\Webtrees\Webtrees->run('cgi-fcgi')
#68 {main}