juliancasaburi / HomeSwitchHome

HomeSwitchHome | [PHP Laravel 5.8] Proyecto grupal para la materia Ingeniería de Software II 2019 - UNLP Informática (3º año)
3 stars 0 forks source link

QueryException al eliminar una semana #15

Closed juliancasaburi closed 5 years ago

juliancasaburi commented 5 years ago

Al intentar eliminar una semana cuya respectiva subasta se encuentra soft deleted, se produce la siguiente excepción

[2019-06-21 12:09:06] local.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`u280573530_hsh`.`subastas`, CONSTRAINT `subastas_semana_id_foreign` FOREIGN KEY (`semana_id`) REFERENCES `semanas` (`id`)) (SQL: delete from `semanas` where `id` = 14) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`u280573530_hsh`.`subastas`, CONSTRAINT `subastas_semana_id_foreign` FOREIGN KEY (`semana_id`) REFERENCES `semanas` (`id`)) (SQL: delete from `semanas` where `id` = 14) at C:\\Users\\MC\\Desktop\\HomeSwitchHome\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:664, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`u280573530_hsh`.`subastas`, CONSTRAINT `subastas_semana_id_foreign` FOREIGN KEY (`semana_id`) REFERENCES `semanas` (`id`)) at C:\\Users\\MC\\Desktop\\HomeSwitchHome\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:483)

https://github.com/juliancasaburi/HomeSwitchHome/blob/48d547e2e0119bcd17f05285ab50ab0bf72a6905/app/Http/Controllers/AdminController.php#L338-L362