[0.7] Dropdown list for selecting user when creating server fails to load.

[DaneEveritt]

Getting the exception below, caused by the use of strict in the database config. Need to disable the strict check for ONLY_FULL_GROUP_BY. ref

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1055 'panel.users.external_id' isn't in GROUP BY (SQL: select * from (select `users`.*, max(case when `users`.`email` = da then 150 else 0 end + case when `users`.`email` like da% then 50 else 0 end + case when `users`.`email` like %da% then 10 else 0 end + case when `users`.`username` = da then 135 else 0 end + case when `users`.`username` like da% then 45 else 0 end + case when `users`.`username` like %da% then 9 else 0 end + case when `users`.`name_first` = da then 90 else 0 end + case when `users`.`name_first` like da% then 30 else 0 end + case when `users`.`name_first` like %da% then 6 else 0 end + case when `users`.`name_last` = da then 90 else 0 end + case when `users`.`name_last` like da% then 30 else 0 end + case when `users`.`name_last` like %da% then 6 else 0 end + case when `users`.`uuid` = da then 15 else 0 end + case when `users`.`uuid` like da% then 5 else 0 end + case when `users`.`uuid` like %da% then 1 else 0 end + case when `users`.`external_id` = da then 15 else 0 end + case when `users`.`external_id` like da% then 5 else 0 end + case when `users`.`external_id` like %da% then 1 else 0 end) as relevance from `users` where (`users`.`email` like %da% or `users`.`username` like %da% or `users`.`name_first` like %da% or `users`.`name_last` like %da% or `users`.`uuid` like %da% or `users`.`external_id` like %da%) group by `users`.`id`) as `users` where `relevance` >= 8.25 order by `relevance` desc) in /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:638
Stack trace:
#0 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(598): Illuminate\Database\Connection->runQueryCallback('select * from (...', Array, Object(Closure))
#1 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(318): Illuminate\Database\Connection->run('select * from (...', Array, Object(Closure))
#2 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1707): Illuminate\Database\Connection->select('select * from (...', Array, true)
#3 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1692): Illuminate\Database\Query\Builder->runSelect()
#4 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(461): Illuminate\Database\Query\Builder->get(Array)
#5 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(445): Illuminate\Database\Eloquent\Builder->getModels(Array)
#6 /var/www/pterodactyl.app/vendor/sofa/eloquence/src/Builder.php(58): Illuminate\Database\Eloquent\Builder->get(Array)
#7 /var/www/pterodactyl.app/app/Repositories/Eloquent/UserRepository.php(74): Sofa\Eloquence\Builder->get()
#8 /var/www/pterodactyl.app/app/Http/Controllers/Admin/UserController.php(180): Pterodactyl\Repositories\Eloquent\UserRepository->filterUsersByQuery('da')
#9 [internal function]: Pterodactyl\Http\Controllers\Admin\UserController->json(Object(Illuminate\Http\Request))
#10 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#11 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction('json', Array)
#12 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Route.php(202): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Pterodactyl\Http\Controllers\Admin\UserController), 'json')
#13 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Route.php(159): Illuminate\Routing\Route->runController()
#14 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php(566): Illuminate\Routing\Route->run()
#15 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#16 /var/www/pterodactyl.app/app/Http/Middleware/AdminAuthenticate.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#17 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Pterodactyl\Http\Middleware\AdminAuthenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#18 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/pterodactyl.app/app/Http/Middleware/RequireTwoFactorAuthentication.php(81): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Pterodactyl\Http\Middleware\RequireTwoFactorAuthentication->handle(Object(Illuminate\Http\Request), Object(Closure))
#21 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/pterodactyl.app/app/Http/Middleware/LanguageMiddleware.php(39): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Pterodactyl\Http\Middleware\LanguageMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#24 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#25 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(40): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#28 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(42): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#30 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#31 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#33 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(48): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#36 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#37 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#38 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#39 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#40 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(36): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#41 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#46 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(101): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php(568): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#48 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php(527): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#49 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php(505): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#50 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(171): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#51 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#52 /var/www/pterodactyl.app/vendor/barryvdh/laravel-debugbar/src/Middleware/Debugbar.php(53): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#53 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Barryvdh\Debugbar\Middleware\Debugbar->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /var/www/pterodactyl.app/vendor/fideloper/proxy/src/TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#56 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#58 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(36): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#62 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#63 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#64 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#65 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#66 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#67 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(45): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#68 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(147): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#69 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#70 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(101): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#71 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(148): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#72 /var/www/pterodactyl.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(115): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#73 /var/www/pterodactyl.app/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#74 {main}