sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: css_templates

本文介绍了一种在使用Python的SQLAlchemy ORM时遇到的OperationalError错误,并提供了详细的错误堆栈跟踪信息。通过更改Superset项目的数据库配置,从SQLite切换到MySQL,成功解决了找不到指定表的问题。
部署运行你感兴趣的模型镜像

报错

  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2855, in __iter__
    return self._execute_and_instances(context)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2878, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 945, in execute
    return meth(self, multiparams, params)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
    context)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
    exc_info
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
    raise value.with_traceback(tb)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
    context)
  File "/home/as/anaconda3/envs/superset/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: css_templates [SQL: 'SELECT css_templates.created_on AS css_templates_created_on, css_templates.changed_on AS css_templates_changed_on, css_templates.id AS css_templates_id, css_templates.template_name AS css_templates_template_name, css_templates.css AS css_templates_css, css_templates.changed_by_fk AS css_templates_changed_by_fk, css_templates.created_by_fk AS css_templates_created_by_fk \nFROM css_templates \nWHERE css_templates.template_name = ?\n LIMIT ? OFFSET ?'] [parameters: ('Flat', 1, 0)]

解决
python脚本无法找到SQLLife文件,正确设置文件路径就能解决
由于我之前没怎么接触过数据库(sqlite),不知道在哪修改文件路径,所以我将superset连接到其他数据库(mysql)
到superset目录下找到配置文件config.py
这里写图片描述
在红色标记处修改即可

您可能感兴趣的与本文相关的镜像

Python3.10

Python3.10

Conda
Python

Python 是一种高级、解释型、通用的编程语言,以其简洁易读的语法而闻名,适用于广泛的应用,包括Web开发、数据分析、人工智能和自动化脚本

评论 10
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值