报错django.db.utils.DataError: (1406, "Data too long for column 'gender' at row 1")的解决办法

最新推荐文章于 2024-06-28 06:36:05 发布

HeatDeath

最新推荐文章于 2024-06-28 06:36:05 发布

阅读量9.2k

点赞数 2

分类专栏： Django 文章标签： django 解决方案

本文为博主原创文章，未经博主允许不得转载。哈哈哈

本文链接：https://blog.csdn.net/heatdeath/article/details/69992310

版权

针对'gender'字段出现的django.db.utils.DataError: (1406, ""Data too long for column 'gender' at row 1"")错误，通过检查并修改字段的最大长度设置成功解决了问题。" 119753309,4844201,Java实现：批量字符串生成高效正则表达式,"['Java开发', '正则表达式', '字符串处理']

摘要由CSDN通过智能技术生成

参考解决方案

这里写图片描述

Traceback (most recent call last):
  File "C:\Users\rHotD\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\backends\utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "C:\Users\rHotD\AppData\Local\Programs\Python\Python35\lib\site-packages\django\db\backends\mysql\base.py", line 110, in execute
    return self.cursor.execute(query, args)
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages\pymysql\cursors.py", line 166, in execute
    result = self._query(query)
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages\pymysql\cursors.py", line 322, in _query
    conn.query(q)
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages\pymysql\connections.py", line 856, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages\pymysql\connections.py", line 1057, in _read_query_result
    result.read()
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages\pymysql\connections.py", line 1340, in read
    first_packet = self.connection._read_packet()
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages\pymysql\connections.py", line 1014, in _read_packet
    packet.check_error()
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages\pymysql\connections.py", line 393, in check_error
    err.raise_mysql_exception(self._data)
  File "C:\Users\rHotD\AppData\Roaming\Python\Python35\site-packages