src/hg/qa/apacheMonitor.c 1.16

Index: src/hg/qa/apacheMonitor.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/qa/apacheMonitor.c,v
retrieving revision 1.15
retrieving revision 1.16
diff -b -B -U 4 -r1.15 -r1.16
--- src/hg/qa/apacheMonitor.c	16 Mar 2009 21:40:39 -0000	1.15
+++ src/hg/qa/apacheMonitor.c	20 Mar 2009 17:14:34 -0000	1.16
@@ -253,13 +253,14 @@
 
 if (status500)
     {
     safef(query, sizeof(query),
-	  "select remote_host, machine_id, request_uri, referer from access_log "
-	  "where time_stamp > %d and status = 500 order by timestamp desc limit 20\n", startTime);
+	  "select from_unixtime(time_stamp), remote_host, machine_id, request_uri, referer "
+	  "from access_log "
+	  "where time_stamp > %d and status = 500 order by time_stamp desc limit 20\n", startTime);
     sr = sqlGetResult(conn, query);
     while ((row = sqlNextRow(sr)) != NULL)
-        verbose(1, "%s\t%s\t%s\t%s\n", row[0], row[1], row[2], row[3]);
+        verbose(1, "%s\t%s\t%s\t%s\t%s\n", row[0], row[1], row[2], row[3], row[4]);
     sqlFreeResult(&sr);
     return;
     }