注册写入数据库失败

来源: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回答

7七月

2018-07-17

数据库里手动加上一个status字段

1
1
zmm064
原来如此,可能听课不仔细吧,没注意到这个,非常感谢~
2018-07-17
共1条回复

Python Flask高级编程之从0到1开发《鱼书》精品项目

7月老师深入浅出剖析Flask核心机制,和你一起探讨Python高级编程

2770 学习 · 1280 问题

查看课程