search

Formation-Media / glowt-4-aegis-module

0 stars 0 forks source link

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'ACS/900088' for key 'm_aegis_project_variants_reference_unique' (SQL: insert into `m_aegis_project_variants` (`name`, `added_by`, `is_default`, `project_id`, `reference`, `variant_numbe #207

Open formation-developers opened 1 year ago

formation-developers commented 1 year ago

There's been an error on https://aegis.4.glowt.co.uk/a/m/AEGIS/projects/add.

Detail Value
Version 2.0.2
Message SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'ACS/900088' for key 'm_aegis_project_variants_reference_unique' (SQL: insert into m_aegis_project_variants (name, added_by, is_default, project_id, reference, variant_number, updated_at, created_at) values (Default, 133, 1, 2909, ACS/900088, 0, 2023-05-11 09:45:45, 2023-05-11 09:45:45))
File /vendor/laravel/framework/src/Illuminate/Database/Connection.php
Line 760

Request

{
    "_token": "O5uTt2FZRR43xdgnHTcmNbFqpCGF7NiHfXuQ2c0O",
    "_form_name": "project",
    "company_id": "2",
    "type": "25",
    "name": "OTM ETCS Approvals",
    "customer-autocomplete": "CAF Signalling",
    "customer": "953",
    "reference": "900088",
    "status": "1",
    "description": null,
    "add": "Add"
}

Trace

#0 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert()
#4 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId()
#5 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId()
#6 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1330): Illuminate\Database\Eloquent\Builder->__call()
#7 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId()
#8 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert()
#9 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/app/Models/Base_Model.php(477): Illuminate\Database\Eloquent\Model->save()
#10 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/modules/AEGIS/Http/Controllers/Store/ProjectsController.php(78): Modules\AEGIS\Models\ProjectVariant->save()
#11 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Modules\AEGIS\Http\Controllers\Store\ProjectsController->add()
#12 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/routes/web.php(81): Illuminate\Routing\Controller->callAction()
#13 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/CallableDispatcher.php(40): Illuminate\Routing\RouteFileRegistrar->{closure}()
#14 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Route.php(237): Illuminate\Routing\CallableDispatcher->dispatch()
#15 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Route.php(208): Illuminate\Routing\Route->runCallable()
#16 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Routing\Route->run()
#17 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#18 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#19 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#20 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Auth\Middleware\Authenticate->handle()
#22 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#24 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#25 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#26 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#28 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle()
#29 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#30 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#31 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#32 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#33 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Pipeline\Pipeline->then()
#35 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\Routing\Router->runRouteWithinStack()
#36 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\Routing\Router->runRoute()
#37 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\Routing\Router->dispatchToRoute()
#38 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\Routing\Router->dispatch()
#39 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#40 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#42 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#43 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#44 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#45 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#46 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#47 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#48 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#49 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#50 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#51 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Fruitcake\Cors\HandleCors->handle()
#52 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#53 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()
#54 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/app/Http/Middleware/Settings.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#55 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Settings->handle()
#56 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#57 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\Pipeline\Pipeline->then()
#58 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#59 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle()
#60 {main}
formation-developers commented 2 months ago

Duplicated for https://aegis.4.glowt.co.uk/a/m/AEGIS/projects/add.

Version 2.0.2

formation-developers commented 1 month ago

Duplicated for https://aegis.4.glowt.co.uk/a/m/AEGIS/projects/add.

Version 2.0.2