PHP Laravel Errror = Duplicate Entry

Duplicate entry '0' for key 'PRIMARY' (SQL: insert into `dm_badorder_hdr` (`created_by`, `create_dt`, `company_id`, `status`) values (64, 2022-10-04 14:34:26, 1, SAVED)) in C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Database\Connection.php:631 Stack trace: #0 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Database\Connection.php(587): Illuminate\Database\Connection->runQueryCallback('insert into `dm...', Array, Object(Closure)) #1 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Database\Connection.php(370): Illuminate\Database\Connection->run('insert into `dm...', Array, Object(Closure)) #2 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Database\Connection.php(327): Illuminate\Database\Connection->statement('insert into `dm...', Array) #3 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(30): Illuminate\Database\Connection->insert('insert into `dm...', Array) #4 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1910): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `dm...', Array, NULL) #5 C:\xampp\htdocs\dunamis\app\controllers\DunamisController.php(3730): Illuminate\Database\Query\Builder->insertGetId(Array) #6 [internal function]: DunamisController->saveBadOrder() #7 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(231): call_user_func_array(Array, Array) #8 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(93): Illuminate\Routing\Controller->callAction('saveBadOrder', Array) #9 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(62): Illuminate\Routing\ControllerDispatcher->call(Object(DunamisController), Object(Illuminate\Routing\Route), 'saveBadOrder') #10 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Routing\Router.php(967): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'DunamisControll...', 'saveBadOrder') #11 [internal function]: Illuminate\Routing\Router->Illuminate\Routing\{closure}() #12 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Routing\Route.php(109): call_user_func_array(Object(Closure), Array) #13 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1033): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #14 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #15 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(781): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #16 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #17 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #18 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #19 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #20 C:\xampp\htdocs\dunamis\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #21 C:\xampp\htdocs\dunamis\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #22 C:\xampp\htdocs\dunamis\public\index.php(49): Illuminate\Foundation\Application->run() #23 {main} [] [] --- Solution: - Double Check your Table make sure that it is set to Auto Increment. Truncate Table to reset Auto Increment Primary Key.

Comments