Django : Ограничение FOREIGN KEY не сработало при удалении, но у меня нет никакого внешнего ключа в моей модели

Вот моя модель, какие объекты я не могу удалить :

class Broker(models.Model):
    code =              models.CharField(default="", max_length=100, blank=True)
    name =              models.CharField(default="", max_length=100, blank=True)
    email =             models.CharField(default="", max_length=100, blank=True)
    city =              models.CharField(default="", max_length=100, blank=True)
    address =           models.CharField(default="", max_length=100, blank=True)
    postal_code =       models.CharField(default="", max_length=100, blank=True)
    brokerage =         models.FloatField(default=0.00)

    class Meta:
         verbose_name = 'Broker'
         verbose_name_plural = 'Brokers'
         ordering = ['name']

    def __str__(self):
        return str(self.name)

Вот что создает мою ошибку (она возникает в строке, где я делаю rem.delete()):

if request.POST.get('action') == 'remove_element_selected':
    element_selected = request.POST.getlist('element_selected[]')
    for element_id in element_selected:
        rem = Broker.objects.get(id=element_id)
        rem.delete()
    return JsonResponse({})

А вот моя ошибка :

Internal Server Error: /brokers/
Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/backends/base/base.py", line 239, in _commit
    return self.connection.commit()
sqlite3.IntegrityError: FOREIGN KEY constraint failed

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/core/handlers/exception.py", line 34, in inner
    response = get_response(request)
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/core/handlers/base.py", line 126, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/core/handlers/base.py", line 124, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/sentry_sdk/integrations/django/views.py", line 67, in sentry_wrapped_callback
    return callback(request, *args, **kwargs)
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/contrib/auth/decorators.py", line 21, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "/Users/lucas/Desktop/myapp/app/views/views.py", line 636, in brokers
    rem.delete()
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/models/base.py", line 880, in delete
    return collector.delete()
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/models/deletion.py", line 306, in delete
    sender=model, instance=obj, using=self.using
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/transaction.py", line 212, in __exit__
    connection.commit()
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/backends/base/base.py", line 261, in commit
    self._commit()
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/backends/base/base.py", line 239, in _commit
    return self.connection.commit()
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/django/db/backends/base/base.py", line 239, in _commit
    return self.connection.commit()
django.db.utils.IntegrityError: FOREIGN KEY constraint failed

Вместе с тем, я использую Django 2.1.15 и python 3.7.9

Кроме того, я удалил все объекты, которые были связаны внешним ключом с моей моделью брокера.

Вернуться на верх