17af3825ff150ad27d687ebc7f1ebfddab473035 braney Thu Nov 9 15:14:26 2017 -0800 change error message for missing id in refLink #20505 diff --git src/hg/hgc/hgc.c src/hg/hgc/hgc.c index 8940ada..2b404e3 100644 --- src/hg/hgc/hgc.c +++ src/hg/hgc/hgc.c @@ -11760,31 +11760,31 @@ char *summary = NULL; boolean isXeno = sameString(tdb->table, "xenoRefGene"); struct refLink *rl; /* Make sure to escape single quotes for DB parseability */ if (strchr(rnaName, '\'')) { sqlRnaName = replaceChars(rnaName, "'", "''"); } /* get refLink entry */ if (version == NULL) { sqlSafef(query, sizeof(query), "select * from %s where mrnaAcc = '%s'", refLinkTable, sqlRnaName); sr = sqlGetResult(conn, query); if ((row = sqlNextRow(sr)) == NULL) - errAbort("Couldn't find %s in %s table - this accession may no longer be available.", rnaName, refLinkTable); + errAbort("This accession (%s) is no longer in our database. Check NCBI for status on this accession.", rnaName); rl = refLinkLoad(row); sqlFreeResult(&sr); } else { sqlSafef(query, sizeof(query), "select * from %s r, %s g where mrnaAcc = '%s' and r.mrnaAcc=g.acc and g.version='%s'", refLinkTable,gbCdnaInfoTable, sqlRnaName, version); sr = sqlGetResult(conn, query); if ((row = sqlNextRow(sr)) == NULL) { sqlFreeResult(&sr); return NULL; } rl = refLinkLoad(row); sqlFreeResult(&sr); }