删除订单时没有这样的表：main.customer\u communicationeventtype

Question

我有一个Django Oscar电子商务应用程序，是我从沙箱中构建的。我没有真正改变代码中的任何内容，只是添加了一些产品和东西

我试图添加一个演示订单，但由于某种原因失败了，但是创建了订单对象。当我试图从django管理页面中删除该对象时，出现以下错误：

django.db.utils.OperationalError: no such table: main.customer_communicationeventtype

Django v3.0.9
Basic SQLite3 DB

完全回溯：

Internal Server Error: /admin/order/order/
Traceback (most recent call last):
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py", line 396, in execute
    return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: no such table: main.customer_communicationeventtype

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/core/handlers/exception.py", line 34, in inner
    response = get_response(request)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/core/handlers/base.py", line 115, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/core/handlers/base.py", line 113, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/lib/python3.7/contextlib.py", line 74, in inner
    return func(*args, **kwds)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/contrib/admin/options.py", line 607, in wrapper
    return self.admin_site.admin_view(view)(*args, **kwargs)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/utils/decorators.py", line 130, in _wrapped_view
    response = view_func(request, *args, **kwargs)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func
    response = view_func(request, *args, **kwargs)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/contrib/admin/sites.py", line 231, in inner
    return view(request, *args, **kwargs)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/utils/decorators.py", line 43, in _wrapper
    return bound_method(*args, **kwargs)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/utils/decorators.py", line 130, in _wrapped_view
    response = view_func(request, *args, **kwargs)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/contrib/admin/options.py", line 1720, in changelist_view
    response = self.response_action(request, queryset=cl.get_queryset(request))
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/contrib/admin/options.py", line 1390, in response_action
    response = func(self, request, queryset)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/contrib/admin/actions.py", line 40, in delete_selected
    modeladmin.delete_queryset(request, queryset)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/contrib/admin/options.py", line 1091, in delete_queryset
    queryset.delete()
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/models/query.py", line 722, in delete
    deleted, _rows_count = collector.delete()
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/models/deletion.py", line 314, in delete
    count = qs._raw_delete(using=self.using)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/models/query.py", line 736, in _raw_delete
    return sql.DeleteQuery(self.model).delete_qs(self, using)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/models/sql/subqueries.py", line 75, in delete_qs
    cursor = self.get_compiler(using).execute_sql(CURSOR)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1152, in execute_sql
    cursor.execute(sql, params)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/utils.py", line 100, in execute
    return super().execute(sql, params)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/utils.py", line 68, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/utils.py", line 86, in _execute
    return self.cursor.execute(sql, params)
  File "/Users/siddheshpisal/.pyenv/versions/3.7.1/envs/oscar/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py", line 396, in execute
    return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: no such table: main.customer_communicationeventtype

Answer 1

您使用的是沙盒代码和Oscar的不兼容版本

在最新版本的Oscar（2.1）中，通信模型被移动到一个新的应用程序（communication）。您似乎正在使用奥斯卡2.1版和2.1之前版本的沙盒副本

项目更新所需的步骤记录在Oscar 2.1release notes中