AgileVentures / AgileVentures/MetPlus_tracker

Address delete bug

Ouverte
#722 2 commentaires 0 réactions 0 personnes assignées Voir sur GitHub
bug
Langage dominant
Aucune donnée de langage
Étoiles
2
Forks
5
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

This exception occurred in production:
```
ERROR: update or delete on table "addresses" violates foreign key constraint "fk_rails_c3132b644e" on table "jobs" DETAIL: Key (id)=(2) is still referenced from table "jobs". : DELETE FROM "addresses" WHERE "addresses"."id" = $1
```
So, an address associated with one or more jobs is being destroyed, and the model associations do not allow for that.

Possible fix - add the following association to the Address model:
```
has_many :jobs, dependent: :nullify
```

Note: the above fixes the address destroy problem in the rails console - that is, destroying an address that is associated with one or more jobs does not raise an exception, and does set the address_id (foreign key in "jobs" table) to `nil`, as the association statement specifies. However, I have not run all tests so confirm that this does not break anything else.

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.