{"action":"created","issue":{"url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/163","repository_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory","labels_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/163/labels{/name}","comments_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/163/comments","events_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/163/events","html_url":"https://github.com/dreamfactorysoftware/dreamfactory/issues/163","id":265536466,"number":163,"title":"Invalid datetime value when midnight","user":{"login":"luizzz","id":326745,"avatar_url":"https://avatars1.githubusercontent.com/u/326745?v=4","gravatar_id":"","url":"https://api.github.com/users/luizzz","html_url":"https://github.com/luizzz","followers_url":"https://api.github.com/users/luizzz/followers","following_url":"https://api.github.com/users/luizzz/following{/other_user}","gists_url":"https://api.github.com/users/luizzz/gists{/gist_id}","starred_url":"https://api.github.com/users/luizzz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luizzz/subscriptions","organizations_url":"https://api.github.com/users/luizzz/orgs","repos_url":"https://api.github.com/users/luizzz/repos","events_url":"https://api.github.com/users/luizzz/events{/privacy}","received_events_url":"https://api.github.com/users/luizzz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2017-10-15T01:06:04Z","updated_at":"2018-03-30T20:35:30Z","closed_at":null,"author_association":"NONE","body":"i found a weird bug when i try to login in dreamfactory at midnight...\r\n\r\nfull error below:\r\n`\r\n{\"error\":{\"code\":\"22007\",\"message\":\"SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2017-10-15 00:55:02' for column 'last_modified_date' at row 1 (SQL: update `user` set `last_login_date` = 2017-10-15 00:55:02, `last_modified_date` = 2017-10-15 00:55:02 where `id` = 2)\",\"trace\":[\"0 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\\\\Database\\\\Connection->runQueryCallback('update `user` s...', Array, Object(Closure))\",\"1 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\\\\Database\\\\Connection->run('update `user` s...', Array, Object(Closure))\",\"2 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): Illuminate\\\\Database\\\\Connection->affectingStatement('update `user` s...', Array)\",\"3 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2152): Illuminate\\\\Database\\\\Connection->update('update `user` s...', Array)\",\"4 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(759): Illuminate\\\\Database\\\\Query\\\\Builder->update(Array)\",\"5 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(591): Illuminate\\\\Database\\\\Eloquent\\\\Builder->update(Array)\",\"6 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(511): Illuminate\\\\Database\\\\Eloquent\\\\Model->performUpdate(Object(DreamFactory\\\\Core\\\\Components\\\\Builder))\",\"7 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Models/BaseModel.php(46): Illuminate\\\\Database\\\\Eloquent\\\\Model->save(Array)\",\"8 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Models/User.php(639): DreamFactory\\\\Core\\\\Models\\\\BaseModel->save(Array)\",\"9 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Utility/Session.php(595): DreamFactory\\\\Core\\\\Models\\\\User->save()\",\"10 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Resources/UserSessionResource.php(419): DreamFactory\\\\Core\\\\Utility\\\\Session::authenticate(Array, false, true, NULL)\",\"11 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Resources/UserSessionResource.php(64): DreamFactory\\\\Core\\\\Resources\\\\UserSessionResource->handleLogin(Array, false)\",\"12 [internal function]: DreamFactory\\\\Core\\\\Resources\\\\UserSessionResource->handlePOST()\",\"13 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Components/RestHandler.php(330): call_user_func(Array)\",\"14 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Components/RestHandler.php(191): DreamFactory\\\\Core\\\\Components\\\\RestHandler->processRequest()\",\"15 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Components/RestHandler.php(249): DreamFactory\\\\Core\\\\Components\\\\RestHandler->handleRequest(Object(DreamFactory\\\\Core\\\\Utility\\\\ServiceRequest), '')\",\"16 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Components/RestHandler.php(166): DreamFactory\\\\Core\\\\Components\\\\RestHandler->handleResource(Array)\",\"17 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Services/BaseRestService.php(110): DreamFactory\\\\Core\\\\Components\\\\RestHandler->handleRequest(Object(DreamFactory\\\\Core\\\\Utility\\\\ServiceRequest), 'session')\",\"18 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(218): DreamFactory\\\\Core\\\\Services\\\\BaseRestService->handleRequest(Object(DreamFactory\\\\Core\\\\Utility\\\\ServiceRequest), 'session')\",\"19 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Http/Controllers/RestController.php(133): DreamFactory\\\\Core\\\\Http\\\\Controllers\\\\RestController->handleService('v2', 'user', 'session')\",\"20 [internal function]: DreamFactory\\\\Core\\\\Http\\\\Controllers\\\\RestController->handlePOST('v2', 'user', 'session')\",\"21 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)\",\"22 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\\\\Routing\\\\Controller->callAction('handlePOST', Array)\",\"23 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\\\\Routing\\\\ControllerDispatcher->dispatch(Object(Illuminate\\\\Routing\\\\Route), Object(DreamFactory\\\\Core\\\\Http\\\\Controllers\\\\RestController), 'handlePOST')\",\"24 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\\\\Routing\\\\Route->runController()\",\"25 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\\\\Routing\\\\Route->run()\",\"26 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\\\Routing\\\\Router->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"27 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Http/Middleware/AccessCheck.php(89): Illuminate\\\\Routing\\\\Pipeline->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"28 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): DreamFactory\\\\Core\\\\Http\\\\Middleware\\\\AccessCheck->handle(Object(Illuminate\\\\Http\\\\Request), Object(Closure))\",\"29 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\Pipeline\\\\Pipeline->Illuminate\\\\Pipeline\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"30 /opt/dreamfactory/vendor/dreamfactory/df-core/src/Http/Middleware/AuthCheck.php(234): Illuminate\\\\Routing\\\\Pipeline->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"31 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): DreamFactory\\\\Core\\\\Http\\\\Middleware\\\\AuthCheck->handle(Object(Illuminate\\\\Http\\\\Request), Object(Closure))\",\"32 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\Pipeline\\\\Pipeline->Illuminate\\\\Pipeline\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"33 /opt/dreamfactory/vendor/barryvdh/laravel-cors/src/HandleCors.php(42): Illuminate\\\\Routing\\\\Pipeline->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"34 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Barryvdh\\\\Cors\\\\HandleCors->handle(Object(Illuminate\\\\Http\\\\Request), Object(Closure))\",\"35 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\Pipeline\\\\Pipeline->Illuminate\\\\Pipeline\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"36 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\\\\Routing\\\\Pipeline->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"37 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(576): Illuminate\\\\Pipeline\\\\Pipeline->then(Object(Closure))\",\"38 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(535): Illuminate\\\\Routing\\\\Router->runRouteWithinStack(Object(Illuminate\\\\Routing\\\\Route), Object(Illuminate\\\\Http\\\\Request))\",\"39 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Router.php(513): Illuminate\\\\Routing\\\\Router->dispatchToRoute(Object(Illuminate\\\\Http\\\\Request))\",\"40 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\\\\Routing\\\\Router->dispatch(Object(Illuminate\\\\Http\\\\Request))\",\"41 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\\\Foundation\\\\Http\\\\Kernel->Illuminate\\\\Foundation\\\\Http\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"42 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\\\Routing\\\\Pipeline->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"43 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\\\\Foundation\\\\Http\\\\Middleware\\\\ValidatePostSize->handle(Object(Illuminate\\\\Http\\\\Request), Object(Closure))\",\"44 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\Pipeline\\\\Pipeline->Illuminate\\\\Pipeline\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"45 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\\\\Routing\\\\Pipeline->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"46 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\\\\Foundation\\\\Http\\\\Middleware\\\\CheckForMaintenanceMode->handle(Object(Illuminate\\\\Http\\\\Request), Object(Closure))\",\"47 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\\\Pipeline\\\\Pipeline->Illuminate\\\\Pipeline\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"48 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\\\\Routing\\\\Pipeline->Illuminate\\\\Routing\\\\{closure}(Object(Illuminate\\\\Http\\\\Request))\",\"49 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\\\\Pipeline\\\\Pipeline->then(Object(Closure))\",\"50 /opt/dreamfactory/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\\\Foundation\\\\Http\\\\Kernel->sendRequestThroughRouter(Object(Illuminate\\\\Http\\\\Request))\",\"51 /opt/dreamfactory/public/index.php(53): Illuminate\\\\Foundation\\\\Http\\\\Kernel->handle(Object(Illuminate\\\\Http\\\\Request))\",\"52 {main}\"]}}`"},"comment":{"url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/comments/377616958","html_url":"https://github.com/dreamfactorysoftware/dreamfactory/issues/163#issuecomment-377616958","issue_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/163","id":377616958,"user":{"login":"jacotri77","id":25497611,"avatar_url":"https://avatars2.githubusercontent.com/u/25497611?v=4","gravatar_id":"","url":"https://api.github.com/users/jacotri77","html_url":"https://github.com/jacotri77","followers_url":"https://api.github.com/users/jacotri77/followers","following_url":"https://api.github.com/users/jacotri77/following{/other_user}","gists_url":"https://api.github.com/users/jacotri77/gists{/gist_id}","starred_url":"https://api.github.com/users/jacotri77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jacotri77/subscriptions","organizations_url":"https://api.github.com/users/jacotri77/orgs","repos_url":"https://api.github.com/users/jacotri77/repos","events_url":"https://api.github.com/users/jacotri77/events{/privacy}","received_events_url":"https://api.github.com/users/jacotri77/received_events","type":"User","site_admin":false},"created_at":"2018-03-30T20:35:30Z","updated_at":"2018-03-30T20:35:30Z","author_association":"NONE","body":"Thanks @luizzz .  I think I misunderstood your original post  Are you saying when you try to login to DF at midnight, you got the weird error?"}}
{"actor":{"display_login":"jacotri77"}}