I tried to fix mysql problems in my database by dropping tables. When that
didnt work, I dropped the database.
I then recreated the database, and tried to run makemigrations. But I am
getting errors about missing tables:
joel@hp:~/myappointments$ python3 manage.py makemigrations
Traceback (most recent call last):
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/utils.py",
line 85, in _execute
return self.cursor.execute(sql, params)
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/mysql/base.py",
line 71, in execute
return self.cursor.execute(query, args)
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 250, in execute
self.errorhandler(self, exc, value)
File
"/home/joel/.local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 50, in defaulterrorhandler
raise errorvalue
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 247, in execute
res = self._query(query)
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 412, in _query
rowcount = self._do_query(q)
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 375, in _do_query
db.query(q)
File
"/home/joel/.local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 276, in query
_mysql.connection.query(self, query)
_mysql_exceptions.ProgrammingError: (1146, "Table
'appointmentsdj.appointments_doctor' doesn't exist")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 15, in <module>
execute_from_command_line(sys.argv)
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/management/__init__.py",
line 381, in execute_from_command_line
utility.execute()
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/management/__init__.py",
line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/management/base.py",
line 316, in run_from_argv
self.execute(*args, **cmd_options)
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/management/base.py",
line 350, in execute
self.check()
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/management/base.py",
line 379, in check
include_deployment_checks=include_deployment_checks,
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/management/base.py",
line 366, in _run_checks
return checks.run_checks(**kwargs)
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/checks/registry.py",
line 71, in run_checks
new_errors = check(app_configs=app_configs)
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/checks/urls.py",
line 40, in check_url_namespaces_unique
all_namespaces = _load_all_namespaces(resolver)
File
"/home/joel/.local/lib/python3.6/site-packages/django/core/checks/urls.py",
line 57, in _load_all_namespaces
url_patterns = getattr(resolver, 'url_patterns', [])
File
"/home/joel/.local/lib/python3.6/site-packages/django/utils/functional.py",
line 37, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File
"/home/joel/.local/lib/python3.6/site-packages/django/urls/resolvers.py",
line 533, in url_patterns
patterns = getattr(self.urlconf_module, "urlpatterns",
self.urlconf_module)
File
"/home/joel/.local/lib/python3.6/site-packages/django/utils/functional.py",
line 37, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File
"/home/joel/.local/lib/python3.6/site-packages/django/urls/resolvers.py",
line 526, in urlconf_module
return import_module(self.urlconf_name)
File "/usr/lib/python3.6/importlib/__init__.py", line 126, in
import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 994, in _gcd_import
File "<frozen importlib._bootstrap>", line 971, in _find_and_load
File "<frozen importlib._bootstrap>", line 955, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 665, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
File "/home/joel/myappointments/myappointments/urls.py", line 21, in
<module>
path('appointments/', include('appointments.urls')),
File "/home/joel/.local/lib/python3.6/site-packages/django/urls/conf.py",
line 34, in include
urlconf_module = import_module(urlconf_module)
File "/usr/lib/python3.6/importlib/__init__.py", line 126, in
import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 994, in _gcd_import
File "<frozen importlib._bootstrap>", line 971, in _find_and_load
File "<frozen importlib._bootstrap>", line 955, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 665, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in
_call_with_frames_removed
File "/home/joel/myappointments/appointments/urls.py", line 3, in <module>
from . import views
File "/home/joel/myappointments/appointments/views.py", line 6, in
<module>
from .forms import PatientForm, doctorform, AddAppointmentForm,
PatientFormReadOnly, EditAppointmentForm, BillItem, PatientMetaForm,
UnconfirmedApptMetaForm
File "/home/joel/myappointments/appointments/forms.py", line 68, in
<module>
class AddAppointmentFormReadOnly(forms.Form):
File "/home/joel/myappointments/appointments/forms.py", line 70, in
AddAppointmentFormReadOnly
for doc in doctor.objects.all():
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/models/query.py",
line 268, in __iter__
self._fetch_all()
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/models/query.py",
line 1183, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/models/query.py",
line 54, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch,
chunk_size=self.chunk_size)
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/models/sql/compiler.py",
line 1061, in execute_sql
cursor.execute(sql, params)
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/utils.py",
line 100, in execute
return super().execute(sql, params)
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/utils.py",
line 68, in execute
return self._execute_with_wrappers(sql, params, many=False,
executor=self._execute)
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/utils.py",
line 77, in _execute_with_wrappers
return executor(sql, params, many, context)
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/utils.py",
line 85, in _execute
return self.cursor.execute(sql, params)
File "/home/joel/.local/lib/python3.6/site-packages/django/db/utils.py",
line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/utils.py",
line 85, in _execute
return self.cursor.execute(sql, params)
File
"/home/joel/.local/lib/python3.6/site-packages/django/db/backends/mysql/base.py",
line 71, in execute
return self.cursor.execute(query, args)
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 250, in execute
self.errorhandler(self, exc, value)
File
"/home/joel/.local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 50, in defaulterrorhandler
raise errorvalue
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 247, in execute
res = self._query(query)
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 412, in _query
rowcount = self._do_query(q)
File "/home/joel/.local/lib/python3.6/site-packages/MySQLdb/cursors.py",
line 375, in _do_query
db.query(q)
File
"/home/joel/.local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 276, in query
_mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1146, "Table
'appointmentsdj.appointments_doctor' doesn't exist")
How can I remove all database data and revert as if to a fresh database.
I have tried a rm -rf myappointments/appointments/migrations/*
On django 2.1, ubuntu
--
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAA%3Diw__Pw9pLMFOPZ7ov8JHWGx5EFNoCJnYF3J0j5iEOXXsHfQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
