search

Formation-Media / glowt-4-aegis-module

0 stars 0 forks source link

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`glowt4_aegis_staging`.`m_aegis_projects`, CONSTRAINT `m_aegis_projects_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `m_aegis_s #118

Closed formation-developers closed 1 year ago

formation-developers commented 1 year ago

There's been an error on https://staging.aegis.4.glowt.co.uk/stream/m/AEGIS/management/import.

Detail Value
Version 1.18.7
Message SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (glowt4_aegis_staging.m_aegis_projects, CONSTRAINT m_aegis_projects_scope_id_foreign FOREIGN KEY (scope_id) REFERENCES m_aegis_scopes (id)) (SQL: insert into m_aegis_projects (reference, added_by, company_id, description, name, scope_id, status, type_id, updated_at, created_at) values (ACS/3504, 1, 2, , IESS for Irish Rail - ISA SIL3 (SW ISA Only) [ACS3429], 66, 1, 8, 2022-12-14 16:10:58, 2022-12-14 16:10:58))
File /vendor/laravel/framework/src/Illuminate/Database/Connection.php
Line 760

Request

{
    "_GET": {
        "module": "AEGIS",
        "feature": "management",
        "page": "import",
        "id": null
    },
    "_token": "emmgOK5W48PDEY0pDW3eekTfpL6HXnZXWYwAoXOc"
}

Trace

#0 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Database/Connection.php(546): Illuminate\Database\Connection->run()
#2 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Database/Connection.php(498): Illuminate\Database\Connection->statement()
#3 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/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.staging/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3266): Illuminate\Database\Query\Processors\Processor->processInsertGetId()
#5 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1861): Illuminate\Database\Query\Builder->insertGetId()
#6 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1322): Illuminate\Database\Eloquent\Builder->__call()
#7 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1287): Illuminate\Database\Eloquent\Model->insertAndSetId()
#8 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1128): Illuminate\Database\Eloquent\Model->performInsert()
#9 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/app/Models/Base_Model.php(476): Illuminate\Database\Eloquent\Model->save()
#10 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/modules/AEGIS/Imports/StoreImport.php(113): Modules\AEGIS\Models\Project->save()
#11 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/modules/AEGIS/Http/Controllers/Stream/ManagementController.php(282): Modules\AEGIS\Imports\StoreImport->__construct()
#12 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/modules/AEGIS/Http/Controllers/Stream/ManagementController.php(146): Modules\AEGIS\Http\Controllers\Stream\ManagementController->store()
#13 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Modules\AEGIS\Http\Controllers\Stream\ManagementController->import()
#14 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/routes/web.php(188): Illuminate\Routing\Controller->callAction()
#15 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/symfony/http-foundation/StreamedResponse.php(92): Illuminate\Routing\RouteFileRegistrar->{closure}()
#16 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/symfony/http-foundation/Response.php(377): Symfony\Component\HttpFoundation\StreamedResponse->sendContent()
#17 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/vendor/laravel/framework/src/Illuminate/Support/HigherOrderTapProxy.php(34): Symfony\Component\HttpFoundation\Response->send()
#18 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis.staging/public/index.php(53): Illuminate\Support\HigherOrderTapProxy->__call()
#19 {main}