flask 学习错误总结 (sqlite3.OperationalError) no such table / no such column

laughing_l

于 2017-10-21 10:12:12 发布

阅读量9.9k

点赞数

CC 4.0 BY-SA版权

文章标签： flask

本文链接：https://blog.youkuaiyun.com/laughing_l/article/details/78301608

在学习Flask时遇到sqlite3.OperationalError错误，原因是数据库表格缺失。解决方案包括检查数据库配置，确保运行迁移命令更新数据库结构。在项目开始时，使用`python db create`、`python db migrate`、`python db upgrade`。当数据库更改后，需运行`python db migrate`和`python db upgrade`进行更新。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在学习flask狗书的时候在第七章的时候将hello.py分解成为程序结构的时候出现这个

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users [SQL: 'SELECT users.id AS users_id, users.username AS users_username, users.role_id AS users_role_id \nFROM users \nWHERE users.username = ?\n LIMIT ? OFFSET ?']

在谷歌了很久以后发现了作者的回答 you probably missed the fact that after the restructure in chapter 7 the name of the database has changed. Post chapter 7 the application has multiple configurations, and each configuration uses a different database. So you are probably using an empty database that has no tables. If you run manage.py db upgrade you s