sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError)

最新推荐文章于 2024-02-28 16:03:37 发布

weixin_30627341

最新推荐文章于 2024-02-28 16:03:37 发布

阅读量650

点赞数

文章标签： python

原文链接：http://www.cnblogs.com/kk328/p/10428545.html

版权

在我学习flask建立网站时间碰到了一个棘手的问题，就是在我进行操作日志的更新时间，发现表格建立有点错误，导致表缺失，从而报了下面的错误

sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'movie.oplog' doesn't exist") [SQL: 'SELECT oplog.id AS oplog_id, oplog.admin_id AS oplog_admin_id, oplog.ip AS oplog_ip, oplog.reason AS oplog_reason, oplog.addtime AS oplog_addtime \nFROM oplog INNER JOIN `admin` ON `admin`.id = oplog.admin_id \nWHERE `admin`.id = oplog.admin_id ORDER BY oplog.addtime DESC \n LIMIT %(param_1)s, %(param_2)s'] [parameters: {'param_1': 0, 'param_2': 10}] (Background on this error at: http://sqlalche.me/e/f405)

我在下面的报错信息之中查找半天毫无收获，后来看到他一直报表找不到，于是重新建立吧

create table oplog(id int NOT NULL AUTO_INCREMENT,admin_id int,foreign key(admin_id)references admin(id),ip varchar(100),reason varchar(600),addtime datetime default now(),primary key(id));