OperationalError at /product/
no such table: product_sellableitem
Request Method: GET
Request URL: http://localhost:8000/product/
Django Version: 1.10.1
Exception Type: OperationalError
Exception Value:
no such table: product_sellableitem
Exception Location: /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py in execute, line 337
Python Executable: /home/nelson/Projects/amadaa/ENV/bin/python
Python Version: 3.4.3
Python Path:
['/home/nelson/Projects/amadaa',
'/usr/lib/python3.4',
'/usr/lib/python3.4/plat-x86_64-linux-gnu',
'/usr/lib/python3.4/lib-dynload',
'/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages']
Server time: Thu, 13 Oct 2016 03:56:09 +0000
Error during template rendering
In template /home/nelson/Projects/amadaa/product/templates/product/product_list.html, error at line 7
no such table: product_sellableitem
1 {% extends "product/product_base.html" %}
2 {% load bootstrap3 %}
3
4 {% block content %}
5
Products
6
7 {% for product in products %}
8 {% if forloop.first %}
9
10
11
Product name
12
Category
13
Edit
14
Delete
15
16 {% endif %}
17
Traceback Switch to copy-and-paste view
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute
return self.cursor.execute(sql, params) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py in execute
return Database.Cursor.execute(self, query, params) ...
▶ Local vars
The above exception (no such table: product_sellableitem) was the direct cause of the following exception:
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/core/handlers/exception.py in inner
response = get_response(request) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/core/handlers/base.py in _get_response
response = self.process_exception_by_middleware(e, request) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/core/handlers/base.py in _get_response
response = response.render() ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/response.py in render
self.content = self.rendered_content ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/response.py in rendered_content
content = template.render(context, self._request) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/backends/django.py in render
return self.template.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render
return self._render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render
return self.nodelist.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render
bit = node.render_annotated(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated
return self.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render
return compiled_parent._render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render
return self.nodelist.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render
bit = node.render_annotated(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated
return self.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render
return compiled_parent._render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render
return self.nodelist.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render
bit = node.render_annotated(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated
return self.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render
return compiled_parent._render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render
return self.nodelist.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render
bit = node.render_annotated(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated
return self.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render
result = block.nodelist.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render
bit = node.render_annotated(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated
return self.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render
result = block.nodelist.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render
bit = node.render_annotated(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated
return self.render(context) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/defaulttags.py in render
len_values = len(values) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/query.py in len
self._fetch_all() ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/query.py in _fetch_all
self._result_cache = list(self.iterator()) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/query.py in iter
results = compiler.execute_sql() ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/sql/compiler.py in execute_sql
cursor.execute(sql, params) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute
return super(CursorDebugWrapper, self).execute(sql, params) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute
return self.cursor.execute(sql, params) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/utils.py in exit
six.reraise(dj_exc_type, dj_exc_value, traceback) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/utils/six.py in reraise
raise value.with_traceback(tb) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute
return self.cursor.execute(sql, params) ...
▶ Local vars
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py in execute
return Database.Cursor.execute(self, query, params) ...
▶ Local vars
Request information
OperationalError at /product/ no such table: product_sellableitem Request Method: GET Request URL: http://localhost:8000/product/ Django Version: 1.10.1 Exception Type: OperationalError Exception Value:
no such table: product_sellableitem Exception Location: /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py in execute, line 337 Python Executable: /home/nelson/Projects/amadaa/ENV/bin/python Python Version: 3.4.3 Python Path:
['/home/nelson/Projects/amadaa', '/usr/lib/python3.4', '/usr/lib/python3.4/plat-x86_64-linux-gnu', '/usr/lib/python3.4/lib-dynload', '/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages'] Server time: Thu, 13 Oct 2016 03:56:09 +0000 Error during template rendering
In template /home/nelson/Projects/amadaa/product/templates/product/product_list.html, error at line 7 no such table: product_sellableitem 1 {% extends "product/product_base.html" %} 2 {% load bootstrap3 %} 3
4 {% block content %} 5
Products
67 {% for product in products %} 8 {% if forloop.first %} 9
Traceback Switch to copy-and-paste view
/home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute return self.cursor.execute(sql, params) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py in execute return Database.Cursor.execute(self, query, params) ... ▶ Local vars The above exception (no such table: product_sellableitem) was the direct cause of the following exception: /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/core/handlers/exception.py in inner response = get_response(request) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/core/handlers/base.py in _get_response response = self.process_exception_by_middleware(e, request) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/core/handlers/base.py in _get_response response = response.render() ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/response.py in render self.content = self.rendered_content ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/response.py in rendered_content content = template.render(context, self._request) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/backends/django.py in render return self.template.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render return self._render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render return self.nodelist.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render bit = node.render_annotated(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated return self.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render return compiled_parent._render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render return self.nodelist.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render bit = node.render_annotated(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated return self.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render return compiled_parent._render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render return self.nodelist.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render bit = node.render_annotated(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated return self.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render return compiled_parent._render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in _render return self.nodelist.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render bit = node.render_annotated(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated return self.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render result = block.nodelist.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render bit = node.render_annotated(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated return self.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/loader_tags.py in render result = block.nodelist.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render bit = node.render_annotated(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/base.py in render_annotated return self.render(context) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/template/defaulttags.py in render len_values = len(values) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/query.py in len self._fetch_all() ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/query.py in _fetch_all self._result_cache = list(self.iterator()) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/query.py in iter results = compiler.execute_sql() ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/models/sql/compiler.py in execute_sql cursor.execute(sql, params) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute return super(CursorDebugWrapper, self).execute(sql, params) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute return self.cursor.execute(sql, params) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/utils.py in exit six.reraise(dj_exc_type, dj_exc_value, traceback) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/utils/six.py in reraise raise value.with_traceback(tb) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/utils.py in execute return self.cursor.execute(sql, params) ... ▶ Local vars /home/nelson/Projects/amadaa/ENV/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py in execute return Database.Cursor.execute(self, query, params) ... ▶ Local vars Request information
USER admin GET No GET data POST No POST data FILES No FILES data COOKIES Variable Value csrftoken
<_io.TextIOWrapper name=''PZpuZFZs1oJHB2zEAIiHUSV6XLsvQlqR9hxGLpRW9nzl4Hgujnhcy7PE4ZW1qR73' sessionid
'xu7qsb9n0ct7zzh9y962hq7b0j199gj0' META Variable Value CLUTTER_IM_MODULE
'xim' COLORTERM
'gnome-terminal' CONTENT_LENGTH
'' CONTENT_TYPE
'text/plain' CSRF_COOKIE 'PZpuZFZs1oJHB2zEAIiHUSV6XLsvQlqR9hxGLpRW9nzl4Hgujnhcy7PE4ZW1qR73' DBUS_SESSION_BUS_ADDRESS
'unix:abstract=/tmp/dbus-sQoI1Z0kgK' DEFAULTS_PATH
'/usr/share/gconf/zorin_desktop.default.path' DESKTOP_SESSION 'zorin_desktop' DISPLAY ':0.0' DJANGO_SETTINGS_MODULE
'amadaa.settings' GATEWAY_INTERFACE
'CGI/1.1' GDMSESSION
'zorin_desktop' GDM_LANG
'en_US' GNOME_DESKTOP_SESSION_ID
'this-is-deprecated' GNOME_KEYRING_CONTROL
'/run/user/1000/keyring-ExlQdY' GNOME_KEYRING_PID
'6072' GPG_AGENT_INFO
'/run/user/1000/keyring-ExlQdY/gpg:0:1' GTK_IM_MODULE
'ibus' GTK_MODULES 'overlay-scrollbar:unity-gtk-module' HOME
'/home/nelson' HTTPACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/_;q=0.8' HTTP_ACCEPT_ENCODING
'gzip, deflate, sdch' HTTP_ACCEPT_LANGUAGE
'en-US,en;q=0.8' HTTP_CONNECTION 'keep-alive' HTTP_COOKIE ('sessionid=xu7qsb9n0ct7zzh9y962hq7b0j199gj0; ' 'csrftoken=PZpuZFZs1oJHB2zEAIiHUSV6XLsvQlqR9hxGLpRW9nzl4Hgujnhcy7PE4ZW1qR73') HTTP_HOST
'localhost:8000' HTTP_REFERER
'http://localhost:8000/' HTTP_UPGRADE_INSECURE_REQUESTS
'1' HTTP_USER_AGENT ('Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) ' 'Chrome/53.0.2785.143 Safari/537.36') IM_CONFIG_PHASE '1' INSTANCE
'' JOB 'dbus' LANG
'en_US.UTF-8' LANGUAGE
'en_US' LESSCLOSE
'/usr/bin/lesspipe %s %s' LESSOPEN
'| /usr/bin/lesspipe %s' LOGNAME 'nelson' LSCOLORS
'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.lzma=01;31:.tlz=01;31:.txz=01;31:.zip=01;31:.z=01;31:.Z=01;31:.dz=01;31:.gz=01;31:.lz=01;31:.xz=01;31:.bz2=01;31:.bz=01;31:.tbz=01;31:.tbz2=01;31:.tz=01;31:.deb=01;31:.rpm=01;31:.jar=01;31:.war=01;31:.ear=01;31:.sar=01;31:.rar=01;31:.ace=01;31:.zoo=01;31:.cpio=01;31:.7z=01;31:.rz=01;31:.jpg=01;35:.jpeg=01;35:.gif=01;35:.bmp=01;35:.pbm=01;35:.pgm=01;35:.ppm=01;35:.tga=01;35:.xbm=01;35:.xpm=01;35:.tif=01;35:.tiff=01;35:.png=01;35:.svg=01;35:.svgz=01;35:.mng=01;35:.pcx=01;35:.mov=01;35:.mpg=01;35:.mpeg=01;35:.m2v=01;35:.mkv=01;35:.webm=01;35:.ogm=01;35:.mp4=01;35:.m4v=01;35:.mp4v=01;35:.vob=01;35:.qt=01;35:.nuv=01;35:.wmv=01;35:.asf=01;35:.rm=01;35:.rmvb=01;35:.flc=01;35:.avi=01;35:.fli=01;35:.flv=01;35:.gl=01;35:.dl=01;35:.xcf=01;35:.xwd=01;35:.yuv=01;35:.cgm=01;35:.emf=01;35:.axv=01;35:.anx=01;35:.ogv=01;35:.ogx=01;35:.aac=00;36:.au=00;36:.flac=00;36:.mid=00;36:.midi=00;36:.mka=00;36:.mp3=00;36:.mpc=00;36:.ogg=00;36:.ra=00;36:.wav=00;36:.axa=00;36:.oga=00;36:.spx=00;36:_.xspf=00;36:' MANDATORY_PATH
'/usr/share/gconf/zorin_desktop.mandatory.path' OLDPWD
'/home/nelson' ORBIT_SOCKETDIR '/tmp/orbit-nelson' PATH
'/home/nelson/Projects/amadaa/ENV/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games' PATH_INFO
'/product/' PS1 ('(ENV) [\e]0;\u@\h: ' '\w\a]${debian_chroot:+($debian_chroot)}\u@\h:\w\$ ') PWD '/home/nelson/Projects/amadaa' QT4_IM_MODULE
'xim' QT_IM_MODULE
'ibus' QT_QPA_PLATFORMTHEME
'appmenu-qt5' QUERY_STRING
'' REMOTE_ADDR '127.0.0.1' REMOTE_HOST '' REQUEST_METHOD
'GET' RUN_MAIN
'true' SCRIPT_NAME '' SELINUX_INIT
'YES' SERVER_NAME 'localhost' SERVER_PORT '8000' SERVER_PROTOCOL 'HTTP/1.1' SERVER_SOFTWARE 'WSGIServer/0.2' SESSION 'zorin_desktop' SESSIONTYPE 'gnome-session' SESSION_MANAGER 'local/Nelson-Zorin-OS9:@/tmp/.ICE-unix/6236,unix/Nelson-Zorin-OS9:/tmp/.ICE-unix/6236' SHELL
'/bin/bash' SHLVL
'1' SSH_AUTH_SOCK
'/run/user/1000/keyring-ExlQdY/ssh' TERM
'xterm' TEXTDOMAIN
'im-config' TEXTDOMAINDIR
'/usr/share/locale/' TZ
'UTC' UPSTART_SESSION 'unix:abstract=/com/ubuntu/upstart-session/1000/6076' USER
'nelson' VIRTUAL_ENV '/home/nelson/Projects/amadaa/ENV' VTE_VERSION '3409' WINDOWID
'62914574' XAUTHORITY
'/home/nelson/.Xauthority' XDG_CONFIG_DIRS '/etc/xdg/xdg-zorin_desktop:/usr/share/upstart/xdg:/etc/xdg' XDG_CURRENT_DESKTOP 'Unity' XDG_DATA_DIRS
'/usr/share/zorin_desktop:/usr/share/gnome:/usr/local/share/:/usr/share/' XDG_GREETER_DATA_DIR
'/var/lib/lightdm-data/nelson' XDG_MENU_PREFIX 'gnome-' XDG_RUNTIME_DIR '/run/user/1000' XDG_SEAT
'seat0' XDG_SEAT_PATH
'/org/freedesktop/DisplayManager/Seat0' XDG_SESSION_ID
'c2' XDG_SESSION_PATH
'/org/freedesktop/DisplayManager/Session0' XDGVTNR
'7' XMODIFIERS
'@im=ibus'
'./manage.py' wsgi.errors
Looks like you haven't migrated the db.
You might even have to scrap the old db and recreate it with manage.py migrate
i am closing this issue