注册写入数据库失败
来源:9-9 ORM的方式保存模型
zmm064
2018-07-17
sqlalchemy.exc.InternalError
sqlalchemy.exc.InternalError: (cymysql.err.InternalError) (1054, "Unknown column 'status' in 'field list'") [SQL: 'INSERT INTO user (status, nickname, password, phone_number, email, confirmed, beans, send_counter, receive_counter, wx_open_id, wx_name) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: (1, 'zmm065', 'pbkdf2:sha256:50000$B56bTJdv$1cef56e9997e991fc44337d2084800169ca9a323b0dc7f51260219a1b0f806f6', None, 'zmm064@foxmail.com', 0, 0, 0, 0, None, None)] (Background on this error at: http://sqlalche.me/e/2j85)
Traceback (most recent call last):
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 2309, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 2295, in wsgi_app
response = self.handle_exception(e)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 1741, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\_compat.py", line 35, in reraise
raise value
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 2292, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 1815, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 1718, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\_compat.py", line 35, in reraise
raise value
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 1813, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\flask\app.py", line 1799, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Users\dell\Source\Repos\FlaskWebProject_fisher\app\web\auth.py", line 16, in register
db.session.add(user);db.session.commit()
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\scoping.py", line 153, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\session.py", line 943, in commit
self.transaction.commit()
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\session.py", line 467, in commit
self._prepare_impl()
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\session.py", line 447, in _prepare_impl
self.session.flush()
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\session.py", line 2254, in flush
self._flush(objects)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\session.py", line 2380, in _flush
transaction.rollback(_capture_exception=True)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\util\langhelpers.py", line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\util\compat.py", line 249, in reraise
raise value
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\session.py", line 2344, in _flush
flush_context.execute()
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 391, in execute
rec.execute(self)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 556, in execute
uow
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\persistence.py", line 181, in save_obj
mapper, table, insert)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\orm\persistence.py", line 866, in _emit_insert_statements
execute(statement, params)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\engine\base.py", line 948, in execute
return meth(self, multiparams, params)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\sql\elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\engine\base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\engine\base.py", line 1200, in _execute_context
context)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\engine\base.py", line 1413, in _handle_dbapi_exception
exc_info
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\util\compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\util\compat.py", line 248, in reraise
raise value.with_traceback(tb)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\engine\base.py", line 1193, in _execute_context
context)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\sqlalchemy\engine\default.py", line 509, in do_execute
cursor.execute(statement, parameters)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\cursors.py", line 135, in execute
self.errorhandler(exc, value)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\cursors.py", line 37, in errorhandler
self.connection.errorhandler(self, errorclass, errorvalue)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\connections.py", line 117, in errorhandler
raise errorvalue
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\cursors.py", line 130, in execute
self._query(query)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\cursors.py", line 240, in _query
conn.query(q)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\connections.py", line 346, in query
self._result = MySQLResult(self)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\packet.py", line 266, in __init__
self.first_packet = MysqlPacket(self.connection)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\packet.py", line 65, in __init__
raise_mysql_exception(self.__data)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\err.py", line 149, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "C:\Users\dell\.virtualenvs\fisher-q3p71Sqa\lib\site-packages\cymysql\err.py", line 144, in _check_mysql_exception
raise InternalError(errno, errorvalue)
1回答
-
数据库里手动加上一个status字段
112018-07-17
相似问题
回答 1
回答 2