Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL query contains duplicate order statement when using groups, 500 error on 2.3 / 2.4 #3418

Closed
Joe-K2018 opened this issue Jan 15, 2019 · 8 comments
Closed

SQL query contains duplicate order statement when using groups, 500 error on 2.3 / 2.4 #3418

Joe-K2018 opened this issue Jan 15, 2019 · 8 comments
Assignees
@jbrooksuk
Labels
Bug Bugs with Cachet Database/SQLServer
Milestone
v2.4

Comments

@Joe-K2018
Copy link

Joe-K2018 commented Jan 15, 2019 •
edited
Loading

When I add a component to a group and try to go to the status page it crashes with a 500 error.

The same error is thrown in 2.3 as well as 2.4. In 2.3 and 2.4 it occurs after adding a component to a group. In 2.4 it also occurs after adding an incident.

I have a feeling this is related to me running MS SQL server which I know is not officially supported, but since that is what my company uses I would really like to get this working and would appreciate assistance.

It looks like the SQL query that is generated has a duplicate order statement which SQL server doesn't like.

Stacktrace from 2.3 after adding component to group:

Next exception 'ErrorException' with message 'SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique. (SQL: select * from [components] where [components].[group_id] = 1 and [components].[group_id] is not null and [enabled] = 1 and [components].[deleted_at] is null order by [order] asc, [order] asc) (View: C:\Users\jkoch\Cachet\resources\views\partials\components.blade.php) (View: C:\Users\jkoch\Cachet\resources\views\partials\components.blade.php)' in C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Connection.php:713
Stack trace:
#0 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(15237): Illuminate\View\Engines\CompilerEngine->handleViewException(Object(ErrorException), 1)
#1 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(15272): Illuminate\View\Engines\PhpEngine->evaluatePath('C:\\Users\\jkoch\\...', Array)
#2 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(15104): Illuminate\View\Engines\CompilerEngine->get('C:\\Users\\jkoch\\...', Array)
#3 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(15092): Illuminate\View\View->getContents()
#4 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(15076): Illuminate\View\View->renderContents()
#5 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(16319): Illuminate\View\View->render()
#6 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(15815): Illuminate\Http\Response->setContent(Object(Illuminate\View\View))
#7 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(8366): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View))
#8 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9461): Illuminate\Routing\Router->prepareResponse(Object(Illuminate\Http\Request), Object(Illuminate\View\View))
#9 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#10 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#11 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#12 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9938): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#13 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9462): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#14 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9449): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(CachetHQ\Cachet\Http\Controllers\StatusPageController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'showIndex')
#15 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(8517): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'CachetHQ\\Cachet...', 'showIndex')
#16 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(8504): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))
#17 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(8218): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))
#18 [internal function]: Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#20 C:\Users\jkoch\Cachet\app\Http\Middleware\Localize.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 [internal function]: CachetHQ\Cachet\Http\Middleware\Localize->handle(Object(Illuminate\Http\Request), Object(Closure))
#22 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#23 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#25 C:\Users\jkoch\Cachet\app\Http\Middleware\ReadyForUse.php(40): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#26 [internal function]: CachetHQ\Cachet\Http\Middleware\ReadyForUse->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#28 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#30 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(3225): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#31 [internal function]: Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#33 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#34 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#35 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(13400): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#38 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#40 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(11943): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#41 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#43 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#44 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#45 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(13139): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#46 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#48 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#50 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(13076): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#51 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#53 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#54 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#55 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#56 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9938): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#57 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(8219): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#58 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(8210): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#59 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(8200): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#60 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#61 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#62 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#63 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(3286): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#64 [internal function]: Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#65 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#66 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#67 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#68 C:\Users\jkoch\Cachet\vendor\fideloper\proxy\src\TrustProxies.php(56): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#69 [internal function]: Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#70 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9953): call_user_func_array(Array, Array)
#71 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#72 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#73 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#74 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(9938): call_user_func(Object(Closure), Object(Illuminate\Http\Request))
#75 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#76 C:\Users\jkoch\Cachet\bootstrap\cache\compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#77 C:\Users\jkoch\Cachet\public\index.php(54): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#78 {main} {"identification":{"id":"aa2d229f-4422-480d-8ff9-b324a39bf723"}}

Stacktrace from 2.4 after adding incident:

