django null value in column violates not-null constraint postgres

Question

I am attempting to have a form that a user can upload multiple images on their blog. When the user submits the form I get the error null value in column "post_id" of relation "blog_postimages" violates not-null constraint The form has a foreign key to the blogpost. What confuses me is that the value is not null and I am using it else where (pk). I am running a postgres db

view

def DetailPostView(request, pk):
    model = Post
    post = Post.objects.get(pk=pk)

    if request.method == 'POST':
        test = PostImagesForm(request.POST, request.FILES)
        files = request.FILES.getlist('images')
        if test.is_valid():
            for f in files:
                test.save(commit=False)
                test.post = Post.objects.get(pk=pk)
                test.save()
        else:
            print(PostImagesForm.errors)
             

    context = {
        'post':post, 'PostImagesForm':PostImagesForm,
        }
    return render(request, 'blog/post_detail.html', context)

models

class Post(models.Model):
    title = models.CharField(max_length=100)
    image = models.ImageField(default='default.jpg', upload_to='hero_car_image')
    content = RichTextUploadingField(blank=True, null=True)
    date_posted = models.DateTimeField(default=timezone.now)
    author = models.ForeignKey(User, on_delete=models.CASCADE)

class PostImages(models.Model):
    post = models.ForeignKey('Post', on_delete=models.CASCADE)
    images = models.ImageField(upload_to='post_images')
    date_posted = models.DateTimeField(default=timezone.now)

I do not have any unapplied migrations and I am positive I am calling it properly. Even if I hard code in a number it still errors out.

form

class PostImagesForm(ModelForm):
    class Meta:
        model = PostImages
        fields = ('images',)
        widgets = {
            'images': forms.ClearableFileInput(attrs={'multiple': True}),
        }

Brian Destura · Accepted Answer · 2021-07-20 00:57:28Z

1

You should be updating the instance and not the form, so:

instance = test.save(commit=False)
instance.post = Post.objects.get(pk=pk)
instance.save()

No need for test.save()

answered Jul 20, 2021 at 0:57

Brian Destura

12.1k3 gold badges22 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Wazy Over a year ago

THANK YOU SO MUCH. This allows the form to submit properly but it only uploads one image. Any idea why the for loop is not functioning properly?

Brian Destura Over a year ago

Can you share your form?

Brian Destura Over a year ago

Also I think that should be a new question

Wazy Over a year ago

Form added, yes it should probably be a new question, I spent at least 4 hours on this so just happy to have some help!

Brian Destura Over a year ago

I'm not totally sure if images in PostImages model can support multiple images or just one file. Maybe that can be your question. Anyway, you can try debugging it to see what files has? And how are you getting the images?

Collectives™ on Stack Overflow

django null value in column violates not-null constraint postgres

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related