Postgresql DatabaseError column with django

Question

I am trying to find a solution to this error I keep getting:

column posts_post.slug does not exist

LINE 1: SELECT "posts_post"."id", "posts_post"."title", "posts_post"...

Does anyone know what might be causing this?

Here is the full error output: http://dpaste.com/813336/

    from django.db import models
    from django.contrib.auth.models import User
    from datetime import datetime

    class Category(models.Model):
    name = models.CharField(max_length=60)
    def __unicode__(self):
        return self.name

   class Tags(models.Model):
    name = models.CharField(max_length=60)
    def __unicode__(self):
        return self.name

   class Post(models.Model):
    title = models.CharField(max_length=120)
    slug = models.SlugField(max_length=120, unique=True)
    description = models.TextField()
    body = models.TextField()
    published = models.DateTimeField(default=datetime.now)
    categories = models.ForeignKey(Category)
    tags = models.ManyToManyField(Tags)
    def __unicode__(self):
        return self.title
    class Meta:
        ordering = ['-published']
    def get_absolute_url(self):
         return "/%s/%s/%s" % (self.published.year, self.published.month, self.slug)

John Peters · Accepted Answer · 2012-10-13 20:22:09Z

2

Did you add the SlugField later? If so, a syncdb does not update existing database tables. Delete the entire table and re-do the syncdb.

answered Oct 13, 2012 at 20:22

John Peters

1,16916 silver badges24 bronze badges

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

Comments

Bruce · Accepted Answer · 2012-10-13 20:26:54Z

1

The error is quite simple - you don't have the column slug in the given database table. If you added it later in the model, syncdb doesn't modify the table (this operation can not be done automatically). For this purpose, use the South application which is a must have application for Django.

answered Oct 13, 2012 at 20:26

Bruce

1,3802 gold badges13 silver badges18 bronze badges

Collectives™ on Stack Overflow

Postgresql DatabaseError column with django

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related