Problems with while.pl of BZ 2.20.1 after update

[Vlad Dascalu]

This was probably fixed in 
https://bugzilla.mozilla.org/show_bug.cgi?id=327348 , there is a patch 
there available that you can apply manually.

Otherwise we're planning a new release within one week from now (we're 
currently doing QA on it).

Ralf Beckers wrote:
> 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