Problems with while.pl of BZ 2.20.1 after update

[Ralf Beckers]

Hi,

after updating, I get an error message from th while.pl cron job. It 
complains about an sql statement.

The table values for that while_schedule:

id eventid run_day run_time run_next	        mailto mailto_type
3  5  	   MF  	   7  	    2006-03-15 00:08:00 6      0

The sql statement generated by while.pl:
UPDATE whine_schedules SET run_next = CURRENT_DATE + INTERVAL 1 DAY + 
INTERVAL 8 HOUR WHERE id = 3

The full error message:
DBD::mysql::st execute failed: You have an error in your SQL syntax. 
Check the manual that corresponds to your MySQL server version for the 
right syntax to use near '(run_next = (CURRENT_DATE + INTERVAL '1' DAY + 
INTERVAL '7' HOU [for Statement "UPDATE whine_schedules SET (run_next = 
(CURRENT_DATE + INTERVAL ? DAY + INTERVAL ? HOUR)) WHERE id = ?"] at 
./whine.pl line 612
	main::reset_timer(3) called at ./whine.pl line 296
	main::get_next_event() called at ./whine.pl line 324
DBI::db=HASH(0x89cae88)->disconnect invalidates 1 active statement 
handle (either destroy statement handles or call finish on them before 
disconnecting) at Bugzilla.pm line 182.

CURRENT_DATE + INTERVAL 1 DAY works when using it manually in 
phpmyadmin, but not with an appended + INTERVAL 1 DAY.

I'm using mysql version 4.0.21.

Thanks for any hints,
Ralf
-- 
Ralf Beckers
Lead Development Engineer
ChipVision Design Systems AG
Fritz-Bock-Strasse 5 - 26121 Oldenburg - Germany

phone +49-441-35042-360   fax +49-441-35042-350
email ralf.beckers at chipvision.com                       www.chipvision.com