Fix sql error: (GeneNetwork error: (_mysql_exceptions.OperationalError) (1054, "Unknown column 'mouse' in 'where clause'") [SQL: '\n select Geno)

1 files changed, 2 insertions, 2 deletions

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)