Opened 12 years ago

Closed 12 years ago

#3784 closed defect (invalid)

mysql 5.0.42 breaks mythfilldatabase in 0.20/0.20.1

Reported by: anonymous Owned by: Isaac Richards
Priority: major Milestone: unknown
Component: mythtv Version: 0.20-fixes
Severity: high Keywords: mysql mythfilldatabase
Cc: Ticket locked: no

Description

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.

Change History (1)

comment:1 Changed 12 years ago by stuartm

Resolution: invalid
Status: newclosed

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

Note: See TracTickets for help on using tickets.