mysql 5.0.42 breaks mythfilldatabase in 0.20/0.20.1

[anonymous]

I was recently upgrading my system, one of the components upgraded was mysql. I noticed that recordings were mysteriously disappearing from the schedule, and tracked it down to this semantic change in mysql:

​http://bugs.mysql.com/bug.php?id=28929

Basically, how mysql compares a date to a datetime has changed. This results in the following code in mythfilldatabase/filldata.cpp:

query.prepare("DELETE FROM record WHERE (type = :SINGLE "

"OR type = :OVERRIDE OR type = :DONTRECORD) " "AND enddate < NOW();");

erroneously deleting all single episode recordings scheduled for that day when it runs.

"CURDATE()" can be used instead of "NOW()", which seems to resolve the problem.

[stuartm]

This was fixed in trunk and -fixes four weeks ago.