Friday, June 6, 2014

OperationalError happening after giving authorization to the class based view

hello I'm quite new to django and I'm working on it through following tutorials and stuff.

I'm currently working on this tutorial

http://effectivedjango.com/tutorial/authzn.html

I'm following the exact code on this page (this page was written for django1.5 so actually I amended a few things to match for django1.6)

It goes perfectly well untill making login page and giving authentication to the user.

But when it comes to giving authorization like below it gives an error

from django.contrib.auth.decorators import login_required  from django.utils.decorators import method_decorator  class LoggedInMixin(object):        @method_decorator(login_required)      def dispatch(self, *args, **kwargs):          return super(LoggedInMixin, self).dispatch(*args, **kwargs)

class ListContactView(LoggedInMixin, ListView):        model = Contact      template_name = 'contact_list.html'        def get_queryset(self):            return Contact.objects.filter(owner=self.request.user)

the error message is like this

OperationalError at /addressbook/

no such column: contacts_contact.owner_id

Request Method:	GET
Request URL:	http://127.0.0.1:8000/addressbook/
Django Version:	1.6.5
Exception Type:	OperationalError
Exception Value:	no such column: contacts_contact.owner_id
Exception Location:	/Library/Python/2.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 451
Python Executable:	/usr/bin/python
Python Version:	2.7.5
Python Path:	['/Users/kobayashiyutaka/Documents/shannonlab/addressbook', '/Library/Python/2.7/site-packages/openpyxl-1.6.2-py2.7.egg', '/Library/Python/2.7/site-packages/setuptools-1.1.6-py2.7.egg', '/Library/Python/2.7/site-packages/httplib2-0.8-py2.7.egg', '/Library/Python/2.7/site-packages/oauth2-1.5.211-py2.7.egg', '/Library/Python/2.7/site-packages/python_twitter-1.1-py2.7.egg', '/Library/Python/2.7/site-packages/requests_oauthlib-0.4.0-py2.7.egg', '/Library/Python/2.7/site-packages/requests-2.0.0-py2.7.egg', '/Library/Python/2.7/site-packages/oauthlib-0.6.0-py2.7.egg', '/Library/Python/2.7/site-packages/South-0.8.4-py2.7.egg', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-darwin', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac/lib-scriptpackages', '/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload', '/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyObjC', '/Library/Python/2.7/site-packages']
Server time:	Wed, 4 Jun 2014 14:55:13 +0000

Error during template rendering

In template /Users/kobayashiyutaka/Documents/shannonlab/addressbook/contacts/templates/contacts/contact_list.html, error at line 7

no such column: contacts_contact.owner_id

1	{% extends "base.html" %}
2
3	{% block content %}
4	<h1>contact list</h1>
5
6	<ul style="list-style-type: none">
7	{% for contact in object_list %}
8	<li class="contact">
9	<a href="{{ contact.get_absolute_url }}">{{ contact }}</a>
10	(<a href="{% url "contacts-edit" pk=contact.id %}">edit</a>)
11	</li>
12	{% endfor %}
13	</ul>
14
15	<a href="{% url "contacts-new" %}">add contact</a>
16	{% endblock %}
17

Traceback Switch to copy-and-paste view

/Library/Python/2.7/site-packages/django/core/handlers/base.py in get_response
1. ```
                response = response.render()
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/response.py in render
1. ```
            self.content = self.rendered_content
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/response.py in rendered_content
1. ```
        content = template.render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/base.py in render
1. ```
            return self._render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/base.py in _render
1. ```
        return self.nodelist.render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/base.py in render
1. ```
                bit = self.render_node(node, context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/debug.py in render_node
1. ```
            return node.render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/loader_tags.py in render
1. ```
        return compiled_parent._render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/base.py in _render
1. ```
        return self.nodelist.render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/base.py in render
1. ```
                bit = self.render_node(node, context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/debug.py in render_node
1. ```
            return node.render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/loader_tags.py in render
1. ```
            result = block.nodelist.render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/base.py in render
1. ```
                bit = self.render_node(node, context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/debug.py in render_node
1. ```
            return node.render(context)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/template/defaulttags.py in render
1. ```
        len_values = len(values)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/models/query.py in __len__
1. ```
        self._fetch_all()
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/models/query.py in _fetch_all
1. ```
            self._result_cache = list(self.iterator())
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/models/query.py in iterator
1. ```
        for row in compiler.results_iter():
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/models/sql/compiler.py in results_iter
1. ```
        for rows in self.execute_sql(MULTI):
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/models/sql/compiler.py in execute_sql
1. ```
        cursor.execute(sql, params)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/backends/util.py in execute
1. ```
            return super(CursorDebugWrapper, self).execute(sql, params)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/backends/util.py in execute
1. ```
                return self.cursor.execute(sql, params)
```
  ...
▶ Local vars

/Library/Python/2.7/site-packages/django/db/utils.py in __exit__

                six.reraise(dj_exc_type, dj_exc_value, traceback)

...

▶ Local vars

/Library/Python/2.7/site-packages/django/db/backends/util.py in execute
1. ```
                return self.cursor.execute(sql, params)
```
  ...
▶ Local vars
/Library/Python/2.7/site-packages/django/db/backends/sqlite3/base.py in execute
1. ```
        return Database.Cursor.execute(self, query, params)
```
  ...
▶ Local vars

some guys on stack over flow were suggesting to resync the database or use south so, I tried both but it didn't work.

when I tried to migrate(though I don't know what it is) the database using south it gave me an error below

error message

django.db.utils.OperationalError: table "contacts_contact" already exists

OK so there is a table but no colums in it.what does that suppose to mean and what can I do to solve this problem?

Please help me

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/f695c7f8-29b7-4f49-8497-807627775497%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Django talk

Friday, June 6, 2014

OperationalError happening after giving authorization to the class based view

OperationalError at /addressbook/

Error during template rendering

no such column: contacts_contact.owner_id

Traceback Switch to copy-and-paste view

No comments:

Post a Comment

Followers

Blog Archive

About Me