Hi, 2 choice 1. erase de database y create again the migration:
$rm database && rm -r addressbook/migrations $./manage.py schemamigration addressbook --initial $./manage.py migrate 2. create manually fields owner_id enter terminal or console i see you use sqlite3 i recomended install this addons in firefox for managed database sqlite3 if you no like use console https://addons.mozilla.org/es/firefox/addon/sqlite-manager/ Cheers On Fri, Jun 6, 2014 at 1:57 AM, yutaka kobayashi < yutaka.kobaya...@todai-dream-net.com> wrote: > > 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_requiredfrom > django.utils.decorators import method_decoratorclass 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.5Exception Type: OperationalErrorException 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 451Python Executable: /usr/bin/pythonPython Version: 2.7.5Python > 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 > <http://127.0.0.1:8000/addressbook/#> > > - /Library/Python/2.7/site-packages/django/core/handlers/base.py in > get_response > 1. > > response = response.render() > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/response.py in > render > 1. > > self.content = self.rendered_content > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/response.py in > rendered_content > 1. > > content = template.render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/base.py in render > 1. > > return self._render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/base.py in _render > 1. > > return self.nodelist.render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/base.py in render > 1. > > bit = self.render_node(node, context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/debug.py in > render_node > 1. > > return node.render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/loader_tags.py in > render > 1. > > return compiled_parent._render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/base.py in _render > 1. > > return self.nodelist.render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/base.py in render > 1. > > bit = self.render_node(node, context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/debug.py in > render_node > 1. > > return node.render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/loader_tags.py in > render > 1. > > result = block.nodelist.render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/base.py in render > 1. > > bit = self.render_node(node, context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/debug.py in > render_node > 1. > > return node.render(context) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/template/defaulttags.py in > render > 1. > > len_values = len(values) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/models/query.py in > __len__ > 1. > > self._fetch_all() > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/models/query.py in > _fetch_all > 1. > > self._result_cache = list(self.iterator()) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/models/query.py in > iterator > 1. > > for row in compiler.results_iter(): > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /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 <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/models/sql/compiler.py > in execute_sql > 1. > > cursor.execute(sql, params) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/backends/util.py in > execute > 1. > > return super(CursorDebugWrapper, self).execute(sql, params) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/backends/util.py in > execute > 1. > > return self.cursor.execute(sql, params) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/utils.py in __exit__ > 1. > > six.reraise(dj_exc_type, dj_exc_value, traceback) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/backends/util.py in > execute > 1. > > return self.cursor.execute(sql, params) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > - /Library/Python/2.7/site-packages/django/db/backends/sqlite3/base.py > in execute > 1. > > return Database.Cursor.execute(self, query, params) > > ... > ▶ Local vars <http://127.0.0.1:8000/addressbook/#> > > > > > > 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+unsubscr...@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 > <https://groups.google.com/d/msgid/django-users/f695c7f8-29b7-4f49-8497-807627775497%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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+unsubscr...@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/CAM-7rO06Tm%3DfAZKUooAD3g%3D%3DikBi%2B3dpmsx9M2jAvRxvXwrnaQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
