880b3121f7dd2933128e7bf30759de9710b720dc max Mon Mar 12 13:35:31 2012 -0700 publications track description changes and fix for bold text bug see redmine #6833 diff --git src/hg/hgc/t2g.c src/hg/hgc/t2g.c index e1670da..6b8b4fc 100644 --- src/hg/hgc/t2g.c +++ src/hg/hgc/t2g.c @@ -53,31 +53,31 @@ if (names==0) errAbort("You need to specify at least one article section."); char* nameListString = slNameListToString(names, ','); slNameFree(names); return nameListString; } static struct sqlResult* queryMarkerRows(struct sqlConnection* conn, char* markerTable, char* articleTable, char* item, int itemLimit, char* sectionList) /* query marker rows from mysql, based on http parameters */ { char query[4000]; /* Mysql specific setting to make the group_concat function return longer strings */ -sqlUpdate(conn, "SET SESSION group_concat_max_len = 40000"); +sqlUpdate(conn, "SET SESSION group_concat_max_len = 100000"); safef(query, sizeof(query), "SELECT distinct %s.articleId, url, title, authors, citation," "group_concat(snippet, section SEPARATOR ' (...) ') FROM %s " "JOIN %s USING (articleId) " "WHERE markerId='%s' AND section in (%s) " "GROUP by articleId " "ORDER BY year DESC " "LIMIT %d", markerTable, markerTable, articleTable, item, sectionList, itemLimit); if (t2gDebug) printf("%s", query); struct sqlResult *sr = sqlGetResult(conn, query);