django.db.utils.InternalError: (1067, "Invalid default value for 'tag'")

来源:13-3 model_icon, 只读字段,默认排序设置

幕布斯9381828

2017-08-03

python manage.py migrate

Operations to perform:

  Apply all migrations: admin, auth, captcha, contenttypes, courses, operation, organization, sessions, users, xadmin

Running migrations:

  Applying contenttypes.0001_initial... OK

  Applying contenttypes.0002_remove_content_type_name... OK

  Applying auth.0001_initial... OK

  Applying auth.0002_alter_permission_name_max_length... OK

  Applying auth.0003_alter_user_email_max_length... OK

  Applying auth.0004_alter_user_username_opts... OK

  Applying auth.0005_alter_user_last_login_null... OK

  Applying auth.0006_require_contenttypes_0002... OK

  Applying auth.0007_alter_validators_add_error_messages... OK

  Applying auth.0008_alter_user_username_max_length... OK

  Applying users.0001_initial... OK

  Applying admin.0001_initial... OK

  Applying admin.0002_logentry_remove_auto_add... OK

  Applying captcha.0001_initial... OK

  Applying organization.0001_initial... OK

  Applying organization.0002_courseorg_category... OK

  Applying organization.0003_teacher_image... OK

  Applying organization.0004_auto_20170405_1203... OK

  Applying courses.0001_initial... OK

  Applying courses.0002_auto_20170402_1713... OK

  Applying courses.0003_auto_20170404_2243... OK

  Applying courses.0004_auto_20170404_2248... OK

  Applying courses.0005_course_course_org... OK

  Applying courses.0006_course_teacher... OK

  Applying courses.0007_course_is_banner... OK

  Applying courses.0008_bannercourse... OK

  Applying operation.0001_initial... OK

  Applying organization.0005_teacher_age... OK

  Applying organization.0006_remove_courseorg_course_nums... OK

  Applying organization.0007_courseorg_tag...Traceback (most recent call last):

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/mysql/base.py", line 110, in execute

    return self.cursor.execute(query, args)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 166, in execute

    result = self._query(query)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 322, in _query

    conn.query(q)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 852, in query

    self._affected_rows = self._read_query_result(unbuffered=unbuffered)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1053, in _read_query_result

    result.read()

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1336, in read

    first_packet = self.connection._read_packet()

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1010, in _read_packet

    packet.check_error()

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 393, in check_error

    err.raise_mysql_exception(self._data)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception

    raise errorclass(errno, errval)

pymysql.err.InternalError: (1067, "Invalid default value for 'tag'")


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


Traceback (most recent call last):

  File "manage.py", line 22, in <module>

    execute_from_command_line(sys.argv)

  File "/usr/local/lib/python3.5/dist-packages/django/core/management/__init__.py", line 367, in execute_from_command_line

    utility.execute()

  File "/usr/local/lib/python3.5/dist-packages/django/core/management/__init__.py", line 359, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "/usr/local/lib/python3.5/dist-packages/django/core/management/base.py", line 294, in run_from_argv

    self.execute(*args, **cmd_options)

  File "/usr/local/lib/python3.5/dist-packages/django/core/management/base.py", line 345, in execute

    output = self.handle(*args, **options)

  File "/usr/local/lib/python3.5/dist-packages/django/core/management/commands/migrate.py", line 204, in handle

    fake_initial=fake_initial,

  File "/usr/local/lib/python3.5/dist-packages/django/db/migrations/executor.py", line 115, in migrate

    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)

  File "/usr/local/lib/python3.5/dist-packages/django/db/migrations/executor.py", line 145, in _migrate_all_forwards

    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)

  File "/usr/local/lib/python3.5/dist-packages/django/db/migrations/executor.py", line 244, in apply_migration

    state = migration.apply(state, schema_editor)

  File "/usr/local/lib/python3.5/dist-packages/django/db/migrations/migration.py", line 129, in apply

    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)

  File "/usr/local/lib/python3.5/dist-packages/django/db/migrations/operations/fields.py", line 84, in database_forwards

    field,

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/mysql/schema.py", line 43, in add_field

    super(DatabaseSchemaEditor, self).add_field(model, field)

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/base/schema.py", line 409, in add_field

    self.execute(sql, params)

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/base/schema.py", line 112, in execute

    cursor.execute(sql, params)

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/local/lib/python3.5/dist-packages/django/db/utils.py", line 94, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/usr/local/lib/python3.5/dist-packages/django/utils/six.py", line 685, in reraise

    raise value.with_traceback(tb)

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/local/lib/python3.5/dist-packages/django/db/backends/mysql/base.py", line 110, in execute

    return self.cursor.execute(query, args)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 166, in execute

    result = self._query(query)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 322, in _query

    conn.query(q)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 852, in query

    self._affected_rows = self._read_query_result(unbuffered=unbuffered)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1053, in _read_query_result

    result.read()

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1336, in read

    first_packet = self.connection._read_packet()

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1010, in _read_packet

    packet.check_error()

  File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 393, in check_error

    err.raise_mysql_exception(self._data)

  File "/usr/local/lib/python3.5/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception

    raise errorclass(errno, errval)

django.db.utils.InternalError: (1067, "Invalid default value for 'tag'")


写回答

1回答

bobby

2017-08-04

tag这个字段的default值应该和申明的类型冲突了, 你检查一下你的model

0
0

Python3.6+django+xadmin,打造在线教育平台

【毕设】Python 2.7到3.6 完美适配,Django升级2.0

3677 学习 · 4039 问题

查看课程