Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

yatogami's avatar

Illuminate\Database\QueryException thrown with message "SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails

Illuminate\Database\QueryException thrown with message "SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (laravelmlg.users, CONSTRAINT users_roles_id_foreign FOREIGN KEY (roles_id) REFERENCES users (id) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into users (username, name, email, password, roles_id, updated_at, created_at) values (firman, firman w, firmangetrich50@gmail.com, $2y$10$rtLCw2qRtheJl1sHEd462updY1xPa2dXDfAOxAuLV/kuqE1A7Rj7i, 2, 2017-11-28 06:26:05, 2017-11-28 06:26:05))"

Stacktrace: #64 Illuminate\Database\QueryException in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664 #63 PDOException in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458 #62 PDOStatement:execute in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458 #61 Illuminate\Database\Connection:Illuminate\Database{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Connection.php:657 #60 Illuminate\Database\Connection:runQueryCallback in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Connection.php:624 #59 Illuminate\Database\Connection:run in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Connection.php:459 #58 Illuminate\Database\Connection:statement in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Connection.php:411 #57 Illuminate\Database\Connection:insert in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php:32 #56 Illuminate\Database\Query\Processors\Processor:processInsertGetId in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2135 #55 Illuminate\Database\Query\Builder:insertGetId in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php:1270 #54 Illuminate\Database\Eloquent\Builder:__call in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:707 #53 Illuminate\Database\Eloquent\Model:insertAndSetId in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:672 #52 Illuminate\Database\Eloquent\Model:performInsert in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:535 #51 Illuminate\Database\Eloquent\Model:save in D:\PKL\xampp\htdocs\alvl\app\Http\Controllers\RegisterController.php:27 #50 App\Http\Controllers\RegisterController:postRegis in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Controller.php:54 #49 call_user_func_array in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Controller.php:54 #48 Illuminate\Routing\Controller:callAction in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php:45 #47 Illuminate\Routing\ControllerDispatcher:dispatch in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Route.php:212 #46 Illuminate\Routing\Route:runController in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Route.php:169 #45 Illuminate\Routing\Route:run in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Router.php:658 #44 Illuminate\Routing\Router:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30 #43 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php:41 #42 Illuminate\Routing\Middleware\SubstituteBindings:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #41 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #40 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php:67 #39 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #37 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php:49 #36 Illuminate\View\Middleware\ShareErrorsFromSession:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #34 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php:63 #33 Illuminate\Session\Middleware\StartSession:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #32 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #31 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php:37 #30 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #28 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php:59 #27 Illuminate\Cookie\Middleware\EncryptCookies:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #25 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:102 #24 Illuminate\Pipeline\Pipeline:then in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Router.php:660 #23 Illuminate\Routing\Router:runRouteWithinStack in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Router.php:635 #22 Illuminate\Routing\Router:runRoute in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Router.php:601 #21 Illuminate\Routing\Router:dispatchToRoute in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Router.php:590 #20 Illuminate\Routing\Router:dispatch in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:176 #19 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30 #18 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\fideloper\proxy\src\TrustProxies.php:56 #17 Fideloper\Proxy\TrustProxies:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #16 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #15 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:30 #14 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #12 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:30 #11 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #9 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php:27 #8 Illuminate\Foundation\Http\Middleware\ValidatePostSize:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #6 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php:46 #5 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:149 #4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53 #3 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:102 #2 Illuminate\Pipeline\Pipeline:then in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:151 #1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in D:\PKL\xampp\htdocs\alvl\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:116 #0 Illuminate\Foundation\Http\Kernel:handle in D:\PKL\xampp\htdocs\alvl\public\index.php:55

0 likes
3 replies
RamjithAp's avatar

Make sure your Roles table has a record with id 2. If not insert first roles in roles table and then try inserting user.

RamjithAp's avatar

Change this thread title related to your issue and accept the answer so that people having the same issue will find it useful.

Please or to participate in this conversation.