Closed cebel closed 1 year ago
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'count' in 'field list'") [SQL: INSERT INTO biogrid_experimental_system (id, experimental_system, experimental_system_type, count) VALUES (%(id)s, %(experimental_system)s, %(experimental_system_type)s, %(count)s)] [parameters: ({'id': 1, 'experimental_system': 'Affinity Capture-MS', 'experimental_system_type': 'physical', 'count': 765989}, {'id': 2, 'experimental_system': 'Negative Genetic', 'experimental_system_type': 'genetic', 'count': 563773}, {'id': 3, 'experimental_system': 'Two-hybrid', 'experimental_system_type': 'physical', 'count': 214487}, {'id': 4, 'experimental_system': 'Positive Genetic', 'experimental_system_type': 'genetic', 'count': 192139}, {'id': 5, 'experimental_system': 'Co-fractionation', 'experimental_system_type': 'physical', 'count': 141656}, {'id': 6, 'experimental_system': 'Proximity Label-MS', 'experimental_system_type': 'physical', 'count': 139234}, {'id': 7, 'experimental_system': 'Affinity Capture-Western', 'experimental_system_type': 'physical', 'count': 130188}, {'id': 8, 'experimental_system': 'Reconstituted Complex', 'experimental_system_type': 'physical', 'count': 63379} ... displaying 10 of 28 total bound parameter sets ... {'id': 27, 'experimental_system': 'Far Western', 'experimental_system_type': 'physical', 'count': 1342}, {'id': 28, 'experimental_system': 'Synthetic Haploinsufficiency', 'experimental_system_type': 'genetic', 'count': 379})]
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'count' in 'field list'") [SQL: INSERT INTO biogrid_experimental_system (id, experimental_system, experimental_system_type, count) VALUES (%(id)s, %(experimental_system)s, %(experimental_system_type)s, %(count)s)] [parameters: ({'id': 1, 'experimental_system': 'Affinity Capture-MS', 'experimental_system_type': 'physical', 'count': 765989}, {'id': 2, 'experimental_system': 'Negative Genetic', 'experimental_system_type': 'genetic', 'count': 563773}, {'id': 3, 'experimental_system': 'Two-hybrid', 'experimental_system_type': 'physical', 'count': 214487}, {'id': 4, 'experimental_system': 'Positive Genetic', 'experimental_system_type': 'genetic', 'count': 192139}, {'id': 5, 'experimental_system': 'Co-fractionation', 'experimental_system_type': 'physical', 'count': 141656}, {'id': 6, 'experimental_system': 'Proximity Label-MS', 'experimental_system_type': 'physical', 'count': 139234}, {'id': 7, 'experimental_system': 'Affinity Capture-Western', 'experimental_system_type': 'physical', 'count': 130188}, {'id': 8, 'experimental_system': 'Reconstituted Complex', 'experimental_system_type': 'physical', 'count': 63379} ... displaying 10 of 28 total bound parameter sets ... {'id': 27, 'experimental_system': 'Far Western', 'experimental_system_type': 'physical', 'count': 1342}, {'id': 28, 'experimental_system': 'Synthetic Haploinsufficiency', 'experimental_system_type': 'genetic', 'count': 379})]