search

Formation-Media / glowt-4-aegis-module

0 stars 0 forks source link

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`admin_aegis`.`m_aegis_document_approval_item_details`, CONSTRAINT `m_aegis_document_approval_item_details_job_title_id_foreign` FOR #137

Open formation-developers opened 1 year ago

formation-developers commented 1 year ago

JM 01/02/2023 @ 12:21: When deleting job titles how should any associations be handled?

There's been an error on https://aegis.4.glowt.co.uk/ajax/m/AEGIS/management/delete_job_title.

Detail Value
Version 1.21.1
Message SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (admin_aegis.m_aegis_document_approval_item_details, CONSTRAINT m_aegis_document_approval_item_details_job_title_id_foreign FOREIGN KEY (job_title_id) REFERENCES m_aegis_job_titles () (SQL: delete fromm_aegis_job_titleswhereid` = 97)
File /vendor/laravel/framework/src/Illuminate/Database/Connection.php
Line 760

Request

{
    "id": "97",
    "_GET": {
        "module": "AEGIS",
        "feature": "management",
        "page": "job-titles",
        "id": null
    }
}

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(577): Illuminate\Database\Connection->run()
#2 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Connection.php(522): Illuminate\Database\Connection->affectingStatement()
#3 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3460): Illuminate\Database\Connection->delete()
#4 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1189): Illuminate\Database\Query\Builder->delete()
#5 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1449): Illuminate\Database\Eloquent\Builder->delete()
#6 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1394): Illuminate\Database\Eloquent\Model->performDeleteOnModel()
#7 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/modules/AEGIS/Http/Controllers/Ajax/ManagementController.php(73): Illuminate\Database\Eloquent\Model->delete()
#8 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Modules\AEGIS\Http\Controllers\Ajax\ManagementController->delete_job_title()
#9 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/routes/web.php(141): Illuminate\Routing\Controller->callAction()
#10 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/CallableDispatcher.php(40): Illuminate\Routing\RouteFileRegistrar->{closure}()
#11 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Route.php(237): Illuminate\Routing\CallableDispatcher->dispatch()
#12 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Route.php(208): Illuminate\Routing\Route->runCallable()
#13 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Routing\Route->run()
#14 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#15 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/app/Http/Middleware/RequestConversion.php(33): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#16 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\RequestConversion->handle()
#17 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/app/Http/Middleware/RequestIsAjax.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\RequestIsAjax->handle()
#19 /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}()
#20 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#21 /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}()
#22 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Auth\Middleware\Authenticate->handle()
#23 /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}()
#24 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#25 /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}()
#26 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#27 /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}()
#28 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#29 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle()
#30 /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}()
#31 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#32 /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}()
#33 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#34 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#35 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Pipeline\Pipeline->then()
#36 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\Routing\Router->runRouteWithinStack()
#37 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\Routing\Router->runRoute()
#38 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\Routing\Router->dispatchToRoute()
#39 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\Routing\Router->dispatch()
#40 /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}()
#41 /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}()
#42 /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()
#43 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#44 /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}()
#45 /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()
#46 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#47 /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}()
#48 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#49 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#50 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#51 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#52 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Fruitcake\Cors\HandleCors->handle()
#53 /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}()
#54 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle()
#55 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/app/Http/Middleware/Settings.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#56 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\Settings->handle()
#57 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#58 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\Pipeline\Pipeline->then()
#59 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#60 /var/www/vhosts/4.glowt.co.uk/ACCOUNTS/aegis/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle()
#61 {main}
formation-developers commented 1 year ago

Duplicated for https://aegis.4.glowt.co.uk/ajax/m/AEGIS/management/delete_job_title.

Version 1.21.1

formation-developers commented 10 months ago

Duplicated for https://aegis.4.glowt.co.uk/ajax/m/AEGIS/management/delete_job_title.

Version 2.0.2

formation-developers commented 10 months ago

Duplicated for https://aegis.4.glowt.co.uk/ajax/m/AEGIS/management/delete_job_title.

Version 2.0.2

formation-developers commented 6 months ago

Duplicated for https://aegis.4.glowt.co.uk/ajax/m/AEGIS/management/delete_job_title.

Version 2.0.2