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/hgTracks/simpleTracks.c src/hg/hgTracks/simpleTracks.c
index fa18fae..8eaccd4 100644
--- src/hg/hgTracks/simpleTracks.c
+++ src/hg/hgTracks/simpleTracks.c
@@ -13870,31 +13870,31 @@
 char query[256];
 struct sqlResult *sr;
 long long offset = 0;
 char *fileName = NULL;
 struct sqlConnection *conn;
 char **row;
 FILE *f;
 unsigned short *mem, *p;
 boolean complementBases = cartUsualBooleanDb(cart, database, COMPLEMENT_BASES_VAR, FALSE);
 
 if (!zoomedToBaseLevel)
 	return;
 
 conn = hAllocConn(database);
 sqlSafef(query, sizeof(query),
-	"select offset,fileName from %s where chrom = '%s'", tg->table,chromName);
+	"select `offset`,fileName from %s where chrom = '%s'", tg->table,chromName);
 sr = sqlGetResult(conn, query);
 if ((row = sqlNextRow(sr)) != NULL)
     {
     offset = sqlLongLong(row[0]);
     fileName = cloneString(row[1]);
     }
 
 sqlFreeResult(&sr);
 hFreeConn(&conn);
 
 if (offset == 0)
     return; /* we should have found a non-zero offset  */
 
 AllocVar(motif);
 motif->name = NULL;