Skip to content

Error: (sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter '2266952' #124

@javakevinfeng

Description

@javakevinfeng

在提交之前,请确认

  • 我已经查看了 FAQ 文档,但没有找到解决方案

问题描述

Error: (sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter '2266952'
原始SQL:INSERT INTO recording_scores (project_id,recording_number,result) VALUES ('13f7b73a-ba18-4ee2-b522-01296b81480c','87463449-e7cc-4710-acd9-42d9b2d8aeef','{"id":2266952,"duration":3155,"size":10}');
经过插件之后报错SQL:INSERT INTO recording_scores (project_id,recording_number,result) VALUES ('13f7b73a-ba18-4ee2-b522-01296b81480c','87463449-e7cc-4710-acd9-42d9b2d8aeef','{"id"%(2266952)s,"duration"%(3155)s,"size"%(10)s}');
问题所在:错误认为【:2266952】是占位符了转为【%(2266952)s】,这个字段值只是一段json字符串

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions