Scribd
Upload
5 views8 pages

Django Migration Integrity Error

Uploaded by

John CIRHUZA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views8 pages

Django Migration Integrity Error

Uploaded by

John CIRHUZA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PS C:\xampp\htdocs\aye_\new\vrai> python manage.

py makemigrations property_manager

Migrations for 'accounts':

accounts\migrations\0001_initial.py

+ Create model Profile

Migrations for 'property_manager':

property_manager\migrations\0004_alter_property_owner_delete_profile.py

~ Alter field owner on property

- Delete model Profile

PS C:\xampp\htdocs\aye_\new\vrai> python [Link] makemigrations accounts

No changes detected in app 'accounts'

PS C:\xampp\htdocs\aye_\new\vrai> python [Link] migrate

Operations to perform:

Apply all migrations: accounts, admin, auth, contenttypes, property_manager, sessions

Running migrations:

Applying accounts.0001_initial... OK

Applying property_manager.0004_alter_property_owner_delete_profile...Traceback (most recent


call last):

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\[Link]", line 105, in
_execute

return [Link](sql, params)

~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\mysql\[Link]", line 76, in

execute

return [Link](query, args)

~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 153, in execute

result = self._query(query)
File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 322, in _query

[Link](q)

~~~~~~~~~~^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 563, in query

self._affected_rows = self._read_query_result(unbuffered=unbuffered)

~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 825, in
_read_query_result

[Link]()

~~~~~~~~~~~^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 1199, in read

first_packet = [Link]._read_packet()

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 775, in
_read_packet

packet.raise_for_error()

~~~~~~~~~~~~~~~~~~~~~~^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 219, in
raise_for_error

err.raise_mysql_exception(self._data)

~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 150, in
raise_mysql_exception

raise errorclass(errno, errval)


[Link]: (1452, 'Cannot add or update a child row: a foreign key constraint fails
(`db`.`#sql-16c0_b`, CONSTRAINT `property_manager_pro_owner_id_d702f2a6_fk_accounts_`
FOREIGN KEY (`owner_id`) REFERENCES `accounts_profile` (`id`))')

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

Traceback (most recent call last):

File "C:\xampp\htdocs\aye_\new\vrai\[Link]", line 22, in <module>

main()

~~~~^^

File "C:\xampp\htdocs\aye_\new\vrai\[Link]", line 18, in main

execute_from_command_line([Link])

~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\core\management\__init__.py", line
442, in execute_from_command_line

[Link]()

~~~~~~~~~~~~~~~^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\core\management\__init__.py", line
436, in execute

self.fetch_command(subcommand).run_from_argv([Link])

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\core\management\[Link]", line 416, in
run_from_argv

[Link](*args, **cmd_options)

~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\core\management\[Link]", line 460, in
execute

output = [Link](*args, **options)


File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\core\management\[Link]", line 107, in
wrapper

res = handle_func(*args, **kwargs)

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-
packages\django\core\management\commands\[Link]", line 353, in handle

post_migrate_state = [Link](

targets,

...<3 lines>...

fake_initial=fake_initial,

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\migrations\[Link]", line 135, in
migrate

state = self._migrate_all_forwards(

state, plan, full_plan, fake=fake, fake_initial=fake_initial

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\migrations\[Link]", line 167, in
_migrate_all_forwards

state = self.apply_migration(

state, migration, fake=fake, fake_initial=fake_initial

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\migrations\[Link]", line 255, in
apply_migration

state = [Link](state, schema_editor)

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\migrations\[Link]", line 132,
in apply
operation.database_forwards(

~~~~~~~~~~~~~~~~~~~~~~~~~~~^

self.app_label, schema_editor, old_state, project_state

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\migrations\operations\[Link]",
line 241, in database_forwards

schema_editor.alter_field(from_model, from_field, to_field)

~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\base\[Link]", line
912, in alter_field

self._alter_field(

~~~~~~~~~~~~~~~~~^

model,

^^^^^^

...<6 lines>...

strict,

^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\base\[Link]", line
1269, in _alter_field

[Link](

~~~~~~~~~~~~^

self._create_fk_sql(model, new_field, "_fk_%(to_table)s_%(to_column)s")

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

)
^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\base\[Link]", line
204, in execute

[Link](sql, params)

~~~~~~~~~~~~~~^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\[Link]", line 122, in
execute

return super().execute(sql, params)

~~~~~~~~~~~~~~~^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\[Link]", line 79, in
execute

return self._execute_with_wrappers(

~~~~~~~~~~~~~~~~~~~~~~~~~~~^

sql, params, many=False, executor=self._execute

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\[Link]", line 92, in
_execute_with_wrappers

return executor(sql, params, many, context)

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\[Link]", line 100, in
_execute

with [Link].wrap_database_errors:

^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\[Link]", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\[Link]", line 105, in
_execute

return [Link](sql, params)

~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\django\db\backends\mysql\[Link]", line 76, in

execute

return [Link](query, args)

~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 153, in execute

result = self._query(query)

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 322, in _query

[Link](q)

~~~~~~~~~~^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 563, in query

self._affected_rows = self._read_query_result(unbuffered=unbuffered)

~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 825, in
_read_query_result

[Link]()

~~~~~~~~~~~^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 1199, in read

first_packet = [Link]._read_packet()
File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 775, in
_read_packet

packet.raise_for_error()

~~~~~~~~~~~~~~~~~~~~~~^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 219, in
raise_for_error

err.raise_mysql_exception(self._data)

~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^

File
"C:\Users\user\AppData\Local\Packages\[Link].3.13_qbz5n2kfra8p0\L
ocalCache\local-packages\Python313\site-packages\pymysql\[Link]", line 150, in
raise_mysql_exception

raise errorclass(errno, errval)

[Link]: (1452, 'Cannot add or update a child row: a foreign key constraint fails
(`db`.`#sql-16c0_b`, CONSTRAINT `property_manager_pro_owner_id_d702f2a6_fk_accounts_`
FOREIGN KEY (`owner_id`) REFERENCES `accounts_profile` (`id`))')

PS C:\xampp\htdocs\aye_\new\vrai>

You might also like