Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I want to remove null=True from a TextField:

-    footer=models.TextField(null=True, blank=True)
+    footer=models.TextField(blank=True, default="")

I created a schema migration:

manage.py schemamigration fooapp --auto

Since some footer columns contain NULL I get this error if I run the migration:

django.db.utils.IntegrityError: column "footer" contains null values

I added this to the schema migration:

    for sender in orm["fooapp.EmailSender"].objects.filter(footer=None):
        sender.footer=""
        sender.save()

Now I get:

django.db.utils.DatabaseError: cannot ALTER TABLE "fooapp_emailsender" because it has pending trigger events

What is wrong?

👻 Read also: what is the best laptop for engineering students?

Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events __del__: Questions

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

from time import sleep
sleep(0.1) # Time in seconds

Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events __del__: Questions

We hope this article has helped you to resolve the problem. Apart from Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

• Italiano Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Deutsch Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Français Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Español Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Türk Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Русский Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Português Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Polski Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• Nederlandse Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• 中文 Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• 한국어 Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• 日本語 Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
• हिन्दी Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events