Forums

django.db.utils.OperationalError: no such table: blog_category

Hello, I am new to python-django and pythonanywhere. I would like to deploy my first website on pythonanywhere. I followed these steps: https://help.pythonanywhere.com/pages/DeployExistingDjangoProject/ , but got an error when I want to setup a database. This is the error when I try "python manage.py migrate" What can I do to solve the error?

"Traceback (most recent call last): File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute return super().execute(query, params) sqlite3.OperationalError: no such table: blog_category The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/Livcamp/livcamp-nl/manage.py", line 23, in <module> main() File "/home/Livcamp/livcamp-nl/manage.py", line 19, in main execute_from_command_line(sys.argv) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/management/init.py", line 442, in execute_from_command_line utility.execute() File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/management/init.py", line 436, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/management/base.py", line 412, in run_from_argv self.execute(args, cmd_options) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/management/base.py", line 458, in execute output = self.handle(args, options) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/management/base.py", line 106, in wrapper res = handle_func(*args, kwargs) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 100, in handle self.check(databases=[database]) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/management/base.py", line 485, in check all_issues = checks.run_checks( File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/checks/registry.py", line 88, in run_checks new_errors = check(app_configs=app_configs, databases=databases) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/checks/urls.py", line 14, in check_url_config return check_resolver(resolver) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/core/checks/urls.py", line 24, in check_resolver return check_method() File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/urls/resolvers.py", line 494, in check cursor.execute(sql, params) for pattern in self.url_patterns: File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/utils/functional.py", line 57, in get res = instance.dict[self.name] = self.func(instance) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/urls/resolvers.py", line 715, in url_patterns patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/utils/functional.py", line 57, in get res = instance.dict[self.name] = self.func(instance) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/urls/resolvers.py", line 708, in urlconf_module return import_module(self.urlconf_name) File "/usr/local/lib/python3.9/importlib/init.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 680, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 850, in exec_module File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed File "/home/Livcamp/livcamp-nl/livcamp/urls.py", line 31, in <module> path('', include('blog.urls')), File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/urls/conf.py", line 38, in include urlconf_module = import_module(urlconf_module) File "/usr/local/lib/python3.9/importlib/init.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 680, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 850, in exec_module File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed File "/home/Livcamp/livcamp-nl/blog/urls.py", line 2, in <module> from . import views File "/home/Livcamp/livcamp-nl/blog/views.py", line 4, in <module> from .forms import PostForm, CommentForm File "/home/Livcamp/livcamp-nl/blog/forms.py", line 8, in <module> for item in choices: File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/models/query.py", line 398, in iter self._fetch_all() File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/models/query.py", line 1881, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/models/query.py", line 246, in iter return compiler.results_iter( File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1513, in results_iter results = self.execute_sql( File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql cursor.execute(sql, params) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/utils.py", line 102, in execute return super().execute(sql, params) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers( File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/utils.py", line 91, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/home/Livcamp/.virtualenvs/mysite-virtualenv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute return super().execute(query, params) django.db.utils.OperationalError: no such table: blog_category"

You have code somewhere that is trying to use the table at import time. So, when migrate imports Django, it tries to use the table, but it does not exist yet because you have not run migrate. Find that code (using the traceback) and make sure it does not run at import time.