Django Programming Error for checkbox

Question

I keep getting this error on form submission:

Exception Type:     ProgrammingError
Exception Value:    column "location_completed" of relation "core_dailyprogress" does not exist

My model looks likes this:

class DailyProgress(BaseModel):
    location_completed = models.BooleanField(default=False, blank=True)

My form is as follows:

class DailyProgressForm(forms.ModelForm):
    location_completed = forms.BooleanField(required=False, initial=False)

    class Meta:
        model = DailyProgress
        fields = '__all__'
        widgets = {
          'location_completed': forms.CheckboxInput(),
        }

Finally, my template is:

<label>{{ form.location_completed }} Location Completed</label>

Richard Price · Accepted Answer · 2015-12-30 10:05:54Z

2

Your code looks fine. You should probably check to see if this database table has this column (as the error message implies) or if you have migrations that have not yet run.

answered Dec 30, 2015 at 10:05

Richard Price

886 bronze badges

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

Comments

Peter Hinson · Accepted Answer · 2015-12-30 10:07:11Z

1

Typically that error indicates a Database issue. By chance have you by chance recently added location_completed without a migration? There's a weird issue with Postges on Django 1.8+ that sometimes fails to alter tables after migrations. Are you able to access location_completed from the shell?

Also, I believe you can simplify your form code to:

class DailyProgressForm(forms.ModelForm):
    location_completed = forms.BooleanField(required=False, initial=False)

    class Meta:
        model = DailyProgress

Since CheckboxInput is the default widget for forms.BooleanField.

answered Dec 30, 2015 at 10:07

Peter Hinson

1036 bronze badges

1 Comment

Sourabh Dev Over a year ago

I had to run a pending migration.

Collectives™ on Stack Overflow

Django Programming Error for checkbox

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related