752e20a9a1dc08793c5b529bbeac4ce5836a6be4
braney
  Fri Sep 4 17:13:55 2026 -0700
hgc: stop five details-page handlers from aborting over a missing piece.

chromSeqFileExists() opened its connection with sqlConnect() and only then
asked whether the database existed, so it aborted before it could answer.
The otherDb of a chain or net track is often not a local database at all --
a GenArk hub assembly, or one long retired -- so use sqlMayConnect() and
return FALSE. This is 112 of the failures the TrackCheck robot reports, most
of them hg38 net tracks against HPRC assemblies. Also moved the disconnect
out of the if, where it leaked a connection whenever a database had no
chromInfo table, and dropped the now-redundant sqlDatabaseExists() call,
which was itself a second connection.

mgcCloneInfoLoad() aborted when a clone carried no MGC: id in
hgFixed.mrnaClone. Nothing on the page reads that field, and a clone can
legitimately have only an IMAGE: id, so the check went away rather than the
page. hDbOrganism() aborted for an assembly that has left dbDb but is still
named by a maf component, which hg16.evofold does via mm3; it now falls back
on the database name.

The pgSnp SIFT and Polyphen prediction tables are loaded separately from the
tracks that name them, so a machine can have the track and not the table, as
hgwbeta and the RR do for hg18. Check with hTableExists first and say the
predictions are unavailable instead of letting the query take the page down.
Same treatment for the RNA fold diagram: a non-zero ghostscript exit now
drops only the diagram and keeps the rest of the page, including the
PseudoViewer link.

Two of these report an unavailable piece through warn(), which still marks
the page for the robot. That is deliberate -- the missing hg18 tables and
the RNA fold diagram are real defects, and the log should keep naming them
until they are fixed. On the RNA fold diagram in particular: RNAplot
truncates the sequence id it is given to 42 characters, and the trash path
we build is already 41, so it has never written the file ghostscript is
asked to convert. That is worth its own fix.

refs #37424

diff --git src/hg/cgilib/pgSiftPred.c src/hg/cgilib/pgSiftPred.c
index b8a64f2ba2b..0be05428c59 100644
--- src/hg/cgilib/pgSiftPred.c
+++ src/hg/cgilib/pgSiftPred.c
@@ -220,30 +220,40 @@
 if (sep == ',') fputc('"',f);
 fprintf(f, "%s", el->ceuAlleleFreq);
 if (sep == ',') fputc('"',f);
 fputc(lastSep,f);
 }
 
 /* -------------------------------- End autoSql Generated Code -------------------------------- */
 
 void printPgSiftPred (char *db, char *tableName, struct pgSnp *item)
 /* print the predictions for an hgc item click for a pgSnp track */
 {
 struct pgSiftPred *el;
 struct sqlResult *sr;
 char **row;
 char query[512];
+/* The prediction table is loaded separately from the pgSnp track that names it, so a
+ * machine can have the track and not the table (the hg18 pgSnp tables are missing on
+ * hgwbeta and on the RR).  Say so instead of aborting the details page.  refs #37424 */
+if (!hTableExists(db, tableName))
+    {
+    warn("SIFT predictions are not available: table %s, named by the pgSiftPredTab "
+        "setting, is missing from %s.", tableName, db);
+    return;
+    }
+
 struct sqlConnection *conn = hAllocConn(db);
 
 sqlSafef(query, sizeof(query), "select * from %s where chrom = '%s' and chromStart = %d and chromEnd = %d",
     tableName, item->chrom, item->chromStart, item->chromEnd);
 sr = sqlGetResult(conn, query);
 while ((row = sqlNextRow(sr)) != NULL)
     {
     el = pgSiftPredLoadWithNull(row);
     printf("<br><b>SIFT prediction</b>: %s\n", el->prediction);
     printf("<ul>");
     if (el->geneId != NULL && differentString(el->geneId, ""))
         printf("<li>Gene ID: %s</li>\n", el->geneId);
     if (el->geneName != NULL && differentString(el->geneName, ""))
         printf("<li>Gene name: %s</li>\n", el->geneName);
     if (el->geneDesc != NULL && differentString(el->geneDesc, ""))