Problems with while.pl of BZ 2.20.1 after update
vladd at bugzilla.org
Wed Mar 15 15:47:00 UTC 2006
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:
> 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,
More information about the developers