b6c8b1286c213a0dabca4a0728d647b8b505ee30
hiram
  Mon Jan 19 14:03:54 2026 -0800
improved ottoRequest table structure refs #31811

diff --git src/hg/hubApi/liftOver.c src/hg/hubApi/liftOver.c
index bb894bb5f4b..0deb94f4cf7 100644
--- src/hg/hubApi/liftOver.c
+++ src/hg/hubApi/liftOver.c
@@ -316,23 +316,23 @@
     */
     (void) mailViaPipe(toAddr, "liftOver request", msg->string, fromAddr);
 
     /* some kind of response here back to the request page */
     struct jsonWrite *jw = apiStartOutput();
     jsonWriteString(jw, "msg", dyStringCannibalize(&msg));
     apiFinishOutput(0,NULL,jw);
     char *ottoTable = cfgOption("ottoTable");	/* probably ottoRequest */
     if (isNotEmpty(ottoTable))
         {
         struct sqlConnection *conn = hConnectCentral();
         if (sqlTableExists(conn, ottoTable))
 	    {
             struct dyString *update = newDyString(0);
             sqlDyStringPrintf(update,
-		"INSERT INTO %s VALUES ( '%s','%s','%s','%s')",
+		"INSERT INTO %s (fromDb, toDb, email, comment, requestTime) VALUES ( '%s','%s','%s','%s',now())",
 		ottoTable,  fromGenome, toGenome, email, comment);
             sqlUpdate(conn, dyStringCannibalize(&update));
 	    }
         hDisconnectCentral(&conn);
         }
     }
 }	/*	void apiLiftRequest(char *words[MAX_PATH_INFO])	*/