[Django] #35567: when i give add,update,delete in site it give IntegrityError at /admin/sites/site/add/ FOREIGN KEY constraint failed

[Django]

#35567: when i give add,update,delete in site it give IntegrityError at
/admin/sites/site/add/ FOREIGN KEY constraint failed
-------------------------------------------+------------------------
Reporter: Balavignesh | Owner: (none)
Type: Bug | Status: new
Component: Error reporting | Version: 5.0
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 1
UI/UX: 0 |
-------------------------------------------+------------------------
add by go into django/admin/site and give add delete or update it give
like this when i come back it same your changes is successfully done but
there is no changes done
IntegrityError at /admin/socialaccount/socialapp/add/
FOREIGN KEY constraint failed
Request Method: POST
Request URL: http://127.0.0.1:8000/admin/socialaccount/socialapp/add/
Django Version: 5.0.3
Exception Type: IntegrityError
Exception Value:
FOREIGN KEY constraint failed
Exception Location: C:\Users\Vicky\AppData\Roaming\Python\Python312
\site-packages\django\db\backends\base\base.py, line 299, in _commit
Raised during: django.contrib.admin.options.add_view
Python Executable: C:\Program Files\Python312\python.exe
Python Version: 3.12.2
Python Path:
['C:\\Users\\Vicky\\OneDrive\\Desktop\\IPL2\\IPL\\IPL_SITE',
'C:\\Program Files\\Python312\\python312.zip',
'C:\\Program Files\\Python312\\DLLs',
'C:\\Program Files\\Python312\\Lib',
'C:\\Program Files\\Python312',
'C:\\Users\\Vicky\\AppData\\Roaming\\Python\\Python312\\site-packages',
'C:\\Program Files\\Python312\\Lib\\site-packages']
Server time: Sat, 29 Jun 2024 10:05:12 +0000
Internal Server Error: /admin/socialaccount/socialapp/add/
Traceback (most recent call last):
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\db\backends\base\base.py", line 299, 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 "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\core\handlers\exception.py", line 55, in inner
response = get_response(request)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\core\handlers\base.py", line 197, in _get_response
response = wrapped_callback(request, *callback_args,
**callback_kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\contrib\admin\options.py", line 716, in wrapper
return self.admin_site.admin_view(view)(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\utils\decorators.py", line 188, in _view_wrapper
result = _process_exception(request, e)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\utils\decorators.py", line 186, in _view_wrapper
response = view_func(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\views\decorators\cache.py", line 80, in _view_wrapper
response = view_func(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\contrib\admin\sites.py", line 240, in inner
return view(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\contrib\admin\options.py", line 1945, in add_view
return self.changeform_view(request, None, form_url, extra_context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\utils\decorators.py", line 48, in _wrapper
return bound_method(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\utils\decorators.py", line 188, in _view_wrapper
result = _process_exception(request, e)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\utils\decorators.py", line 186, in _view_wrapper
response = view_func(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\contrib\admin\options.py", line 1803, in changeform_view
with transaction.atomic(using=router.db_for_write(self.model)):
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\db\transaction.py", line 263, in __exit__
connection.commit()
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\utils\asyncio.py", line 26, in inner
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\db\backends\base\base.py", line 323, in commit
self._commit()
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\db\backends\base\base.py", line 298, in _commit
with debug_transaction(self, "COMMIT"), self.wrap_database_errors:
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\db\utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Users\Vicky\AppData\Roaming\Python\Python312\site-
packages\django\db\backends\base\base.py", line 299, in _commit
return self.connection.commit()
^^^^^^^^^^^^^^^^^^^^^^^^
django.db.utils.IntegrityError: FOREIGN KEY constraint failed
[29/Jun/2024 15:35:12] "POST /admin/socialaccount/socialapp/add/ HTTP/1.1"
500 143983
--
Ticket URL: <https://code.djangoproject.com/ticket/35567>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#35567: when i give add,update,delete in site it give IntegrityError at
/admin/sites/site/add/ FOREIGN KEY constraint failed

---------------------------------+--------------------------------------

Reporter: Balavignesh | Owner: (none)
Type: Bug | Status: new
Component: Error reporting | Version: 5.0

Severity: Normal | Resolution:

Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0

---------------------------------+--------------------------------------
Changes (by Balavignesh):

* Attachment "django error.PNG" added.

[Django]

#35567: when i give add,update,delete in site it give IntegrityError at
/admin/sites/site/add/ FOREIGN KEY constraint failed
---------------------------------+--------------------------------------
Reporter: Balavignesh | Owner: (none)
Type: Bug | Status: new
Component: Error reporting | Version: 5.0
Severity: Normal | Resolution:
Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
---------------------------------+--------------------------------------
Changes (by Balavignesh):

* Attachment "django error2.PNG" added.

[Django]

#35567: when i give add,update,delete in site it give IntegrityError at
/admin/sites/site/add/ FOREIGN KEY constraint failed
---------------------------------+--------------------------------------
Reporter: Balavignesh | Owner: (none)

Type: Bug | Status: closed

Component: Error reporting | Version: 5.0

Severity: Normal | Resolution: invalid

Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
---------------------------------+--------------------------------------

Changes (by Jacob Walls):

* resolution: => invalid
* status: new => closed

Comment:

If you're having trouble understanding how Django works, see
[https://code.djangoproject.com/wiki/TicketClosingReasons/UseSupportChannels
TicketClosingReasons/UseSupportChannels] for ways to get help. Trac is not
a support channel.
--
Ticket URL: <https://code.djangoproject.com/ticket/35567#comment:1>