From 2d8c6b98436ec14fbee75414e76317313bb6b2ed Mon Sep 17 00:00:00 2001 From: Claudio Sacerdoti Coen Date: Fri, 28 Oct 2005 21:30:36 +0000 Subject: [PATCH] sql query fixed --- helm/matita/scripts/crontab.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/helm/matita/scripts/crontab.sh b/helm/matita/scripts/crontab.sh index ba63e00d2..f1f28356c 100644 --- a/helm/matita/scripts/crontab.sh +++ b/helm/matita/scripts/crontab.sh @@ -12,7 +12,7 @@ cvs -d $CVSROOT co helm/matita/scripts 1>/dev/null 2>/dev/null helm/matita/scripts/profile_cvs.sh 2> LOG CUR_TIME=`/usr/bin/php4 -c /etc/php4/apache/php.ini - shell_adder.php -- public_html/common.php "select SEC_TO_TIME(SUM(TIME_TO_SEC(time))) from bench where mark = \"$MARK\" group by mark;"` -OLD_TIME=`/usr/bin/php4 -c /etc/php4/apache/php.ini - shell_adder.php -- public_html/common.php "select mark, SEC_TO_TIME(SUM(TIME_TO_SEC(time))) from bench where mark = \"$LASTMARK\" group by mark;"` +OLD_TIME=`/usr/bin/php4 -c /etc/php4/apache/php.ini - shell_adder.php -- public_html/common.php "select SEC_TO_TIME(SUM(TIME_TO_SEC(time))) from bench where mark = \"$LASTMARK\" group by mark;"` if [ -z "$CUR_TIME" -o -z "$OLD_TIME" ]; then echo "No benchamks records for $MARK" -- 2.39.2