Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'finance.sys_user' doesn't exist") #6

Open
githubssj opened this issue Apr 9, 2021 · 0 comments

Comments

@githubssj
Copy link

Traceback (most recent call last):
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 2314, in wsgi_app
response = self.handle_exception(e)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1760, in handle_exception
reraise(exc_type, exc_value, tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/_compat.py", line 36, in reraise
raise value
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 2311, in wsgi_app
response = self.full_dispatch_request()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1834, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1737, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/_compat.py", line 36, in reraise
raise value
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1832, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1818, in dispatch_request
return self.view_functionsrule.endpoint
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/manager.py", line 144, in register
db.session.commit()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 162, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1027, in commit
self.transaction.commit()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 494, in commit
self._prepare_impl()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 473, in _prepare_impl
self.session.flush()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2459, in flush
self._flush(objects)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2597, in _flush
transaction.rollback(_capture_exception=True)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 154, in reraise
raise value
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2557, in _flush
flush_context.execute()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
rec.execute(self)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
uow,
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
insert,
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1138, in _emit_insert_statements
statement, params
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
return meth(self, multiparams, params)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
distilled_params,
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
e, statement, parameters, cursor, context
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 399, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
raise value.with_traceback(tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 550, in do_execute
cursor.execute(statement, parameters)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'finance.sys_user' doesn't exist")
[SQL: INSERT INTO sys_user (username, password_hash, email, phone, avatar, status, createBy, updateBy) VALUES (%(username)s, %(password_hash)s, %(email)s, %(phone)s, %(avatar)s, %(status)s, %(createBy)s, %(updateBy)s)]
[parameters: {'username': 'aaa', 'password_hash': 'pbkdf2:sha256:50000$TpmCD9aK$aa6f334f3a6852921b0bd1fad12f0c3ffa3ab9386dc1c09039a94da882e7824e', 'email': None, 'phone': None, 'avatar': None, 'status': 1, 'createBy': None, 'updateBy': None}]
(Background on this error at: http://sqlalche.me/e/f405)
请问这里该怎么处理? 能给个提示么?谢谢

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant