【未解决】SAE,本地，mysql，date类型，报错

来源：互联网发布：怎么修改淘宝店铺网址编辑：程序博客网时间：2024/05/18 00:42

这是model，在bday处报错，不管有没有default都报错。只是本地报错，sae上正常运行。

可能与MYSQL配置有关。

class User(db.Model):    id = db.Column(db.Integer, primary_key=True)    email = db.Column(db.String(64), unique=True)    # 是不是应该加密下，不能明文存储？应该设置多长的空间？ 14.7.18 4：22 by lee    password = db.Column(db.String(100))    nickname = db.Column(db.String(64))    school = db.Column(db.String(20))    sex = db.Column(db.String(5))    status = db.Column(db.String(10))    grade = db.Column(db.String(18))    bday = db.Column(db.Date, default='1900-10-10')   # 有没有db.Date呀    pubinfo = db.Column(db.String(300))    # 私密信息    contact = db.Column(db.String(50))    prinfo = db.Column(db.String(140))

sqlalchemy.exc.OperationalError

啊

OperationalError: (OperationalError) (1292, "Incorrect date value: '' for column 'bday' at row 1") 'INSERT INTO user (email, password, nickname, school, sex, status, grade, bday, pubinfo, contact, prinfo, role, avatar_path, last_seen, regtime) VALUES (%s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' ('12@1.com', '123', 'ehugleecoo', '\xe5\x8d\x8e\xe4\xb8\xad\xe7\xa7\x91\xe6\x8a\x80\xe5\xa4\xa7\xe5\xad\xa6', '\xe7\x94\xb7', '\xe7\xa0\x94\xe7\xa9\xb6\xe7\x94\x9f', 'qwewq', u'', '', '', '', 0, 'http://www.gravatar.com/avatar/91a36e92bffbfcfd16f3eff76b56a651?d=mm&s=50', datetime.datetime(2014, 7, 22, 9, 57, 10, 31000), datetime.datetime(2014, 7, 22, 9, 57, 10, 31000))

0 0