安装1.11.1初始化库环节报错

[sscash]

重现步骤

1、使用docker-compose 运行，未修改 配置保持默认启动。 2、引用https://archerydms.com/installation/docker/描述。进入容器初始化 3、执行python3 manage.py migrate 报错。

预期外的结果

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 auth.0009_alter_user_last_name_max_length... OK Applying auth.0010_alter_group_name_max_length... OK Applying auth.0011_update_proxy_permissions... OK Applying auth.0012_alter_user_first_name_max_length... OK Applying sql.0001_initial... OK Applying admin.0001_initial... OK Applying admin.0002_logentry_remove_auto_add... OK Applying admin.0003_logentry_add_action_flag_choices... OK Applying django_q.0001_initial... OK Applying django_q.0002_auto_20150630_1624... OK Applying django_q.0003_auto_20150708_1326... OK Applying django_q.0004_auto_20150710_1043... OK Applying django_q.0005_auto_20150718_1506... OK Applying django_q.0006_auto_20150805_1817... OK Applying django_q.0007_ormq... OK Applying django_q.0008_auto_20160224_1026... OK Applying django_q.0009_auto_20171009_0915... OK Applying django_q.0010_auto_20200610_0856... OK Applying django_q.0011_auto_20200628_1055... OK Applying django_q.0012_auto_20200702_1608... OK Applying django_q.0013_task_attempt_count... OK Applying django_q.0014_schedule_cluster... OK Applying sessions.0001_initial... OK Traceback (most recent call last): File "/opt/venv4archery/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/opt/venv4archery/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 75, in execute return self.cursor.execute(query, args) File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 179, in execute res = self._query(mogrified_query) File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 330, in _query db.query(q) File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/connections.py", line 255, in query _mysql.connection.query(self, query) MySQLdb.OperationalError: (1366, "Incorrect string value: '\xE6\x85\xA2\xE6\x97\xA5...' for column 'name' at row 1")

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

Traceback (most recent call last): File "/opt/archery/manage.py", line 10, in execute_from_command_line(sys.argv) File "/opt/venv4archery/lib/python3.9/site-packages/django/core/management/init.py", line 446, in execute_from_command_line utility.execute() File "/opt/venv4archery/lib/python3.9/site-packages/django/core/management/init.py", line 440, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/opt/venv4archery/lib/python3.9/site-packages/django/core/management/base.py", line 402, in run_from_argv self.execute(*args, cmd_options) File "/opt/venv4archery/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute output = self.handle(*args, *options) File "/opt/venv4archery/lib/python3.9/site-packages/django/core/management/base.py", line 96, in wrapped res = handle_func(args, kwargs) File "/opt/venv4archery/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 376, in handle emit_post_migrate_signal( File "/opt/venv4archery/lib/python3.9/site-packages/django/core/management/sql.py", line 52, in emit_post_migrate_signal models.signals.post_migrate.send( File "/opt/venv4archery/lib/python3.9/site-packages/django/dispatch/dispatcher.py", line 176, in send return [ File "/opt/venv4archery/lib/python3.9/site-packages/django/dispatch/dispatcher.py", line 177, in (receiver, receiver(signal=self, sender=sender, **named)) File "/opt/venv4archery/lib/python3.9/site-packages/django/contrib/auth/management/init.py", line 103, in create_permissions Permission.objects.using(using).bulk_create(perms) File "/opt/venv4archery/lib/python3.9/site-packages/django/db/models/query.py", line 816, in bulk_create returned_columns = self._batched_insert( File "/opt/venv4archery/lib/python3.9/site-packages/django/db/models/query.py", line 1825, in _batched_insert self._insert( File "/opt/venv4archery/lib/python3.9/site-packages/django/db/models/query.py", line 1791, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "/opt/venv4archery/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1660, in execute_sql cursor.execute(sql, params) File "/opt/venv4archery/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers( File "/opt/venv4archery/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) File "/opt/venv4archery/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/opt/venv4archery/lib/python3.9/site-packages/django/db/utils.py", line 91, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/opt/venv4archery/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/opt/venv4archery/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 75, in execute return self.cursor.execute(query, args) File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 179, in execute res = self._query(mogrified_query) File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/cursors.py", line 330, in _query db.query(q) File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/connections.py", line 255, in query _mysql.connection.query(self, query) django.db.utils.OperationalError: (1366, "Incorrect string value: '\xE6\x85\xA2\xE6\x97\xA5...' for column 'name' at row 1")

日志文本

No response

版本

1.11.1

部署方式

Docker

是否还有其他可以辅助定位问题的信息？比如数据库版本等

No response

[LeoQuote]

Duplicate of #1710

[sscash]

数据库是utf8mb4

[sscash]

修改默认数据库，切换8.0数据库后正常

[LeoQuote]

如果我们的 docker-compose 用的不是 8.0 , 欢迎 pr 改成 8.0