RError.com

RError.com Logo RError.com Logo

RError.com Navigation

  • 主页

Mobile menu

Close
  • 主页
  • 系统&网络
    • 热门问题
    • 最新问题
    • 标签
  • Ubuntu
    • 热门问题
    • 最新问题
    • 标签
  • 帮助
主页 / 问题 / 951785
Accepted
JBlack
JBlack
Asked:2020-03-03 20:25:51 +0000 UTC2020-03-03 20:25:51 +0000 UTC 2020-03-03 20:25:51 +0000 UTC

makemigrations 未运行且未在 Django DB 中创建表

  • 772

在 Visual Studio 2017 中进行开发。在执行“makemigrations”以及检查“manage.py check”时,我有相同的系统响应:


运行:manage.py makemigrations

Traceback (most recent call last):
File "...\DjangoWeb\env\lib\site-packages\django\db\backends\utils.py", line 64, in execute
    return self.cursor.execute(sql, params)

File "...\DjangoWeb\env\lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute

return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: no such table: app_entry

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

Traceback (most recent call last):
File "...\DjangoWeb\manage.py", line 17, in <module>

execute_from_command_line(sys.argv)

File "...\DjangoWeb\env\lib\site-packages\django\core\management\__init__.py", line 364, in execute_from_command_line
    utility.execute()

File "...\DjangoWeb\env\lib\site-packages\django\core\management\__init__.py", line 356, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)

File "...\DjangoWeb\env\lib\site-packages\django\core\management\base.py", line 283, in run_from_argv
    self.execute(*args, **cmd_options)

File "...\DjangoWeb\env\lib\site-packages\django\core\management\base.py", line 327, in execute
    self.check()

File "...\DjangoWeb\env\lib\site-packages\django\core\management\base.py", line 359, in check
    include_deployment_checks=include_deployment_checks,

File "...\DjangoWeb\env\lib\site-packages\django\core\management\base.py", line 346, in _run_checks
    return checks.run_checks(**kwargs)

File "...\DjangoWeb\env\lib\site-packages\django\core\checks\registry.py", line 81, in run_checks
    new_errors = check(app_configs=app_configs)

File "...\DjangoWeb\env\lib\site-packages\django\core\checks\urls.py", line 16, in check_url_config
    return check_resolver(resolver)

File "...\DjangoWeb\env\lib\site-packages\django\core\checks\urls.py", line 26, in check_resolver
    return check_method()

File "...\DjangoWeb\env\lib\site-packages\django\urls\resolvers.py", line 256, in check
    for pattern in self.url_patterns:

File "...\DjangoWeb\env\lib\site-packages\django\utils\functional.py", line 35, in __get__
    res = instance.__dict__[self.name] = self.func(instance)

File "...\DjangoWeb\env\lib\site-packages\django\urls\resolvers.py", line 407, in url_patterns
    patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)

File "...\DjangoWeb\env\lib\site-packages\django\utils\functional.py", line 35, in __get__
    res = instance.__dict__[self.name] = self.func(instance)

File "...\DjangoWeb\env\lib\site-packages\django\urls\resolvers.py", line 400, in urlconf_module
    return import_module(self.urlconf_name)

File "...\Microsoft Visual Studio\Shared\Python36_64\lib\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 ".\DjangoWeb\urls.py", line 8, in <module>
    import app.views

File ".\app\views.py", line 68, in <module>
    ENTRY_COUNT = Entry.objects.count() # кол-во зявок в БД

File "...\DjangoWeb\env\lib\site-packages\django\db\models\manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)

File "...\DjangoWeb\env\lib\site-packages\django\db\models\query.py", line 364, in count
    return self.query.get_count(using=self.db)

File "...\DjangoWeb\env\lib\site-packages\django\db\models\sql\query.py", line 499, in get_count
    number = obj.get_aggregation(using, ['__count'])['__count']

File "...\DjangoWeb\env\lib\site-packages\django\db\models\sql\query.py", line 480, in get_aggregation
    result = compiler.execute_sql(SINGLE)

File "...\DjangoWeb\env\lib\site-packages\django\db\models\sql\compiler.py", line 899, in execute_sql
    raise original_exception

File "...\DjangoWeb\env\lib\site-packages\django\db\models\sql\compiler.py", line 889, in execute_sql
    cursor.execute(sql, params)

File "...\DjangoWeb\env\lib\site-packages\django\db\backends\utils.py", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)

File "...\DjangoWeb\env\lib\site-packages\django\db\backends\utils.py", line 64, in execute
    return self.cursor.execute(sql, params)

File "...\DjangoWeb\env\lib\site-packages\django\db\utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)