[2019-01-23 00:41:49] production.ERROR: PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique. in C:\Users\jkoch\Cachet\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:117
Stack trace:
#0 C:\Users\jkoch\Cachet\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(117): PDOStatement->execute(NULL)
#1 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Connection.php(330): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('select top 1 * ...', Array)
#3 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select top 1 * ...', Array, Object(Closure))
#4 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Connection.php(333): Illuminate\Database\Connection->run('select top 1 * ...', Array, Object(Closure))
#5 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2082): Illuminate\Database\Connection->select('select top 1 * ...', Array, true)
#6 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2070): Illuminate\Database\Query\Builder->runSelect()
#7 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2556): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2071): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#9 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(516): Illuminate\Database\Query\Builder->get(Array)
#10 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(500): Illuminate\Database\Eloquent\Builder->getModels(Array)
#11 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Concerns\BuildsQueries.php(77): Illuminate\Database\Eloquent\Builder->get(Array)
#12 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Support\Traits\ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->first()
#13 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Relations\Relation.php(386): Illuminate\Database\Eloquent\Relations\Relation->forwardCallTo(Object(Illuminate\Database\Eloquent\Builder), 'first', Array)
#14 C:\Users\jkoch\Cachet\app\Presenters\IncidentPresenter.php(259): Illuminate\Database\Eloquent\Relations\Relation->__call('first', Array)
#15 C:\Users\jkoch\Cachet\app\Presenters\IncidentPresenter.php(228): CachetHQ\Cachet\Presenters\IncidentPresenter->latest()
#16 C:\Users\jkoch\Cachet\vendor\mccool\laravel-auto-presenter\src\BasePresenter.php(100): CachetHQ\Cachet\Presenters\IncidentPresenter->latest_human_status()
#17 C:\Users\jkoch\Cachet\storage\framework\views\ad3beb06b4e430c6dbd64879d75ea2d9706558f5.php(8): McCool\LaravelAutoPresenter\BasePresenter->__get('latest_human_st...')
#18 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(43): include('C:\\Users\\jkoch\\...')
#19 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(59): Illuminate\View\Engines\PhpEngine->evaluatePath('C:\\Users\\jkoch\\...', Array)
#20 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(142): Illuminate\View\Engines\CompilerEngine->get('C:\\Users\\jkoch\\...', Array)
#21 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(125): Illuminate\View\View->getContents()
#22 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(90): Illuminate\View\View->renderContents()
#23 C:\Users\jkoch\Cachet\storage\framework\views\cc601c6426f8007bd4bccd388b06a0bdbc240b08.php(5): Illuminate\View\View->render()
#24 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(43): include('C:\\Users\\jkoch\\...')
#25 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(59): Illuminate\View\Engines\PhpEngine->evaluatePath('C:\\Users\\jkoch\\...', Array)
#26 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(142): Illuminate\View\Engines\CompilerEngine->get('C:\\Users\\jkoch\\...', Array)
#27 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(125): Illuminate\View\View->getContents()
#28 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(90): Illuminate\View\View->renderContents()
#29 C:\Users\jkoch\Cachet\storage\framework\views\c7c90eab6bb0baa9e2767f86b674a801d38daaba.php(9): Illuminate\View\View->render()
#30 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(43): include('C:\\Users\\jkoch\\...')
#31 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(59): Illuminate\View\Engines\PhpEngine->evaluatePath('C:\\Users\\jkoch\\...', Array)
#32 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(142): Illuminate\View\Engines\CompilerEngine->get('C:\\Users\\jkoch\\...', Array)
#33 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(125): Illuminate\View\View->getContents()
#34 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(90): Illuminate\View\View->renderContents()
#35 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Http\Response.php(42): Illuminate\View\View->render()
#36 C:\Users\jkoch\Cachet\vendor\symfony\http-foundation\Response.php(202): Illuminate\Http\Response->setContent(Object(Illuminate\View\View))
#37 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(750): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View))
#38 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(722): Illuminate\Routing\Router::toResponse(Object(Illuminate\Http\Request), Object(Illuminate\View\View))
#39 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(682): Illuminate\Routing\Router->prepareResponse(Object(Illuminate\Http\Request), Object(Illuminate\View\View))
#40 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#41 C:\Users\jkoch\Cachet\app\Http\Middleware\Localize.php(68): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#42 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): CachetHQ\Cachet\Http\Middleware\Localize->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#44 C:\Users\jkoch\Cachet\app\Http\Middleware\ReadyForUse.php(60): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#45 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): CachetHQ\Cachet\Http\Middleware\ReadyForUse->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#50 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(75): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#51 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#52 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#53 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#54 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#55 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#56 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#57 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#60 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#61 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#62 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(66): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#63 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#65 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#66 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(684): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#67 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(659): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#68 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(625): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#69 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(614): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#70 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#71 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#72 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(62): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#73 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#74 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#75 C:\Users\jkoch\Cachet\vendor\fideloper\proxy\src\TrustProxies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#76 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#77 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#78 C:\Users\jkoch\Cachet\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#79 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Barryvdh\Cors\HandlePreflight->handle(Object(Illuminate\Http\Request), Object(Closure))
#80 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#81 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#82 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#83 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#84 C:\Users\jkoch\Cachet\public\index.php(54): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#85 {main}
@Joe-K2018 Joe-K2018 changed the title When component is added to group, status page crashes with 500 error on 2.3 / 2.4 SQL query contains duplicate order statement when using groups, 500 error on 2.3 / 2.4 Jan 18, 2019
@jbrooksuk jbrooksuk added Bug Bugs with Cachet triage labels Jan 21, 2019
@Joe-K2018
Copy link
Author

If anyone can point me in the direction of what file might be incorrectly formatting the select statement, I can take a look and see if I can figure out. I've been digging through the files but haven't been able to figure it out yet.

@jbrooksuk jbrooksuk self-assigned this Jan 26, 2019
@jbrooksuk jbrooksuk added this to the V2.4.0 milestone Jan 26, 2019
@jbrooksuk
Copy link
Member

I'll take a look at this now, though I don't have an MS SQL Server to test against. Would you be able to pull down a branch and test for me?

jbrooksuk added a commit that referenced this issue Jan 26, 2019
@jbrooksuk
Remove duplicate order statement. Fixes #3418
19f9b2f
@jbrooksuk jbrooksuk mentioned this issue Jan 26, 2019
Merged
@jbrooksuk
Copy link
Member

@Joe-K2018 can you test out #3432 please.

jbrooksuk added a commit that referenced this issue Jan 26, 2019
@jbrooksuk
Remove duplicate order statement. Fixes #3418
e21918c
@Joe-K2018
Copy link
Author

Looks good! I can load the status page after adding an incident now in 2.4.

I am still having this issue after adding components to groups and trying to view the status page, but I might have fixed it? I was playing around with this last night. I'm new to PHP programming but got XDebug set up and was going through it. I ended up removing the order by statement from two locations here:

https://i.imgur.com/InwEeNV.png
https://i.imgur.com/lZK3Uel.png

It worked after that, but I'm not sure if that is the right way to go about it. The names of the files appear to be random, so I'm thinking these must be auto-generated files. If that's the case, I'm worried about running into this issue again when I do a fresh install on a production server. What do you think?

@jbrooksuk
Copy link
Member

I am still having this issue after adding components to groups and trying to view the status page, but I might have fixed it?

I think it'll likely be the same issue, just in different presenters. Bear with!

@jbrooksuk
Copy link
Member

Okay, pull down the branch again :)

@Joe-K2018
Copy link
Author

It's better! I can view the status page if I go to the base url, but if I go to /dashboard I am still receiving the error.

Next ErrorException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique. (SQL: select * from [components] where [components].[group_id] = 1 and [components].[group_id] is not null and [enabled] = 1 and [components].[deleted_at] is null order by [order] asc, [order] asc) (View: C:\Users\jkoch\Cachet\resources\views\dashboard\partials\components.blade.php) (View: C:\Users\jkoch\Cachet\resources\views\dashboard\partials\components.blade.php) in C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664
Stack trace:
#0 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php(45): Illuminate\View\Engines\CompilerEngine->handleViewException(Object(ErrorException), 0)
#1 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php(59): Illuminate\View\Engines\PhpEngine->evaluatePath('C:\\Users\\jkoch\\...', Array)
#2 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(142): Illuminate\View\Engines\CompilerEngine->get('C:\\Users\\jkoch\\...', Array)
#3 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(125): Illuminate\View\View->getContents()
#4 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\View.php(90): Illuminate\View\View->renderContents()
#5 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Http\Response.php(42): Illuminate\View\View->render()
#6 C:\Users\jkoch\Cachet\vendor\symfony\http-foundation\Response.php(202): Illuminate\Http\Response->setContent(Object(Illuminate\View\View))
#7 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(750): Symfony\Component\HttpFoundation\Response->__construct(Object(Illuminate\View\View))
#8 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(722): Illuminate\Routing\Router::toResponse(Object(Illuminate\Http\Request), Object(Illuminate\View\View))
#9 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(682): Illuminate\Routing\Router->prepareResponse(Object(Illuminate\Http\Request), Object(Illuminate\View\View))
#10 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#11 C:\Users\jkoch\Cachet\app\Http\Middleware\Authenticate.php(61): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#12 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): CachetHQ\Cachet\Http\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#13 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#14 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#15 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#16 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#17 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php(75): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#19 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#20 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#22 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(66): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(684): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#34 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(659): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#35 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(625): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#36 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Router.php(614): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#37 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#38 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#39 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php(62): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#42 C:\Users\jkoch\Cachet\vendor\fideloper\proxy\src\TrustProxies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#43 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 C:\Users\jkoch\Cachet\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#46 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(151): Barryvdh\Cors\HandlePreflight->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#48 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#49 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#50 C:\Users\jkoch\Cachet\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#51 C:\Users\jkoch\Cachet\public\index.php(54): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#52 {main} {"identification":{"id":"62ce9f4b-e444-4e0a-aecd-f309ab393241"}}

