search

expresspixel / estatezilla

A lightweight open-source Real Estate CMS
http://estatezilla.com/
85 stars 48 forks source link

registerd page comes error after put all, its not registed user on front web page #37

Open 9804701373 opened 6 years ago

9804701373 commented 6 years ago

Whoops, looks like something went wrong. 2/2 QueryException in Connection.php line 624: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.username (SQL: insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (chandan.kandar@gmail.com, y$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa, jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI, 2018-08-23 22:32:54, 2018-08-23 22:32:54)) in Connection.php line 624 at Connection->runQueryCallback('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54'), object(Closure)) in Connection.php line 580 at Connection->run('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54'), object(Closure)) in Connection.php line 363 at Connection->statement('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54')) in Connection.php line 320 at Connection->insert('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54')) in Processor.php line 30 at Processor->processInsertGetId(object(Builder), 'insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54'), 'id') in Builder.php line 1725 at Builder->insertGetId(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id') at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id')) in Builder.php line 933 at Builder->__call('insertGetId', array(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id')) in Model.php line 1609 at Builder->insertGetId(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id') in Model.php line 1609 at Model->insertAndSetId(object(Builder), array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54')) in Model.php line 1579 at Model->performInsert(object(Builder), array()) in Model.php line 1485 at Model->save() in Model.php line 529 at Model::create(array('name' => 'Chandan kandar', 'email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI')) in Registrar.php line 40 at Registrar->create(array('_token' => 'oDCDnH0bZd6rP0VfMoBnENxf56xZCk1I9xtR3xyv', 'name' => 'Chandan kandar', 'email' => 'chandan.kandar@gmail.com', 'password' => 'kandar098#', 'password_confirmation' => 'kandar098#', 'coupon' => '')) in AuthenticatesAndRegistersUsers.php line 50 at AuthController->postRegister(object(Request)) at call_user_func_array(array(object(AuthController), 'postRegister'), array(object(Request))) in Controller.php line 246 at Controller->callAction('postRegister', array(object(Request))) in ControllerDispatcher.php line 162 at ControllerDispatcher->call(object(AuthController), object(Route), 'postRegister') in ControllerDispatcher.php line 107 at ControllerDispatcher->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in RedirectIfAuthenticated.php line 41 at RedirectIfAuthenticated->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108 at ControllerDispatcher->callWithinStack(object(AuthController), object(Route), object(Request), 'postRegister') in ControllerDispatcher.php line 67 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\User\AuthController', 'postRegister') in Route.php line 204 at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134 at Route->run(object(Request)) in Router.php line 701 at Router->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in VerifyCsrfToken.php line 43 at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17 at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 at Pipeline->then(object(Closure)) in Router.php line 703 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 670 at Router->dispatchToRoute(object(Request)) in Router.php line 628 at Router->dispatch(object(Request)) in Kernel.php line 214 at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in OAuthExceptionHandlerMiddleware.php line 19 at OAuthExceptionHandlerMiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in ShareErrorsFromSession.php line 55 at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in StartSession.php line 61 at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in EncryptCookies.php line 40 at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in CheckForMaintenanceMode.php line 42 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 at Pipeline->then(object(Closure)) in Kernel.php line 115 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84 at Kernel->handle(object(Request)) in server.php line 53 at require_once('C:\wamp64\www\real-estate\server.php') in index.php line 12 1/2 PDOException in Connection.php line 362: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.username in Connection.php line 362 at PDOStatement->execute(array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54')) in Connection.php line 362 at Connection->Illuminate\Database{closure}(object(SQLiteConnection), 'insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54')) in Connection.php line 616 at Connection->runQueryCallback('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54'), object(Closure)) in Connection.php line 580 at Connection->run('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54'), object(Closure)) in Connection.php line 363 at Connection->statement('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54')) in Connection.php line 320 at Connection->insert('insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54')) in Processor.php line 30 at Processor->processInsertGetId(object(Builder), 'insert into "users" ("email", "password", "confirmation_code", "updated_at", "created_at") values (?, ?, ?, ?, ?)', array('chandan.kandar@gmail.com', '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', '2018-08-23 22:32:54', '2018-08-23 22:32:54'), 'id') in Builder.php line 1725 at Builder->insertGetId(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id') at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id')) in Builder.php line 933 at Builder->__call('insertGetId', array(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id')) in Model.php line 1609 at Builder->insertGetId(array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54'), 'id') in Model.php line 1609 at Model->insertAndSetId(object(Builder), array('email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI', 'updated_at' => '2018-08-23 22:32:54', 'created_at' => '2018-08-23 22:32:54')) in Model.php line 1579 at Model->performInsert(object(Builder), array()) in Model.php line 1485 at Model->save() in Model.php line 529 at Model::create(array('name' => 'Chandan kandar', 'email' => 'chandan.kandar@gmail.com', 'password' => '$2y$10$uOGlP5xjl6CCWtJ1vm7bnOiLFlvzzaZPU2AD5OMWZCLelUlyEfTsa', 'confirmation_code' => 'jAKr7eycVm6WMtMed2e6gZg5kWaEaBxI')) in Registrar.php line 40 at Registrar->create(array('_token' => 'oDCDnH0bZd6rP0VfMoBnENxf56xZCk1I9xtR3xyv', 'name' => 'Chandan kandar', 'email' => 'chandan.kandar@gmail.com', 'password' => 'kandar098#', 'password_confirmation' => 'kandar098#', 'coupon' => '')) in AuthenticatesAndRegistersUsers.php line 50 at AuthController->postRegister(object(Request)) at call_user_func_array(array(object(AuthController), 'postRegister'), array(object(Request))) in Controller.php line 246 at Controller->callAction('postRegister', array(object(Request))) in ControllerDispatcher.php line 162 at ControllerDispatcher->call(object(AuthController), object(Route), 'postRegister') in ControllerDispatcher.php line 107 at ControllerDispatcher->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in RedirectIfAuthenticated.php line 41 at RedirectIfAuthenticated->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108 at ControllerDispatcher->callWithinStack(object(AuthController), object(Route), object(Request), 'postRegister') in ControllerDispatcher.php line 67 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\User\AuthController', 'postRegister') in Route.php line 204 at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134 at Route->run(object(Request)) in Router.php line 701 at Router->Illuminate\Routing{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in VerifyCsrfToken.php line 43 at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17 at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 at Pipeline->then(object(Closure)) in Router.php line 703 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 670 at Router->dispatchToRoute(object(Request)) in Router.php line 628 at Router->dispatch(object(Request)) in Kernel.php line 214 at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in OAuthExceptionHandlerMiddleware.php line 19 at OAuthExceptionHandlerMiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in ShareErrorsFromSession.php line 55 at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in StartSession.php line 61 at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in EncryptCookies.php line 40 at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in CheckForMaintenanceMode.php line 42 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125 at Pipeline->Illuminate\Pipeline{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 at Pipeline->then(object(Closure)) in Kernel.php line 115 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84 at Kernel->handle(object(Request)) in server.php line 53 at require_once('C:\wamp64\www\real-estate\server.php') in index.php line 12