How do I fix django.db.utils.OperationalError: no such table: when migrations don’t work?
Good day everyone, I’m a new intern and I’m trying to learn Django. I was tasked with looking over this new branch of the project that was recently updated. I downloaded a zip file from the github and I used this command python manage.py runserver then I got this error message django.db.utils.OperationalError: no such table: streaming_data_streaminginfo
I tried using this command python manage.py makemigrations streaming_data but I’m still getting the same error. I tried python manage.py showmigrations and got the exact same error. Another possible solution is to delete and recreate the database but I don’t want to mess with the database.
My supervisor told me to make a super user and connect on the admin page with my login credentials and go look at the tables. When I used python manage.py createsuperuser I got the django.db.utils.OperationalError: no such table: streaming_data_streaminginfo error again. So, I went to an older branch and opened the admin page, but I didn’t see the tables. Here's the complete error message
PS C:\Users\OneDrive\Documents\music_data-map> python manage.py runserver
Watching for file changes with StatReloader
Performing system checks...
Exception in thread django-main-thread:
Traceback (most recent call last):
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute
return super().execute(query, params)
~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
sqlite3.OperationalError: no such table: streaming_data_streaminginfo
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\AppData\Local\Programs\Python\Python313\Lib\threading.py", line 1041, in _bootstrap_inner
self.run()
~~~~~~~~^^
File "C:\Users\AppData\Local\Programs\Python\Python313\Lib\threading.py", line 992, in run
self._target(*self._args, **self._kwargs)
~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\utils\autoreload.py", line 64, in wrapper
fn(*args, **kwargs)
~~^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\core\management\commands\runserver.py", line 133, in inner_run
self.check(display_num_errors=True)
~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\core\management\base.py", line 485, in check
all_issues = checks.run_checks(
app_configs=app_configs,
...<2 lines>...
databases=databases,
)
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\core\checks\registry.py", line 88, in run_checks
new_errors = check(app_configs=app_configs, databases=databases)
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\core\checks\urls.py", line 14, in check_url_config
return check_resolver(resolver)
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\core\checks\urls.py", line 24, in check_resolver
return check_method()
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\urls\resolvers.py", line 494, in check
for pattern in self.url_patterns:
^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\utils\functional.py", line 57, in __get__
res = instance.__dict__[self.name] = self.func(instance)
~~~~~~~~~^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\urls\resolvers.py", line 715, in url_patterns
patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)
^^^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\utils\functional.py", line 57, in __get__
res = instance.__dict__[self.name] = self.func(instance)
~~~~~~~~~^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\urls\resolvers.py", line 708, in urlconf_module
return import_module(self.urlconf_name)
File "C:\Users\AppData\Local\Programs\Python\Python313\Lib\importlib\__init__.py", line 88, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<frozen importlib._bootstrap>", line 1387, in _gcd_import
File "<frozen importlib._bootstrap>", line 1360, in _find_and_load
File "<frozen importlib._bootstrap>", line 1331, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 935, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 1022, in exec_module
File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
File "C:\Users\OneDrive\Documents\music_data-map\music_data\urls.py", line 26, in <module>
path('', include('dashboard.urls', namespace='dashboard')),
~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\urls\conf.py", line 38, in include
urlconf_module = import_module(urlconf_module)
File "C:\Users\AppData\Local\Programs\Python\Python313\Lib\importlib\__init__.py", line 88, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<frozen importlib._bootstrap>", line 1387, in _gcd_import
File "<frozen importlib._bootstrap>", line 1360, in _find_and_load
File "<frozen importlib._bootstrap>", line 1331, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 935, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 1022, in exec_module
File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
File "C:\Users\OneDrive\Documents\music_data-map\dashboard\urls.py", line 2, in <module>
from .views import dashboard_view#, upload_file_view
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\dashboard\views.py", line 9, in <module>
import dashboard.dashbd
File "C:\Users\OneDrive\Documents\music_data-map\dashboard\dashbd.py", line 9, in <module>
df = pd.DataFrame(StreamingInfo.objects.values_list('listener__location').annotate(Count('listener__location')).exclude(listener__location="nan"))
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\pandas\core\frame.py", line 843, in __init__
data = list(data)
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\models\query.py", line 398, in __iter__
self._fetch_all()
~~~~~~~~~~~~~~~^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\models\query.py", line 1881, in _fetch_all
self._result_cache = list(self._iterable_class(self))
~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\models\query.py", line 246, in __iter__
return compiler.results_iter(
~~~~~~~~~~~~~~~~~~~~~^
tuple_expected=True,
^^^^^^^^^^^^^^^^^^^^
chunked_fetch=self.chunked_fetch,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
chunk_size=self.chunk_size,
^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\models\sql\compiler.py", line 1513, in results_iter
results = self.execute_sql(
MULTI, chunked_fetch=chunked_fetch, chunk_size=chunk_size
)
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\models\sql\compiler.py", line 1562, in execute_sql
cursor.execute(sql, params)
~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\utils.py", line 102, in execute
return super().execute(sql, params)
~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\utils.py", line 67, in execute
return self._execute_with_wrappers(
~~~~~~~~~~~~~~~~~~~~~~~~~~~^
sql, params, many=False, executor=self._execute
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\utils.py", line 84, in _execute
with self.db.wrap_database_errors:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "C:\Users\OneDrive\Documents\music_data-map\venv\Lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute
return super().execute(query, params)
~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
django.db.utils.OperationalError: no such table: streaming_data_streaminginfo