Skip to content

sqlalchemy internal error when trying to run unit_values.py #1

@marcinic

Description

@marcinic

occurred during the execution of conversion_factors() method.

sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1136, "Column count doesn't match value count at row 1") [SQL: 'INSERT INTO conversion_factors SELECT t1.commodity,t1.commodity_code,t1.reporter_code,t2.reporter_code,t1.year,t1.classification,t1.trade_flow as tf1, t2.trade_flow as tf2,t1.qty_unit, t2.qty_unit,t1.quantity as q1,t2.quantity as q2, t1.quantity/t2.quantity as ratio FROM comtradehs2015 as t1, comtradehs2015 as t2 WHERE t1.commodity_code=%s AND t1.commodity_code=t2.commodity_code AND t1.reporter_code=t2.partner_code AND t2.reporter_code=t1.partner_code AND t1.trade_flow_code!=t2.trade_flow_code AND t1.trade_flow_code!=3 AND t2.trade_flow_code!=3 AND t1.qty_unit_code=8 AND t2.qty_unit_code!=8'] [parameters: ('010110',)]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions