av一区二区在线观看_亚洲男人的天堂网站_日韩亚洲视频_在线成人免费_欧美日韩精品免费观看视频_久草视

您的位置:首頁技術文章
文章詳情頁

python - 深入理解Flask 第三章代碼運行報錯, 代碼完全正常,為什么報SQL語法錯誤?

瀏覽:132日期:2022-06-29 14:18:28

問題描述

原句posts = Post.query.order_by(Post.publish_date.desc()).paginate(page, 10)

路由這里已經定義 page=1了, 作者不可能寫錯代碼啊, 我設置了utf-8編碼也不行@app.route(’/’)@app.route(’/<int:page>’)def home(page=1): posts = Post.query.order_by(Post.publish_date.desc()).paginate(page, 10) recent, top_tags = sidebar_data() return render_template(’home.html’,posts=posts,recent=recent,top_tags=top_tags )

/Library/Python/2.7/site-packages/sqlalchemy/sql/compiler.py:624: SAWarning: Can’t resolve label reference ’total DESC’; converting to text() (this warning may be suppressed after 10 occurrences) util.ellipses_string(element.element))127.0.0.1 - - [07/Jun/2017 14:44:06] 'GET / HTTP/1.1' 500 -Traceback (most recent call last): File '/Library/Python/2.7/site-packages/flask/app.py', line 1994, in __call__ return self.wsgi_app(environ, start_response) File '/Library/Python/2.7/site-packages/flask/app.py', line 1985, in wsgi_app response = self.handle_exception(e) File '/Library/Python/2.7/site-packages/flask/app.py', line 1540, in handle_exception reraise(exc_type, exc_value, tb) File '/Library/Python/2.7/site-packages/flask/app.py', line 1982, in wsgi_app response = self.full_dispatch_request() File '/Library/Python/2.7/site-packages/flask/app.py', line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File '/Library/Python/2.7/site-packages/flask/app.py', line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File '/Library/Python/2.7/site-packages/flask/app.py', line 1612, in full_dispatch_request rv = self.dispatch_request() File '/Library/Python/2.7/site-packages/flask/app.py', line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/main.py', line 114, in home top_tags=top_tags File '/Library/Python/2.7/site-packages/flask/templating.py', line 134, in render_template context, ctx.app) File '/Library/Python/2.7/site-packages/flask/templating.py', line 116, in _render rv = template.render(context) File '/Library/Python/2.7/site-packages/jinja2/environment.py', line 1008, in render return self.environment.handle_exception(exc_info, True) File '/Library/Python/2.7/site-packages/jinja2/environment.py', line 780, in handle_exception reraise(exc_type, exc_value, tb) File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/home.html', line 1, in top-level template code {% extends 'base.html' %} File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/base.html', line 45, in top-level template code {% block body %} File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/home.html', line 38, in block 'body' {{ render_pagination(posts, ’home’) }} File '/Library/Python/2.7/site-packages/jinja2/runtime.py', line 551, in _invoke rv = self._func(*arguments) File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/base.html', line 5, in template <a href='http://m.4tl426be.cn/wenda/{{ url_for(’home’, page=pagination.prev().page) }}' aria-label='Previous'> File '/Library/Python/2.7/site-packages/flask_sqlalchemy/__init__.py', line 338, in prev return self.query.paginate(self.page - 1, self.per_page, error_out) File '/Library/Python/2.7/site-packages/flask_sqlalchemy/__init__.py', line 475, in paginate items = self.limit(per_page).offset((page - 1) * per_page).all() File '/Library/Python/2.7/site-packages/sqlalchemy/orm/query.py', line 2703, in all return list(self) File '/Library/Python/2.7/site-packages/sqlalchemy/orm/query.py', line 2855, in __iter__ return self._execute_and_instances(context) File '/Library/Python/2.7/site-packages/sqlalchemy/orm/query.py', line 2878, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 945, in execute return meth(self, multiparams, params) File '/Library/Python/2.7/site-packages/sqlalchemy/sql/elements.py', line 263, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1053, in _execute_clauseelement compiled_sql, distilled_params File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1189, in _execute_context context) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1402, in _handle_dbapi_exception exc_info File '/Library/Python/2.7/site-packages/sqlalchemy/util/compat.py', line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1182, in _execute_context context) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/default.py', line 470, in do_execute cursor.execute(statement, parameters) File '/Library/Python/2.7/site-packages/MySQLdb/cursors.py', line 205, in execute self.errorhandler(self, exc, value) File '/Library/Python/2.7/site-packages/MySQLdb/connections.py', line 36, in defaulterrorhandler raise errorclass, errorvalueProgrammingError: (_mysql_exceptions.ProgrammingError) (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’-10, 10’ at line 3') [SQL: u’SELECT post.id AS post_id, post.title AS post_title, post.text AS post_text, post.publish_date AS post_publish_date, post.user_id AS post_user_id nFROM post ORDER BY post.publish_date DESC n LIMIT %s, %s’] [parameters: (-10, 10)]127.0.0.1 - - [07/Jun/2017 14:44:06] 'GET /?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1' 200 -127.0.0.1 - - [07/Jun/2017 14:44:06] 'GET /?__debugger__=yes&cmd=resource&f=jquery.js HTTP/1.1' 200 -127.0.0.1 - - [07/Jun/2017 14:44:06] 'GET /?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1' 200 -(<type ’int’>, 1)127.0.0.1 - - [07/Jun/2017 14:44:06] 'GET / HTTP/1.1' 500 -Traceback (most recent call last): File '/Library/Python/2.7/site-packages/flask/app.py', line 1994, in __call__ return self.wsgi_app(environ, start_response) File '/Library/Python/2.7/site-packages/flask/app.py', line 1985, in wsgi_app response = self.handle_exception(e) File '/Library/Python/2.7/site-packages/flask/app.py', line 1540, in handle_exception reraise(exc_type, exc_value, tb) File '/Library/Python/2.7/site-packages/flask/app.py', line 1982, in wsgi_app response = self.full_dispatch_request() File '/Library/Python/2.7/site-packages/flask/app.py', line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File '/Library/Python/2.7/site-packages/flask/app.py', line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File '/Library/Python/2.7/site-packages/flask/app.py', line 1612, in full_dispatch_request rv = self.dispatch_request() File '/Library/Python/2.7/site-packages/flask/app.py', line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/main.py', line 114, in home top_tags=top_tags File '/Library/Python/2.7/site-packages/flask/templating.py', line 134, in render_template context, ctx.app) File '/Library/Python/2.7/site-packages/flask/templating.py', line 116, in _render rv = template.render(context) File '/Library/Python/2.7/site-packages/jinja2/environment.py', line 1008, in render return self.environment.handle_exception(exc_info, True) File '/Library/Python/2.7/site-packages/jinja2/environment.py', line 780, in handle_exception reraise(exc_type, exc_value, tb) File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/home.html', line 1, in top-level template code {% extends 'base.html' %} File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/base.html', line 45, in top-level template code {% block body %} File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/home.html', line 38, in block 'body' {{ render_pagination(posts, ’home’) }} File '/Library/Python/2.7/site-packages/jinja2/runtime.py', line 551, in _invoke rv = self._func(*arguments) File '/Users/andy/Desktop/Mastering Flask_Code Bundle/Chapter 3/chapter_3/templates/base.html', line 5, in template <a href='http://m.4tl426be.cn/wenda/{{ url_for(’home’, page=pagination.prev().page) }}' aria-label='Previous'> File '/Library/Python/2.7/site-packages/flask_sqlalchemy/__init__.py', line 338, in prev return self.query.paginate(self.page - 1, self.per_page, error_out) File '/Library/Python/2.7/site-packages/flask_sqlalchemy/__init__.py', line 475, in paginate items = self.limit(per_page).offset((page - 1) * per_page).all() File '/Library/Python/2.7/site-packages/sqlalchemy/orm/query.py', line 2703, in all return list(self) File '/Library/Python/2.7/site-packages/sqlalchemy/orm/query.py', line 2855, in __iter__ return self._execute_and_instances(context) File '/Library/Python/2.7/site-packages/sqlalchemy/orm/query.py', line 2878, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 945, in execute return meth(self, multiparams, params) File '/Library/Python/2.7/site-packages/sqlalchemy/sql/elements.py', line 263, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1053, in _execute_clauseelement compiled_sql, distilled_params File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1189, in _execute_context context) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1402, in _handle_dbapi_exception exc_info File '/Library/Python/2.7/site-packages/sqlalchemy/util/compat.py', line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py', line 1182, in _execute_context context) File '/Library/Python/2.7/site-packages/sqlalchemy/engine/default.py', line 470, in do_execute cursor.execute(statement, parameters) File '/Library/Python/2.7/site-packages/MySQLdb/cursors.py', line 205, in execute self.errorhandler(self, exc, value) File '/Library/Python/2.7/site-packages/MySQLdb/connections.py', line 36, in defaulterrorhandler raise errorclass, errorvalueProgrammingError: (_mysql_exceptions.ProgrammingError) (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’-10, 10’ at line 3') [SQL: u’SELECT post.id AS post_id, post.title AS post_title, post.text AS post_text, post.publish_date AS post_publish_date, post.user_id AS post_user_id nFROM post ORDER BY post.publish_date DESC n LIMIT %s, %s’] [parameters: (-10, 10)]

問題解答

回答1:

看到你的sql語句

select * from 表 limit -10, 10

正確的應該是

select * from 表 limit 0, 10

你page傳入的是0吧?至少是1起始啊

回答2:

數據庫,表沒建好

標簽: Python 編程
主站蜘蛛池模板: 国产精品夜间视频香蕉 | 亚洲精品免费在线 | 日韩成人影院在线观看 | 91精品久久久久久久久中文字幕 | 麻豆久久久 | 久青草影院 | 日韩精品免费视频 | 久久久免费| 欧美日韩综合 | 中文在线一区二区 | 一区二区在线看 | 亚洲精品国产偷自在线观看 | 香蕉久久久 | 欧日韩在线观看 | 色呦呦网站 | 欧美区在线观看 | 2019天天操| 欧美成人精品一区二区男人看 | 久久精品国产一区二区三区不卡 | www久久国产 | 欧美中文字幕一区二区三区 | 久久精品国产一区二区 | 高清18麻豆 | 91久久久久久久久 | 欧美一区二区在线视频 | 国产精品亚洲精品久久 | 久久一级免费视频 | 99精品免费久久久久久久久日本 | 欧美日韩综合 | 中文字幕第一页在线 | 91亚洲国产成人久久精品网站 | 国产福利在线看 | 欧美人人| 香蕉国产在线视频 | 国产亚洲精品久久19p | 看片91 | 另类亚洲视频 | 美女视频黄的 | 黄色大片免费观看 | 欧美激情精品久久久久久变态 | 男女羞羞免费视频 |