919620af4ae7a9d4d901d445a04e844324b89f9e
galt
  Mon Jan 24 22:12:33 2022 -0800
Fixing compatibility for MariaDb 10.6 which has a new keyword "offset". refs #28799

diff --git src/hg/cgilib/ensFace.c src/hg/cgilib/ensFace.c
index 33f6a00..56299d0 100644
--- src/hg/cgilib/ensFace.c
+++ src/hg/cgilib/ensFace.c
@@ -83,31 +83,31 @@
     (void) sqlQuickQuery(conn,query,ensemblName,ArraySize(ensemblName));
     }
 return ensemblName;
 }
 
 static int liftToEnsembl(char *database, char *chrom)
 /* if table ENSEMBL_LIFT exists in the given database, return the
    offset for this chrom, else return zero */
 {
 int offset = 0;
 struct sqlConnection *conn = hAllocConn(database);
 
 if (sqlTableExists(conn, ENSEMBL_LIFT))
     {
     char query[256];
-    sqlSafef(query, ArraySize(query), "select offset from %s where chrom='%s'",
+    sqlSafef(query, ArraySize(query), "select `offset` from %s where chrom='%s'",
 	ENSEMBL_LIFT, chrom);
     offset = sqlQuickNum(conn,query); // returns 0 for failed query
     }
 return offset;
 }
 
 struct dyString *ensContigViewUrl(
 char *database, char *ensOrg, char *chrom, int chromSize,
                             int winStart, int winEnd, char *archive)
 /* Return a URL that will take you to ensembl's contig view. */
 /* Not using chromSize.  archive is possibly a date reference */
 {
 struct dyString *dy = dyStringNew(0);
 char *chrName;
 char *ensemblName = ucscToEnsembl(database, chrom);