e779834c394402558b8f0348b134a128efafafd4 larrym Thu May 24 12:15:10 2012 -0700 add "name = ensGene" to select in ensGeneTrackVersion to include to fix problem caused by entries for other tracks in trackVersion table diff --git src/hg/lib/ensFace.c src/hg/lib/ensFace.c index f77bb25..d6e8d05 100644 --- src/hg/lib/ensFace.c +++ src/hg/lib/ensFace.c @@ -135,28 +135,28 @@ return dy; } void ensGeneTrackVersion(char *database, char *ensVersionString, char *ensDateReference, int stringSize) /* check for trackVersion table and find Ensembl version */ { /* see if hgFixed.trackVersion exists */ boolean trackVersionExists = (sqlDatabaseExists("hgFixed") && hTableExists("hgFixed", "trackVersion")); ensVersionString[0] = 0; ensDateReference[0] = 0; if (trackVersionExists) { struct sqlConnection *conn = hAllocConn("hgFixed"); char query[256]; - safef(query, sizeof(query), "select version,dateReference from hgFixed.trackVersion where db = '%s' order by updateTime DESC limit 1", database); + safef(query, sizeof(query), "select version,dateReference from hgFixed.trackVersion where db = '%s' and name = 'ensGene' order by updateTime DESC limit 1", database); struct sqlResult *sr = sqlGetResult(conn, query); char **row; while ((row = sqlNextRow(sr)) != NULL) { safef(ensVersionString, stringSize, "Ensembl %s", row[0]); safef(ensDateReference, stringSize, "%s", row[1]); } sqlFreeResult(&sr); hFreeConn(&conn); } }