From 1cae8e42f0f73718549b369cf0cd4d9f320e230e Mon Sep 17 00:00:00 2001 From: Lei Yan Date: Fri, 18 Nov 2016 21:16:53 +0000 Subject: Fix sql error: (GeneNetwork error: (_mysql_exceptions.OperationalError) (1054, "Unknown column 'mouse' in 'where clause'") [SQL: '\n select Geno) --- wqflask/base/data_set.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'wqflask') diff --git a/wqflask/base/data_set.py b/wqflask/base/data_set.py index 918932fa..ae7fdcb5 100644 --- a/wqflask/base/data_set.py +++ b/wqflask/base/data_set.py @@ -724,8 +724,8 @@ class PhenotypeDataSet(DataSet): if this_trait.lrs: query = """ select Geno.Chr, Geno.Mb from Geno, Species - where Species.Name = %s and - Geno.Name = %s and + where Species.Name = '%s' and + Geno.Name = '%s' and Geno.SpeciesId = Species.Id """ % (species, this_trait.locus) logger.sql(query) -- cgit v1.2.3