解决Django创建admin用户时1406错误
admin
2023-07-19 10:42:30
0
manage.py@MxOnline > createsuperuser
"D:\Program Files (x86)\JetBrains\PyCharm 5.0.3\bin\runnerw.exe" C:\Users\Administrator\Envs\mxonline\Scripts\python.exe "D:\Program Files (x86)\JetBrains\PyCharm 5.0.3\helpers\pycharm\django_manage.py" createsuperuser "D:/Python27/Pycharm Project/MxOnline"
Username:  kernel
Email address:  1@1.com
Warning: Password input may be echoed.
Password:  admin123456
Warning: Password input may be echoed.
Password (again):  admin123456
Traceback (most recent call last):
  File "D:\Program Files (x86)\JetBrains\PyCharm 5.0.3\helpers\pycharm\django_manage.py", line 41, in 
    run_module(manage_file, None, '__main__', True)
  File "d:\python27\Lib\runpy.py", line 176, in run_module
    fname, loader, pkg_name)
  File "d:\python27\Lib\runpy.py", line 82, in _run_module_code
    mod_name, mod_fname, mod_loader, pkg_name)
  File "d:\python27\Lib\runpy.py", line 72, in _run_code
    exec code in run_globals
  File "D:\Python27\Pycharm Project\MxOnline\manage.py", line 10, in 
    execute_from_command_line(sys.argv)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\core\management\__init__.py", line 350, in execute_from_command_line
    utility.execute()
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\core\management\__init__.py", line 342, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\core\management\base.py", line 348, in run_from_argv
    self.execute(*args, **cmd_options)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\contrib\auth\management\commands\createsuperuser.py", line 52, in execute
    return super(Command, self).execute(*args, **options)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\core\management\base.py", line 399, in execute
    output = self.handle(*args, **options)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\contrib\auth\management\commands\createsuperuser.py", line 173, in handle
    self.UserModel._default_manager.db_manager(database).create_superuser(**user_data)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\contrib\auth\models.py", line 165, in create_superuser
    return self._create_user(username, email, password, **extra_fields)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\contrib\auth\models.py", line 148, in _create_user
    user.save(using=self._db)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\contrib\auth\base_user.py", line 74, in save
    super(AbstractBaseUser, self).save(*args, **kwargs)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\models\base.py", line 700, in save
    force_update=force_update, update_fields=update_fields)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\models\base.py", line 728, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\models\base.py", line 812, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\models\base.py", line 851, in _do_insert
    using=using, raw=raw)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\models\manager.py", line 122, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\models\query.py", line 1039, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\models\sql\compiler.py", line 1064, in execute_sql
    cursor.execute(sql, params)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\backends\utils.py", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\backends\utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\utils.py", line 95, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\backends\utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\django\db\backends\mysql\base.py", line 112, in execute
    return self.cursor.execute(query, args)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\MySQLdb\cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "C:\Users\Administrator\Envs\mxonline\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
django.db.utils.DataError: (1406, "Data too long for column 'gender' at row 1")

这里提示gender长度太长
双击shift,输入错误中提示的那个字段
解决Django创建admin用户时1406错误
发现最大长度时5,但是默认值有6个字符,所以我们将其设为7个字符
解决Django创建admin用户时1406错误
然后重新makemigrations,migrate,createsuper,最后成功了

相关内容

热门资讯

“披露版”美伊备忘录哪些内容值... 新华社开罗/北京6月17日电(记者吴宝澍 孙一)北京时间17日,美国彭博社和沙特阿拉伯阿拉比亚电视台...
发动机停车还是飞控故障?美媒推... 【文/观察者网 山猫】当地时间6月15日上午,美国空军一架B-52轰炸机在加州南部莫哈韦沙漠中坠毁,...
“恋童团伙渗透英国149地”,... 【文/观察者网 柳白】英国过往多地儿童性剥削丑闻,常被归为局部治理事故。但最新线索表明,此类恶性犯罪...
机器人跳舞突然断电 嘎巴一声就... 快科技6月17日消息,近日一则机器人舞台表演的视频在网络走红,有趣的突发状况引起网友热议。 视频里,...
推荐系统走向新范式 快手技术沙... 近日,快手技术沙龙第四期在北京举办,本期沙龙以“快手生成式推荐技术的体系化演进——统一基座、池化预估...
2026安全生产月|中国电信构... (记者 张苏慧)据中新网报道,今年6月是第25个全国“安全生产月”。如今,云网基础设施已成为各行各业...
美媒:美伊谅解备忘录或提前至最... 美媒Axios报道,据其中一调解国的外交官和另一位熟悉讨论情况的消息人士透露,美国、伊朗和调解方正在...
美伊将在卡塔尔召开预备会议,双... 有关美伊在多哈的预备会议,目前有什么新消息?双方团队的讨论重点都有哪些?凤凰卫视特派记者曹劼从多哈发...
刚宣布“免费开放”,特朗普又要... 【文/观察者网 柳白】美国总统特朗普一边宣布霍尔木兹海峡“完全开放”,且无需缴纳通行费,而另一边大量...
专家:“美国治下的和平”已经结... 据凤凰卫视报道,美国尚未完全摆脱战争泥潭,但特朗普政府的战略重心转移已对其全球领导力产生深远影响。清...