₦airaland Forum

Am getting intergrity error on django. Can you guys help identify the problem.

The error is telling you that you failed to provide input for a field that could not be null in the database. The field is author_id.

ogunsinamayowa:
The error is telling you that you failed to provide input for a field that could not be null in the database. The field is author_id.

But i thought the author id is auto incremented?

use stackoverflow.

First I'd ask you what did you do last while it was working fine?

I would probably guess you added a property to your model, if that's the case you have to delete your migration and manage.py makemigration and then migrate BUT
NOTE:
Only of you on development on production you might loss you database
Try that if it works let us know here

sparkle7:
But i thought the author id is auto incremented?

Yes and no. In your case, because you want to override the django inbuilt object instance id, you need to put primary_key=True on the field of author_id and it would automatic. You need to populate the field and it cannot be null. I couldn't see author_id field in your model. Perhaps, you have deleted the field without updating the database(makemigrations).

Try importing get_user_model from django.contrib.auth and replacing settings.AUTH_USER_MODEL with get_user_model(). You're probably getting the issue cause you didnt set settings. AUTH_USER_MODEL

The error is in your views.py file

The post_new function is where the issue lies.

The reason you are getting the error is because whenever you want to save a new post, the author id is set as NULL which is not supposed to be.

To solve the issue

where you had

post = form.save(commit='false')

Change it to
post = form.save(commit=False)

False should be a boolean value type not a string.. Hope that helps..

Contact me on fb for questions regarding Django
fb.com/onasanyatunde