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
Post a Comment