Re: How to fix this error

A "not null constraint failed" is in the error message. So you have a field which is not being set and the database itself is complaining.

It looks like you have extended the user profile to include a foreign key to "babyinfo" and that is empty apparently.

Either change the model to allow a null field or make sure that it is filled in.

hth

- Tom

On May 24, 2021, at 6:01 AM, Hugh Frost <mohansaravanan111@gmail.com> wrote:

Request Method: POST Request URL: http://127.0.0.1:8000/profile/ Django Version: 3.1.7 Python Version: 3.9.2 Installed Applications: ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'bootstrap4', 'crispy_forms', 'userapp', 'rest_framework', 'rest_framework.authtoken'] Installed Middleware: ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware'] Traceback (most recent call last): File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) The above exception (NOT NULL constraint failed: userapp_profile.babyinfo_id) was the direct cause of the following exception: File "D:\envi\lib\site-packages\django\core\handlers\exception.py", line 47, in inner response = get_response(request) File "D:\envi\lib\site-packages\django\core\handlers\base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "D:\project_kuttystory\userapp\views.py", line 35, in detail baby_form2.save() File "D:\envi\lib\site-packages\django\forms\models.py", line 460, in save self.instance.save() File "D:\envi\lib\site-packages\django\db\models\base.py", line 753, in save self.save_base(using=using, force_insert=force_insert, File "D:\envi\lib\site-packages\django\db\models\base.py", line 790, in save_base updated = self._save_table( File "D:\envi\lib\site-packages\django\db\models\base.py", line 895, in _save_table results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) File "D:\envi\lib\site-packages\django\db\models\base.py", line 933, in _do_insert return manager._insert( File "D:\envi\lib\site-packages\django\db\models\manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "D:\envi\lib\site-packages\django\db\models\query.py", line 1254, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "D:\envi\lib\site-packages\django\db\models\sql\compiler.py", line 1397, in execute_sql cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 98, in execute return super().execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) Exception Type: IntegrityError at /profile/ Exception Value: NOT NULL constraint failed: userapp_profile.babyinfo_id

Request Method: POST Request URL: http://127.0.0.1:8000/profile/ Django Version: 3.1.7 Python Version: 3.9.2 Installed Applications: ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'bootstrap4', 'crispy_forms', 'userapp', 'rest_framework', 'rest_framework.authtoken'] Installed Middleware: ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware'] Traceback (most recent call last): File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) The above exception (NOT NULL constraint failed: userapp_profile.babyinfo_id) was the direct cause of the following exception: File "D:\envi\lib\site-packages\django\core\handlers\exception.py", line 47, in inner response = get_response(request) File "D:\envi\lib\site-packages\django\core\handlers\base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "D:\project_kuttystory\userapp\views.py", line 35, in detail baby_form2.save() File "D:\envi\lib\site-packages\django\forms\models.py", line 460, in save self.instance.save() File "D:\envi\lib\site-packages\django\db\models\base.py", line 753, in save self.save_base(using=using, force_insert=force_insert, File "D:\envi\lib\site-packages\django\db\models\base.py", line 790, in save_base updated = self._save_table( File "D:\envi\lib\site-packages\django\db\models\base.py", line 895, in _save_table results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) File "D:\envi\lib\site-packages\django\db\models\base.py", line 933, in _do_insert return manager._insert( File "D:\envi\lib\site-packages\django\db\models\manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "D:\envi\lib\site-packages\django\db\models\query.py", line 1254, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "D:\envi\lib\site-packages\django\db\models\sql\compiler.py", line 1397, in execute_sql cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 98, in execute return super().execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) Exception Type: IntegrityError at /profile/ Exception Value: NOT NULL constraint failed: userapp_profile.babyinfo_id

Request Method: POST Request URL: http://127.0.0.1:8000/profile/ Django Version: 3.1.7 Python Version: 3.9.2 Installed Applications: ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'bootstrap4', 'crispy_forms', 'userapp', 'rest_framework', 'rest_framework.authtoken'] Installed Middleware: ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware'] Traceback (most recent call last): File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) The above exception (NOT NULL constraint failed: userapp_profile.babyinfo_id) was the direct cause of the following exception: File "D:\envi\lib\site-packages\django\core\handlers\exception.py", line 47, in inner response = get_response(request) File "D:\envi\lib\site-packages\django\core\handlers\base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "D:\project_kuttystory\userapp\views.py", line 35, in detail baby_form2.save() File "D:\envi\lib\site-packages\django\forms\models.py", line 460, in save self.instance.save() File "D:\envi\lib\site-packages\django\db\models\base.py", line 753, in save self.save_base(using=using, force_insert=force_insert, File "D:\envi\lib\site-packages\django\db\models\base.py", line 790, in save_base updated = self._save_table( File "D:\envi\lib\site-packages\django\db\models\base.py", line 895, in _save_table results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) File "D:\envi\lib\site-packages\django\db\models\base.py", line 933, in _do_insert return manager._insert( File "D:\envi\lib\site-packages\django\db\models\manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "D:\envi\lib\site-packages\django\db\models\query.py", line 1254, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "D:\envi\lib\site-packages\django\db\models\sql\compiler.py", line 1397, in execute_sql cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 98, in execute return super().execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) Exception Type: IntegrityError at /profile/ Exception Value: NOT NULL constraint failed: userapp_profile.babyinfo_id

Request Method: POST Request URL: http://127.0.0.1:8000/profile/ Django Version: 3.1.7 Python Version: 3.9.2 Installed Applications: ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'bootstrap4', 'crispy_forms', 'userapp', 'rest_framework', 'rest_framework.authtoken'] Installed Middleware: ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware'] Traceback (most recent call last): File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) The above exception (NOT NULL constraint failed: userapp_profile.babyinfo_id) was the direct cause of the following exception: File "D:\envi\lib\site-packages\django\core\handlers\exception.py", line 47, in inner response = get_response(request) File "D:\envi\lib\site-packages\django\core\handlers\base.py", line 181, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "D:\project_kuttystory\userapp\views.py", line 35, in detail baby_form2.save() File "D:\envi\lib\site-packages\django\forms\models.py", line 460, in save self.instance.save() File "D:\envi\lib\site-packages\django\db\models\base.py", line 753, in save self.save_base(using=using, force_insert=force_insert, File "D:\envi\lib\site-packages\django\db\models\base.py", line 790, in save_base updated = self._save_table( File "D:\envi\lib\site-packages\django\db\models\base.py", line 895, in _save_table results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw) File "D:\envi\lib\site-packages\django\db\models\base.py", line 933, in _do_insert return manager._insert( File "D:\envi\lib\site-packages\django\db\models\manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "D:\envi\lib\site-packages\django\db\models\query.py", line 1254, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "D:\envi\lib\site-packages\django\db\models\sql\compiler.py", line 1397, in execute_sql cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 98, in execute return super().execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "D:\envi\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\envi\lib\site-packages\django\db\backends\sqlite3\base.py", line 413, in execute return Database.Cursor.execute(self, query, params) Exception Type: IntegrityError at /profile/ Exception Value: NOT NULL constraint failed: userapp_profile.babyinfo_id

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/dabaaded-88bc-451d-adb6-0932548e0230n%40googlegroups.com.