views:

380

answers:

0

I am trying to write a facebook app where user can see the status history of his friends. Everything seems to work fine until I try to save the status information in my DB. here is code :

   class UserStatus(models.Model):
        facebookid = models.IntegerField()
        time = models.IntegerField()
        status_msg = models.CharField(max_length = 2000)



@facebook.require_login()
 def canvas(request):
    # Get the User object 
    user, created = FacebookUser.objects.get_or_create(id = request.facebook.uid)
    user_lastname = request.facebook.users.getInfo([request.facebook.uid], ['last_name'])[0]['last_name']
    query = "SELECT time,message FROM status WHERE uid=%s" % request.facebook.uid
    result = request.facebook.fql.query(query)

So result give me all the information of the status. so my problem is its give error when I try to save it.

 userstatus = UserStatus()
  for item in result:
  userstatus.facebookid = request.facebook.uid
  userstatus.time = item.time


userstatus.msg = item.message
  userstatus.save()

error: Errors while loading page from application

Received HTTP error code 500 while loading

So how can I fix this.

thanks.