@jbrooksuk
Copy link
Member

Can you provide me with the full log file please?

Also, try running rm -rf bootstrap/cache/*.

@Joe-K2018 Joe-K2018 mentioned this issue Jan 28, 2019
Closed
zhenyulin pushed a commit to zhenyulin/Cachet that referenced this issue Mar 12, 2019
@backstroke-bot @zhenyulin
Update from upstream repo CachetHQ/Cachet (#1)
7c53d01 
* New translations cachet.php (Portuguese)

* New translations cachet.php (Polish)

* New translations cachet.php (Romanian)

* New translations cachet.php (Japanese)

* New translations cachet.php (Korean)

* New translations cachet.php (Norwegian)

* New translations forms.php (Norwegian)

* New translations cachet.php (Persian)

* New translations cachet.php (Russian)

* New translations cachet.php (Ukrainian)

* New translations cachet.php (Vietnamese)

* New translations cachet.php (Zulu)

* New translations forms.php (Zulu)

* New translations cachet.php (Estonian)

* New translations cachet.php (Spanish)

* New translations cachet.php (Swedish)

* New translations cachet.php (Thai)

* New translations cachet.php (Turkish)

* New translations cachet.php (Chinese Traditional)

* New translations cachet.php (Czech)

* New translations cachet.php (Danish)

* New translations cachet.php (Dutch)

* New translations forms.php (Dutch)

* New translations forms.php (Chinese Simplified)

* New translations cachet.php (Arabic)

* New translations cachet.php (Albanian)

* New translations cachet.php (Catalan)

* New translations cachet.php (Chinese Simplified)

* New translations cachet.php (Hebrew)

* New translations cachet.php (Hungarian)

* New translations cachet.php (Indonesian)

* New translations cachet.php (Italian)

* New translations cachet.php (Greek)

* New translations cachet.php (English)

* New translations cachet.php (Finnish)

* New translations cachet.php (French)

* New translations cachet.php (German)

* Fix configuring postgres leads to wrong database driver key

* Add warning when setting up localhost with mysql driver

* Explicitly set the port number when not using traditional ports

* Add support for empty values in the persistEnv method

* [Security] Bump url-parse from 1.4.1 to 1.4.4

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.4.1 to 1.4.4. **This update includes security fixes.**
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](unshiftio/url-parse@1.4.1...1.4.4)

Signed-off-by: dependabot[bot] <[email protected]>

* Use PHP Debugger(phpdbg) for PHPUnit to speed up CI

* Improve database performance by removing duplicated queries

* StyleCI

* Eager load user on the incident page not to query twice

* Eager load group on the dashboard/components page not to query twice

* Improve database performance by removing duplicated queries

* StyleCI

* Resolve cachethq#3269

* Resolve cachethq#3288
If Binput::get('enabled') is not defined this will return NULL which resulted in a false.
Updated tests

* New translations cachet.php (Swedish)

* New translations dashboard.php (Swedish)

* Apply fixes from StyleCI

* Update deps

* Drop support for RSS & Atom feeds.

* Update Blade files

* Don't expose current mail password

* Rebuilt composer.lock

* Bump laravolt/avatar from 1.8.1 to 2.1.0

Bumps [laravolt/avatar](https://github.com/laravolt/avatar) from 1.8.1 to 2.1.0.
- [Release notes](https://github.com/laravolt/avatar/releases)
- [Changelog](https://github.com/laravolt/avatar/blob/master/CHANGELOG.md)
- [Commits](laravolt/avatar@1.8.1...2.1.0)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump laravel-mix-purgecss from 2.2.0 to 3.0.0

Bumps [laravel-mix-purgecss](https://github.com/spatie/laravel-mix-purgecss) from 2.2.0 to 3.0.0.
- [Release notes](https://github.com/spatie/laravel-mix-purgecss/releases)
- [Changelog](https://github.com/spatie/laravel-mix-purgecss/blob/master/CHANGELOG.md)
- [Commits](spatie/laravel-mix-purgecss@2.2.0...3.0.0)

Signed-off-by: dependabot[bot] <[email protected]>

* Upgraded JS deps and rebuilt assets

* GitHub now supports transferring an issue

* Remove unused $config property

* Apply fixes from StyleCI

* Upgraded to Laravel 5.7

* Deal with settings read/write errors properly

* Apply fixes from StyleCI

* Commit new vendor files

* Apply fixes from StyleCI

* Fixed up vendor views

* Updated doctrine and emoji packages

* Set the mail username optional in setup

During the setup process email informations were asked:
  - Driver
  - Host
  - Username
  - Password

In some situations the username is not useful because the Cachet's
host may be configured to forward email to a server.

The problem is the username was required, so we had to set a username
and then update the .env file to remove it.

To fix this problem, the mail username has been set to optional in
the setup. So if someone needs a username it still can use this field,
and otherwise people can let it empty.

See: cachethq#3244

* Let the mail_username required except for sendmail

During the setup the "mail_username" was required and it was then
undone, so using the sendmail driver we can let the username empty.

It would be bad to let the username optional for every drivers, because
in some configurations, like SMTP, the username is required for the SMTP
server so if the user let it empty its mail configuration will be bad.

The mail_username is now optional only if the mail driver is sendmail.

See: cachethq#3244

* Apply fixes from StyleCI

* Upgraded dependencies following XSS vulnerability discovery

* Use safer markdown defaults

* [Security] Bump twig/twig from 1.36.0 to 2.6.0

Bumps [twig/twig](https://github.com/twigphp/Twig) from 1.36.0 to 2.6.0. **This update includes security fixes.**
- [Release notes](https://github.com/twigphp/Twig/releases)
- [Changelog](https://github.com/twigphp/Twig/blob/2.x/CHANGELOG)
- [Commits](twigphp/Twig@v1.36.0...v2.6.0)

Signed-off-by: dependabot[bot] <[email protected]>

* New translations forms.php (Dutch)

* New translations cachet.php (German)

* New translations pagination.php (German)

* Apply fixes from StyleCI

* Bump doctrine/dbal from 2.9.1 to 2.9.2

Bumps [doctrine/dbal](https://github.com/doctrine/dbal) from 2.9.1 to 2.9.2.
- [Release notes](https://github.com/doctrine/dbal/releases)
- [Commits](doctrine/dbal@v2.9.1...v2.9.2)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump laravel-mix and laravel-mix-purgecss

Bumps [laravel-mix](https://github.com/JeffreyWay/laravel-mix) and [laravel-mix-purgecss](https://github.com/spatie/laravel-mix-purgecss). These dependencies needed to be updated together.

Updates `laravel-mix` from 2.1.14 to 4.0.12
- [Release notes](https://github.com/JeffreyWay/laravel-mix/releases)
- [Commits](laravel-mix/laravel-mix@v2.1.14...v4.0.12)

Updates `laravel-mix-purgecss` from 3.0.0 to 4.0.0
- [Release notes](https://github.com/spatie/laravel-mix-purgecss/releases)
- [Changelog](https://github.com/spatie/laravel-mix-purgecss/blob/master/CHANGELOG.md)
- [Commits](spatie/laravel-mix-purgecss@3.0.0...4.0.0)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump LICENSE year

* New translations validation.php (Dutch)

* Link to Exascale sponsor

* Extra dependencies were required

* Revert "Bump laravel-mix and laravel-mix-purgecss"

* Remove Gulp and update requirements lists

* Use Twig namespaces

* Move overview up

* Add documentation

* Improve database performance by removing duplicated queries

* Typo in phpdoc

* Revert "Typo in phpdoc"

This reverts commit af94758.

* Typo in phpdoc

* Bump symfony/dom-crawler from 4.2.1 to 4.2.2

Bumps [symfony/dom-crawler](https://github.com/symfony/dom-crawler) from 4.2.1 to 4.2.2.
- [Release notes](https://github.com/symfony/dom-crawler/releases)
- [Changelog](https://github.com/symfony/dom-crawler/blob/master/CHANGELOG.md)
- [Commits](symfony/dom-crawler@v4.2.1...v4.2.2)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump aws/aws-sdk-php from 3.82.3 to 3.82.6

Bumps [aws/aws-sdk-php](https://github.com/aws/aws-sdk-php) from 3.82.3 to 3.82.6.
- [Release notes](https://github.com/aws/aws-sdk-php/releases)
- [Changelog](https://github.com/aws/aws-sdk-php/blob/master/CHANGELOG.md)
- [Commits](aws/aws-sdk-php@3.82.3...3.82.6)

Signed-off-by: dependabot[bot] <[email protected]>

* New translations forms.php (Dutch)

* New translations dashboard.php (Dutch)

* New translations validation.php (Dutch)

* New translations cachet.php (Dutch)

* Bump fideloper/proxy from 4.0.0 to 4.1.0

Bumps [fideloper/proxy](https://github.com/fideloper/TrustedProxy) from 4.0.0 to 4.1.0.
- [Release notes](https://github.com/fideloper/TrustedProxy/releases)
- [Commits](fideloper/TrustedProxy@4.0.0...4.1.0)

Signed-off-by: dependabot[bot] <[email protected]>

* [Security] Bump twig/twig from 2.6.0 to 2.6.2

Bumps [twig/twig](https://github.com/twigphp/Twig) from 2.6.0 to 2.6.2. **This update includes security fixes.**
- [Release notes](https://github.com/twigphp/Twig/releases)
- [Changelog](https://github.com/twigphp/Twig/blob/2.x/CHANGELOG)
- [Commits](twigphp/Twig@v2.6.0...v2.6.2)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump aws/aws-sdk-php from 3.82.6 to 3.86.2

Bumps [aws/aws-sdk-php](https://github.com/aws/aws-sdk-php) from 3.82.6 to 3.86.2.
- [Release notes](https://github.com/aws/aws-sdk-php/releases)
- [Changelog](https://github.com/aws/aws-sdk-php/blob/master/CHANGELOG.md)
- [Commits](aws/aws-sdk-php@3.82.6...3.86.2)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump laravel/framework from 5.7.19 to 5.7.21

Bumps [laravel/framework](https://github.com/laravel/framework) from 5.7.19 to 5.7.21.
- [Release notes](https://github.com/laravel/framework/releases)
- [Changelog](https://github.com/laravel/framework/blob/5.7/CHANGELOG-5.7.md)
- [Commits](laravel/framework@v5.7.19...v5.7.21)

Signed-off-by: dependabot[bot] <[email protected]>

* New translations cachet.php (German)

* New translations dashboard.php (German)

* New translations forms.php (German)

* New translations notifications.php (German)

* Remove duplicate order statement. Fixes cachethq#3418

* Remove string about HTTP(s). Fixes cachethq#3421

* Fixes CORS headers. Closes cachethq#3413

* Apply fixes from StyleCI

* Update deps

* Compile assets

* Fix importing of node_modules CSS

* Compile assets

* Fully remove the Strengthify integration

* Compile assets

* New translations cachet.php (Mongolian)

* New translations dashboard.php (Mongolian)

* New translations forms.php (Mongolian)

* New translations pagination.php (Mongolian)

* New translations setup.php (Mongolian)

* New translations validation.php (Mongolian)

* New translations notifications.php (Mongolian)

* New translations cachet.php (Slovenian)

* New translations dashboard.php (Slovenian)

* New translations forms.php (Slovenian)

* New translations pagination.php (Slovenian)

* New translations setup.php (Slovenian)

* New translations validation.php (Slovenian)

* New translations notifications.php (Slovenian)

* Fix other duplicate order by statements

* Apply fixes from StyleCI

* Fix HTML encoding for Google Fonts

* Update blog feed

Fixes cachethq#3441

* Bump sortablejs from 1.7.0 to 1.8.1

Bumps [sortablejs](https://github.com/SortableJS/Sortable) from 1.7.0 to 1.8.1.
- [Release notes](https://github.com/SortableJS/Sortable/releases)
- [Commits](SortableJS/Sortable@1.7.0...1.8.1)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump vue and vue-template-compiler

Bumps [vue](https://github.com/vuejs/vue) and [vue-template-compiler](https://github.com/vuejs/vue). These dependencies needed to be updated together.

Updates `vue` from 2.5.21 to 2.5.22
- [Release notes](https://github.com/vuejs/vue/releases)
- [Commits](vuejs/vue@v2.5.21...v2.5.22)

Updates `vue-template-compiler` from 2.5.21 to 2.5.22
- [Release notes](https://github.com/vuejs/vue/releases)
- [Commits](vuejs/vue@v2.5.21...v2.5.22)

Signed-off-by: dependabot[bot] <[email protected]>

* Do not use arr_* or str_* helpers

* Add missing Arr import

* Fix setup username validation

* Add user on cachet install command

* Get a fresh configuration

* Use class notation

* Apply fixes from StyleCI

* Don't prompt for tag files [Fix cachethq#3453]

* Substitute :name by incident name on slack title

Slack title for created incident has ':name', which is being substituted by incident name.

* We no longer need the dev symfony requirements

* Bump phpunit/phpunit from 7.5.3 to 7.5.4

Bumps [phpunit/phpunit](https://github.com/sebastianbergmann/phpunit) from 7.5.3 to 7.5.4.
- [Release notes](https://github.com/sebastianbergmann/phpunit/releases)
- [Changelog](https://github.com/sebastianbergmann/phpunit/blob/master/ChangeLog-7.5.md)
- [Commits](sebastianbergmann/phpunit@7.5.3...7.5.4)

Signed-off-by: dependabot[bot] <[email protected]>

* Change to appropriate tags to hide and select/unselect components in group

* Drop dependency on alt-three throttle (cachethq#3469)

I've just pulled in the subset of the features we were actually using.

* Bump laravel/framework from 5.7.25 to 5.7.26

Bumps [laravel/framework](https://github.com/laravel/framework) from 5.7.25 to 5.7.26.
- [Release notes](https://github.com/laravel/framework/releases)
- [Changelog](https://github.com/laravel/framework/blob/5.7/CHANGELOG-5.7.md)
- [Commits](laravel/framework@v5.7.25...v5.7.26)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump graham-campbell/binput from 6.0.0 to 6.1.0

Bumps [graham-campbell/binput](https://github.com/GrahamCampbell/Laravel-Binput) from 6.0.0 to 6.1.0.
- [Release notes](https://github.com/GrahamCampbell/Laravel-Binput/releases)
- [Changelog](https://github.com/GrahamCampbell/Laravel-Binput/blob/master/CHANGELOG.md)
- [Commits](GrahamCampbell/Laravel-Binput@v6.0.0...v6.1.0)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump graham-campbell/markdown from 10.2.0 to 10.3.0

Bumps [graham-campbell/markdown](https://github.com/GrahamCampbell/Laravel-Markdown) from 10.2.0 to 10.3.0.
- [Release notes](https://github.com/GrahamCampbell/Laravel-Markdown/releases)
- [Changelog](https://github.com/GrahamCampbell/Laravel-Markdown/blob/master/CHANGELOG.md)
- [Commits](GrahamCampbell/Laravel-Markdown@v10.2.0...v10.3.0)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump graham-campbell/testbench-core from 3.0.0 to 3.0.2

Bumps [graham-campbell/testbench-core](https://github.com/GrahamCampbell/Laravel-TestBench-Core) from 3.0.0 to 3.0.2.
- [Release notes](https://github.com/GrahamCampbell/Laravel-TestBench-Core/releases)
- [Changelog](https://github.com/GrahamCampbell/Laravel-TestBench-Core/blob/master/CHANGELOG.md)
- [Commits](GrahamCampbell/Laravel-TestBench-Core@v3.0.0...v3.0.2)

Signed-off-by: dependabot[bot] <[email protected]>

* Re-enable middleware. Fixes cachethq#3472

* Move meta relation into trait

* Remove badly added components class

* Improve count call

* More UX and UI fixes

* Compile assets

* [Security] Bump bootstrap-sass from 3.4.0 to 3.4.1

Bumps [bootstrap-sass](https://github.com/twbs/bootstrap-sass) from 3.4.0 to 3.4.1. **This update includes security fixes.**
- [Release notes](https://github.com/twbs/bootstrap-sass/releases)
- [Changelog](https://github.com/twbs/bootstrap-sass/blob/master/CHANGELOG.md)
- [Commits](twbs/bootstrap-sass@v3.4.0...v3.4.1)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump mockery/mockery from 1.2.1 to 1.2.2

Bumps [mockery/mockery](https://github.com/mockery/mockery) from 1.2.1 to 1.2.2.
- [Release notes](https://github.com/mockery/mockery/releases)
- [Changelog](https://github.com/mockery/mockery/blob/master/CHANGELOG.md)
- [Commits](mockery/mockery@1.2.1...1.2.2)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump laravolt/avatar from 2.1.0 to 2.2.0

Bumps [laravolt/avatar](https://github.com/laravolt/avatar) from 2.1.0 to 2.2.0.
- [Release notes](https://github.com/laravolt/avatar/releases)
- [Changelog](https://github.com/laravolt/avatar/blob/master/CHANGELOG.md)
- [Commits](laravolt/avatar@2.1.0...2.2.0)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump phpunit/phpunit from 7.5.4 to 7.5.6

Bumps [phpunit/phpunit](https://github.com/sebastianbergmann/phpunit) from 7.5.4 to 7.5.6.
- [Release notes](https://github.com/sebastianbergmann/phpunit/releases)
- [Changelog](https://github.com/sebastianbergmann/phpunit/blob/master/ChangeLog-7.5.md)
- [Commits](sebastianbergmann/phpunit@7.5.4...7.5.6)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump aws/aws-sdk-php from 3.87.8 to 3.87.17

Bumps [aws/aws-sdk-php](https://github.com/aws/aws-sdk-php) from 3.87.8 to 3.87.17.
- [Release notes](https://github.com/aws/aws-sdk-php/releases)
- [Changelog](https://github.com/aws/aws-sdk-php/blob/master/CHANGELOG.md)
- [Commits](aws/aws-sdk-php@3.87.8...3.87.17)

Signed-off-by: dependabot[bot] <[email protected]>

* Correctly retrieve the value

* Remove duplicate CSS properties

Remove unused parameter

* Bump barryvdh/laravel-cors from 0.11.2 to 0.11.3

Bumps [barryvdh/laravel-cors](https://github.com/barryvdh/laravel-cors) from 0.11.2 to 0.11.3.
- [Release notes](https://github.com/barryvdh/laravel-cors/releases)
- [Changelog](https://github.com/barryvdh/laravel-cors/blob/master/changelog.md)
- [Commits](fruitcake/laravel-cors@v0.11.2...v0.11.3)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump barryvdh/laravel-debugbar from 3.2.2 to 3.2.3

Bumps [barryvdh/laravel-debugbar](https://github.com/barryvdh/laravel-debugbar) from 3.2.2 to 3.2.3.
- [Release notes](https://github.com/barryvdh/laravel-debugbar/releases)
- [Changelog](https://github.com/barryvdh/laravel-debugbar/blob/master/changelog.md)
- [Commits](barryvdh/laravel-debugbar@v3.2.2...v3.2.3)

Signed-off-by: dependabot[bot] <[email protected]>

* Make pgsql schema configurable via environment variable

* Bump graham-campbell/exceptions from 11.1.0 to 11.2.0

Bumps [graham-campbell/exceptions](https://github.com/GrahamCampbell/Laravel-Exceptions) from 11.1.0 to 11.2.0.
- [Release notes](https://github.com/GrahamCampbell/Laravel-Exceptions/releases)
- [Changelog](https://github.com/GrahamCampbell/Laravel-Exceptions/blob/master/CHANGELOG.md)
- [Commits](GrahamCampbell/Laravel-Exceptions@v11.1.0...v11.2.0)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump aws/aws-sdk-php from 3.87.17 to 3.89.1

Bumps [aws/aws-sdk-php](https://github.com/aws/aws-sdk-php) from 3.87.17 to 3.89.1.
- [Release notes](https://github.com/aws/aws-sdk-php/releases)
- [Changelog](https://github.com/aws/aws-sdk-php/blob/master/CHANGELOG.md)
- [Commits](aws/aws-sdk-php@3.87.17...3.89.1)

Signed-off-by: dependabot[bot] <[email protected]>

* Bump laravel/framework from 5.7.26 to 5.7.28

Bumps [laravel/framework](https://github.com/laravel/framework) from 5.7.26 to 5.7.28.
- [Release notes](https://github.com/laravel/framework/releases)
- [Changelog](https://github.com/laravel/framework/blob/5.8/CHANGELOG-5.7.md)
- [Commits](laravel/framework@v5.7.26...v5.7.28)

Signed-off-by: dependabot[bot] <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jbrooksuk jbrooksuk

Labels
Bug Bugs with Cachet Database/SQLServer
Projects
None yet
Milestone
v2.4
Development

No branches or pull requests
2 participants
@jbrooksuk @Joe-K2018