Deleting a game with active servers causes error

NickToony / gameserver-service

A simple Laravel backend and Bootstrap frontend for viewing and managing server lists.

MIT License

2 stars 0 forks source link

Deleting a game with active servers causes error #4

Closed NickToony closed 9 years ago

NickToony commented 9 years ago

This is caused by a constraint on the foreign key.

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (gameservers_serv.statistics, CONSTRAINTstatistics_game_id_foreignFOREIGN KEY (game_id) REFERENCESgames(id)) (SQL: delete fromgameswhereid= 1)

NickToony commented 9 years ago

This issue was also present on statistics table.