Closed akash-mitra closed 3 years ago
Test test_a_user_can_duplicate_a_template fails as below while run via Github actions.
[2021-02-20 05:54:22] testing.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'save_as' in 'where clause' (SQL: select count(*) as aggregate from `templates` where `save_as` = k5VpkXSmRnhxhkD3_ipqJFdzroYutPVFh) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'save_as' in 'where clause' (SQL: select count(*) as aggregate from `templates` where `save_as` = k5VpkXSmRnhxhkD3_ipqJFdzroYutPVFh) at /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671) [stacktrace] #0 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\\Database\\Connection->runQueryCallback() #1 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Connection.php(339): Illuminate\\Database\\Connection->run() #2 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2270): Illuminate\\Database\\Connection->select() #3 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2258): Illuminate\\Database\\Query\\Builder->runSelect() #4 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2753): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2259): Illuminate\\Database\\Query\\Builder->onceWithColumns() #6 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2680): Illuminate\\Database\\Query\\Builder->get() #7 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2608): Illuminate\\Database\\Query\\Builder->aggregate() #8 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Validation/DatabasePresenceVerifier.php(55): Illuminate\\Database\\Query\\Builder->count() #9 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(765): Illuminate\\Validation\\DatabasePresenceVerifier->getCount() #10 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(554): Illuminate\\Validation\\Validator->validateUnique() #11 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(377): Illuminate\\Validation\\Validator->validateAttribute() #12 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(408): Illuminate\\Validation\\Validator->passes() #13 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(451): Illuminate\\Validation\\Validator->fails() #14 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Validation/Factory.php(136): Illuminate\\Validation\\Validator->validate() #15 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Providers/FoundationServiceProvider.php(58): Illuminate\\Validation\\Factory->validate() #16 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Support/Traits/Macroable.php(114): Illuminate\\Http\\Request->Illuminate\\Foundation\\Providers\\{closure}() #17 /home/runner/work/webtheory/webtheory/app/Http/Controllers/Api/TemplateController.php(107): Illuminate\\Http\\Request->__call() #18 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Api\\TemplateController->duplicate() #19 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction() #20 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Route.php(239): Illuminate\\Routing\\ControllerDispatcher->dispatch() #21 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Route.php(196): Illuminate\\Routing\\Route->runController() #22 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(685): Illuminate\\Routing\\Route->run() #23 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #24 /home/runner/work/webtheory/webtheory/app/Http/Middleware/CheckPermission.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #25 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\\Http\\Middleware\\CheckPermission->handle() #26 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #27 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #28 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #29 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Auth\\Middleware\\Authenticate->handle() #30 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle() #32 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #33 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #34 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #35 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #36 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Session\\Middleware\\StartSession->handle() #37 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #38 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #39 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #41 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #42 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(687): Illuminate\\Pipeline\\Pipeline->then() #43 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\\Routing\\Router->runRouteWithinStack() #44 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(628): Illuminate\\Routing\\Router->runRoute() #45 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(617): Illuminate\\Routing\\Router->dispatchToRoute() #46 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Routing\\Router->dispatch() #47 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #48 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #49 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #50 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #51 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #52 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #53 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #54 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #55 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle() #56 /home/runner/work/webtheory/webtheory/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #57 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle() #58 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #59 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(140): Illuminate\\Pipeline\\Pipeline->then() #60 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(109): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #61 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Testing/Concerns/MakesHttpRequests.php(508): Illuminate\\Foundation\\Http\\Kernel->handle() #62 /home/runner/work/webtheory/webtheory/vendor/laravel/framework/src/Illuminate/Foundation/Testing/Concerns/MakesHttpRequests.php(320): Illuminate\\Foundation\\Testing\\TestCase->call() #63 /home/runner/work/webtheory/webtheory/tests/Feature/TemplateTests/TemplateTest.php(331): Illuminate\\Foundation\\Testing\\TestCase->post() #64 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/Framework/TestCase.php(1471): Tests\\Feature\\TemplateTests\\TemplateTest->test_a_user_can_duplicate_a_template() #65 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/Framework/TestCase.php(1091): PHPUnit\\Framework\\TestCase->runTest() #66 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/Framework/TestResult.php(703): PHPUnit\\Framework\\TestCase->runBare() #67 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/Framework/TestCase.php(819): PHPUnit\\Framework\\TestResult->run() #68 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/Framework/TestSuite.php(627): PHPUnit\\Framework\\TestCase->run() #69 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/Framework/TestSuite.php(627): PHPUnit\\Framework\\TestSuite->run() #70 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/Framework/TestSuite.php(627): PHPUnit\\Framework\\TestSuite->run() #71 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(656): PHPUnit\\Framework\\TestSuite->run() #72 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/TextUI/Command.php(236): PHPUnit\\TextUI\\TestRunner->doRun() #73 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/src/TextUI/Command.php(195): PHPUnit\\TextUI\\Command->run() #74 /home/runner/work/webtheory/webtheory/vendor/phpunit/phpunit/phpunit(61): PHPUnit\\TextUI\\Command::main() #75 {main}
Test test_a_user_can_duplicate_a_template fails as below while run via Github actions.