关于Django报错 raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc

最新推荐文章于 2022-02-21 11:14:58 发布
最新推荐文章于 2022-02-21 11:14:58 发布
阅读量646 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： 后端 python小知识 文章标签： Django python MySQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_16687863/article/details/99599737
本文解决了一个在使用Django2.1进行数据库迁移时遇到的问题，原因是MySQL版本为5.5，不被支持。提供了两种解决方案：降级Django版本至2.0或升级MySQL至5.6及以上版本。

代码什么的都没有错误，但是在执行迁移命令的时候报错：

python manage.py makemigrations
python manage.py migrate

报错:

raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc

原因：

django2.1不在支持MySQL5.5 ,必须是5.6以上（我的django是2.1的，MySQL是5.1或5.5）

解决办法：

  1. 使用低版本的django，降到django2.0 
    pip install Django==2.0.0 -i https://pypi.douban.com/simple
  2. 升级MySQL到5.6版本级以上，我直接吧原来的卸载了并清除干净，安装了5.7版本的（可以使用不卸载的方式升级，这里我没试过，不做说明）
django在migrate时报错ORA-02000: missing ALWAYS keyword
观想的专栏
08-17 5327
错误信息 PS D:\parttime\python\django\guanxiangzhiji> python manage.py migrate Operations to perform: Apply all migrations: admin, auth, contenttypes, sessions Running migrations: Traceback (most re...
【Django】报错：File “manage.py“, line 17 ) from exc ^ SyntaxError: invalid syntax
milkign的博客
03-24 1513
问题描述 Django 3.1.4使用mysql数据库，进行数据迁移时，报错： (venv) xxx@xxx-MacBook-Pro django3 % python manage.py makemigrations user File "manage.py", line 17 ) from exc ^ SyntaxError: invalid syntax 解决办法 使用python3 进行迁移 python3 manage.py makemigrations app名称
raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)“ % exc)
weixin_44887276的博客
02-24 721
Diango 3.1.7 python 3.9.2 编辑器 idea 2019.1.1 mysqlclient 2.0.3 PyMySQL 1.0.2 点击 打开面板输入migrate Django：报错 raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)” % exc) 原因： Django2.1不再支持MySQL5.5，必须5.6版本以上 解决办法： 二选一 （1）Django降级到
报错 raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc)
weixin_30600503的博客
02-13 560
django执行迁移生成表 python manage.py migrate 报错 raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) 原因：Django2.1不再支持MySQL5.5，必须5.6版本以上 解决方法： 1.对django降级 2.对mysql升级 mysql升...
raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)“ % exc)django.d.....
weixin_47486326的博客
02-21 800
在使用Django迁移数据时出现报错： raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, "You have an error in your SQL syntax;
Django raise MigrationSchemaMissing(Unable to create the django_migrations table (%s) % exc)(亲测)
gb4215287的博客
06-01 825
raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, "You have an error in your SQL syntax; check the manual tha
MigrationSchemaMissing: Unableto createthe django_migrations
软件工程小施同学 的专栏
05-31 612
py django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, "You have an error in your SQL syntax; check the manual that correspon ds to your MySQL server version for the right syntax to use near '(6).
File "A:\miniconda3\envs\dimension\lib\site-packages\django\db\migrations\recorder.py", line 70, in ensure_schema raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1813, "Tablespace '`qa_pfmea_2022`.`django_migrations`' exists."))
06-05
这个错误是由于 Django 迁移记录表 django_migrations 所在的 tablespace 已经存在，导致无法创建该表。解决该问题的方法是手动删除该 tablespace 或者将该表创建到其他 tablespace 中。您可以在数据库中执行以下 ...
Operations to perform: Apply all migrations: admin, auth, contenttypes, sessions Running migrations: Traceback (most recent call last): File "D:\Python37\lib\site-packages\django\db\backends\utils.py", line 82, in _execute return self.cursor.execute(sql) File "D:\Python37\lib\site-packages\django\db\backends\oracle\base.py", line 523, in execute return self.cursor.execute(query, self._param_generator(params)) cx_Oracle.DatabaseError: ORA-02000: missing ALWAYS keyword The above exception was the direct cause of the following exception: Traceback (most recent call last): File "D:\Python37\lib\site-packages\django\db\migrations\recorder.py", line 68, in ensure_schema editor.create_model(self.Migration) File "D:\Python37\lib\site-packages\django\db\backends\base\schema.py", line 345, in create_model self.execute(sql, params or None) File "D:\Python37\lib\site-packages\django\db\backends\base\schema.py", line 145, in execute cursor.execute(sql, params) File "D:\Python37\lib\site-packages\django\db\backends\utils.py", line 98, in execute return super().execute(sql, params) File "D:\Python37\lib\site-packages\django\db\backends\utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "D:\Python37\lib\site-packages\django\db\backends\utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "D:\Python37\lib\site-packages\django\db\backends\utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "D:\Python37\lib\site-packages\django\db\utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "D:\Python37\lib\site-packages\django\db\backends\utils.py", line 82, in _execute return self.cursor.execute(sql) File "D:\Python37\lib\site-packages\django\db\backends\oracle\base.py", line 523, in execute return self.cursor.execute(query, self._param_generator(params)) django.db.utils.DatabaseError: ORA-02000: missing ALWAYS keyword During handling of the above exception, another exception occurred: Traceback (most recent call last): File "manage.py", line 22, in <module> main() File "manage.py", line 18, in main execute_from_command_line(sys.argv) File "D:\Python37\lib\site-packages\django\core\management\__init__.py", line 419, in execute_from_command_line utility.execute() File "D:\Python37\lib\site-packages\django\core\management\__init__.py", line 413, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "D:\Python37\lib\site-packages\django\core\management\base.py", line 354, in run_from_argv self.execute(*args, **cmd_options) File "D:\Python37\lib\site-packages\django\core\management\base.py", line 398, in execute output = self.handle(*args, **options) File "D:\Python37\lib\site-packages\django\core\management\base.py", line 89, in wrapped res = handle_func(*args, **kwargs) File "D:\Python37\lib\site-packages\django\core\management\commands\migrate.py", line 246, in handle fake_initial=fake_initial, File "D:\Python37\lib\site-packages\django\db\migrations\executor.py", line 91, in migrate self.recorder.ensure_schema() File "D:\Python37\lib\site-packages\django\db\migrations\recorder.py", line 70, in ensure_schema raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table (ORA-02000: missing ALWAYS keyword) 什么问题
最新发布
08-22
- 在运行`migrate`命令时，Django会创建`django_migrations`表来记录迁移历史，同时也会为每个模型创建相应的表。 - 当创建表时，如果模型包含自增主键（通常是`AutoField`），Django会尝试使用Oracle 12c的新特性...
Django在同步数据库时发生的错误raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" %
weixin_44675377的博客
08-08 512
错误描述： 这是在执行同步数据库时发生的错误： 原因描述： Django2.1不再支持MySQL5.5，必须5.6版本以上 解决方法： 1.把Django降到2.0.0 pip uninstall Django #卸载当前版本 pip install Django==2.0.0 #下载Django2.0.0版本 2.将MYSQL升级 结果： ...
django migrate 报错：Unable to create the django_migrations table (%s)" % exc
SunChao3555的博客
10-24 1583
django pyhon manage.py migrate报的错误如下：Unable to create the django_migrations table (%s)" % exc # 对新建models的class类进行migrate时报错：xxtable already exist --可尝试此方法---python manage.py migrate myApp --fake f...
"Unable to create the django_migrations table (%s)"
m0_37584649的博客
08-09 5755
环境：python3 + django2.1 +pycharm +mysql 执行python manage.py migrate时报错如下 “Unable to create the django_migrations table (%s)” % exc django.db.migrations.exceptions.MigrationSchemaMissing: Unable to cr...
raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)“ % exc) django.db.mi
m0_55837832的博客
07-14 386
raise MigrationSchemaMissing(“Unable to create the django_migrations table (%s)” % exc) django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, “You h ave an error in your SQL syntax; che
django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table
qq_18246731的博客
07-29 2655
执行 python manage.py migrate报如下错，因为django2.2和mysql5.5数据库不兼容，我更换mysql5.7问题解决 raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) django.db.migrations.exceptions.M...
Unable to create the django_migrations table ((1064, “You have an error in your SQL syntax； check th
weixin_43537977的博客
12-24 1312
在django连接数据库，执行数据库迁移时候报错django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, “You have an error in your SQL syntax; check the m anual that corresponds to your MySQL server version for the right syntax
Unable to create the django_migrations table ((1064, "You have an error in your SQL syntax; check th
weixin_42260750的博客
04-01 2374
Django执行迁移时候报错 raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations ta...
Unable to create the django_migrations table ((1064, “You have an error in your SQL syntax； check
weixin_44689247的博客
06-03 397
在使用Django进行项目构建时，执行迁移过程中报错 原因 Django2.1不再支持MySQL5.5，必须5.6版本以上 解决方式 Django降级 pip install Django==2.0.0 -i https://pypi.douban.com/simple mysql升级
Unable to create the django_migrations table (%s)" % exc
顽石⚡
08-03 2493
弄了半天，django2.1 不支持mysql5.5了  晕死 https://www.kawabangga.com/posts/3013
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值