
python后台创建管理员的时候报错
发布日期:2022-02-23 07:42:40
浏览次数:4
分类:技术文章
本文共 5888 字,大约阅读时间需要 19 分钟。
这里报错的是:
django.db.utils.IntegrityError: (1062, "Duplicate entry '' for key 'mobile'")
翻译过来就是,重复输入了手机号。
Traceback (most recent call last): File "manage.py", line 22, inexecute_from_command_line(sys.argv) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/core/management/__init__.py", line 364, in execute_from_command_line utility.execute() File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/core/management/__init__.py", line 356, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/core/management/base.py", line 283, in run_from_argv self.execute(*args, **cmd_options) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/contrib/auth/management/commands/createsuperuser.py", line 63, in execute return super(Command, self).execute(*args, **options) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/core/management/base.py", line 330, in execute output = self.handle(*args, **options) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/contrib/auth/management/commands/createsuperuser.py", line 183, in handle self.UserModel._default_manager.db_manager(database).create_superuser(**user_data) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/contrib/auth/models.py", line 170, in create_superuser return self._create_user(username, email, password, **extra_fields) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/contrib/auth/models.py", line 153, in _create_user user.save(using=self._db) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/contrib/auth/base_user.py", line 80, in save super(AbstractBaseUser, self).save(*args, **kwargs) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/models/base.py", line 808, in save force_update=force_update, update_fields=update_fields) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/models/base.py", line 838, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/models/base.py", line 924, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/models/base.py", line 963, in _do_insert using=using, raw=raw) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/models/query.py", line 1076, in _insert return query.get_compiler(using=using).execute_sql(return_id) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 1112, in execute_sql cursor.execute(sql, params) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/backends/utils.py", line 79, in execute return super(CursorDebugWrapper, self).execute(sql, params) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/utils.py", line 94, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/utils/six.py", line 685, in reraise raise value.with_traceback(tb) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 101, in execute return self.cursor.execute(query, args) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/cursors.py", line 170, in execute result = self._query(query) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/cursors.py", line 328, in _query conn.query(q) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/connections.py", line 516, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/connections.py", line 727, in _read_query_result result.read() File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/connections.py", line 1066, in read first_packet = self.connection._read_packet() File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/connections.py", line 683, in _read_packet packet.check_error() File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "/home/python/.virtualenvs/django_py3_1.11/lib/python3.5/site-packages/pymysql/err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval)pymysql.err.IntegrityError: (1062, "Duplicate entry '' for key 'mobile'")
分析原因:
因为我们第一次创建管理员的时候,默认不设置手机号,但是我们创建模型类的时候加入了mobile这个字段,所以,当你第二次创建管理员的时候,两个空值的手机冲突了,因为你代码设置了一个手机号只能绑定一个账号,所以,在这里就报错了!
解决办法:
1:删除第一个管理员(不建议,有时候不切实际)
2:给第一个管理员账号加入手机号码
update tb_users set mobile = 'xxxxxxxxxxxx' where id = 1;
总结:就一小问题,稳住
转载地址:https://blog.csdn.net/weixin_42781180/article/details/82391140 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!
发表评论
最新留言
哈哈,博客排版真的漂亮呢~
[***.90.31.176]2023年06月10日 23时16分45秒
关于作者

喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
最新文章
mac下安装airtest
2019-04-20 19:02:46
小米手机无法打包的解决方案
2019-04-20 19:02:46
Android分渠道多应用名打包方案
2019-04-20 19:02:45
友盟分享本地图片到微信无法调起微信解决方案
2019-04-20 19:02:45
Android WebView Video完全详解(第二篇)-H5前端开发人员
2019-04-20 19:02:44
Android WebView Video完全详解(第一篇)-Android开发人员
2019-04-20 19:02:44
Android 键盘弹起和回落事件监听(二)之移动布局
2019-04-20 19:02:44
Android 键盘弹起和回落事件监听
2019-04-20 19:02:43
YAML 语法规范、Spring Boot 自动配置原理、多环境配置 Profiles
2019-04-20 19:02:43
微信小程序-上海站
2019-04-20 19:02:43
Spring Boot 配置文件加载位置与顺序、外部配置文件加载顺序
2019-04-20 19:02:43
微信小程序
2019-04-20 19:02:42
日志框架简述、slf4j 日志框架概述,slf4j + log4j 1.X 日志组合
2019-04-20 19:02:42
微信小程序
2019-04-20 19:02:42
Spring Boot 2.x 日志配置 与 指定 Logback 日志配置文件.
2019-04-20 19:02:42
微信小程序
2019-04-20 19:02:41
Spring Boot 2.x 集成 Thymeleaf 快速入门、静态资源映射规则
2019-04-20 19:02:41
Android 高逼格截取字符串
2019-04-20 19:02:41
Thymeleaf 模板引擎简介 与 Spring Boot 整合入门
2019-04-20 19:02:41
Android 跑马灯 文字滚动
2019-04-20 19:02:41