File ...\DjangoWeb\env\lib\site-packages\django\utils\six.py", line 685, in reraise
    raise value.with_traceback(tb)

File "...\DjangoWeb\env\lib\site-packages\django\db\backends\utils.py", line 64, in execute
    return self.cursor.execute(sql, params)

File "...\DjangoWeb\env\lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute
    return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: no such table: app_entry

同时,“migration”项目文件夹中的所有migration文件都被删除,除了“--init--.py”文件,数据库文件本身被系统删除并重新创建,但不断给出上述错误..

这里可能有什么问题以及如何解决?

база-данных
  • 1 1 个回答
  • 10 Views

1 个回答

  • Voted
  1. Best Answer
    Block2busted
    2020-04-08T21:25:07Z2020-04-08T21:25:07Z

    要将必要的表添加到您现有的数据库(我有 account_profile),您必须首先下载“DB Browser for SQLite”并执行以下操作:

    1. 将现有的“db.sqlite3”复制到某个文件夹。
    2. 从项目文件夹中删除它。
    3. 运行“python3 manage.py make migrations”,然后运行“python3 manage.py migrate”。
    4. 在“DB Browser for SQLite”中打开您的新数据库。
    5. 然后,您需要将“account_profile”表导出为 CSV 文件。如图 1 所示(评论底部)
    6. 然后删除您的新数据库并放回旧数据库
    7. 现在在“DB Browser for SQLite”中打开您的旧数据库,单击“文件”->“导入”->“表为 CSV 文件”并选择您的 CSV 文件(它包含所需的表)
    8. 然后你会看到表格中的列被命名为'field1'和'field2',相应地将它们更改为'id''user_id'。如图 2 和 3 所示
    9. 然后你可以要么删除数据库中的admin,要么查看他的id是什么然后输入(比如admin有id-5,在'id'列写-'1',在'user_id'列-' 5')

    有问题可以写,我很乐意回答)

    图像1

    图2

    图3

    结果)

    • 2

相关问题

Sidebar

Stats

  • 问题 10021
  • Answers 30001
  • 最佳答案 8000
  • 用户 6900
  • 常问
  • 回答
  • Marko Smith

    根据浏览器窗口的大小调整背景图案的大小

    • 2 个回答
  • Marko Smith

    理解for循环的执行逻辑

    • 1 个回答
  • Marko Smith

    复制动态数组时出错(C++)

    • 1 个回答
  • Marko Smith

    Or and If,elif,else 构造[重复]

    • 1 个回答
  • Marko Smith

    如何构建支持 x64 的 APK

    • 1 个回答
  • Marko Smith

    如何使按钮的输入宽度?

    • 2 个回答
  • Marko Smith

    如何显示对象变量的名称?

    • 3 个回答
  • Marko Smith

    如何循环一个函数?

    • 1 个回答
  • Marko Smith

    LOWORD 宏有什么作用?

    • 2 个回答
  • Marko Smith

    从字符串的开头删除直到并包括一个字符

    • 2 个回答
  • Martin Hope
    Alexandr_TT 2020年新年大赛! 2020-12-20 18:20:21 +0000 UTC
  • Martin Hope
    Alexandr_TT 圣诞树动画 2020-12-23 00:38:08 +0000 UTC
  • Martin Hope
    Air 究竟是什么标识了网站访问者? 2020-11-03 15:49:20 +0000 UTC
  • Martin Hope
    Qwertiy 号码显示 9223372036854775807 2020-07-11 18:16:49 +0000 UTC
  • Martin Hope
    user216109 如何为黑客设下陷阱,或充分击退攻击? 2020-05-10 02:22:52 +0000 UTC
  • Martin Hope
    Qwertiy 并变成3个无穷大 2020-11-06 07:15:57 +0000 UTC
  • Martin Hope
    koks_rs 什么是样板代码? 2020-10-27 15:43:19 +0000 UTC
  • Martin Hope
    Sirop4ik 向 git 提交发布的正确方法是什么? 2020-10-05 00:02:00 +0000 UTC
  • Martin Hope
    faoxis 为什么在这么多示例中函数都称为 foo? 2020-08-15 04:42:49 +0000 UTC
  • Martin Hope
    Pavel Mayorov 如何从事件或回调函数中返回值?或者至少等他们完成。 2020-08-11 16:49:28 +0000 UTC

热门标签

javascript python java php c# c++ html android jquery mysql

Explore

  • 主页
  • 问题
    • 热门问题
    • 最新问题
  • 标签
  • 帮助

Footer

RError.com

关于我们

  • 关于我们
  • 联系我们

Legal Stuff

  • Privacy Policy

帮助

© 2023 RError.com All Rights Reserve   沪ICP备12040472号-5