Geek Answers Handbook

"Unknown column" user_id "error in django view

I have a mistake when I'm not sure what caused it.

Here is the error:

Exception Type:     OperationalError
Exception Value:    
(1054, "Unknown column 'user_id' in 'field list'")

Does anyone know why I am getting this error? I can not understand. Everything seems to be in order.

My view code is below:

if "login" in request.session:
    t = request.POST.get('title', '')
    d = request.POST.get('description', '')
    fid = request.session["login"]
    fuser = User.objects.get(id=fid)
    i = Idea(user=fuser, title=t, description=d, num_votes=1)
    i.save()
    return HttpResponse("true", mimetype="text/plain")
else:
    return HttpResponse("false", mimetype="text/plain")

I appreciate any help! Thanks!

Edit: also a question. I use objects.get (id = or objects.get (pk =? If I use a primary key, do I need to declare an id field or an index in the model?

Edit: Here are the relevant models:

class User (models.Model):
    first_name = models.CharField(max_length=200)
    last_name = models.CharField(max_length=200)
    email = models.CharField(max_length=200)
    password = models.CharField(max_length=200)

class Idea (models.Model):
    user = models.ForeignKey(User)
    title = models.CharField(max_length=200)
    description = models.CharField(max_length=255)
    num_votes = models.IntegerField()
+5
source share
3 answers

, , , Idea user_id? SQL?

+4

  • user_id - FK Idea User. , , .

    , syncdb.

  • id. id . pk.

    , id. pk .

+5

Yes, I dropped the tables and everything worked out fine. However, you should really go into the database and KILL them. "manage.py flush" or "manage.py reset appname" will not do this themselves.

-Nick O

0
source

More articles:


All Articles