Opened 12 years ago
Closed 12 years ago
Last modified 12 years ago
#10650 closed Patch - Bug Fix (fixed)
mythweb problem setting recording to dont record in 0.25
Reported by: | Owned by: | Rob Smith | |
---|---|---|---|
Priority: | minor | Milestone: | 0.25.1 |
Component: | Plugin - MythWeb | Version: | 0.25-fixes |
Severity: | medium | Keywords: | mythweb dont record schedule.php |
Cc: | Ticket locked: | no |
Description (last modified by )
After updating to 0.25 was using mythweb as previously to disable recordings - this was failing - the entry did not remove in the upcoming recording page - although entry appeared in recording schedules Additionally an SQL error was reported in the mythbackend log about a badly formatted SQL statement
Sample error:
Error preparing query: REPLACE INTO recordmatch (rec ordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime, IF(search = 5, record.recordid, 0) FROM (record, program INNER JOIN channel ON channel.chanid = program.chanid) Duct Tape Island WHERE record.recordid = :NR26RECID AND program.manualid = 0 AND ( Adam and Jamie are abandoned on a desert island with only sticky silver adhesive can tape be used to find wa ter, food, build shelter and escape? ) AND channel.visible = 1 AND (((record.filter & 1) = 0) OR (program.previouslyshown = 0)) AND (( (record.filter & 2) = 0) OR (program.generic = 0)) AND (((record.filter & 4) = 0) OR (program.first > 0)) AND (((record.filter & 8) = 0 ) OR (HOUR(program.starttime) >= 19 AND HOUR(program.starttime) < 23)) AND (((record.filter & 16) = 0) OR (channel.commmethod = -2)) AND (((record.filter & 32) = 0) OR (program.hdtv > 0)) AND (((record.filter & 64) = 0) OR ((record.programid <> '' AND program.programid = record.programid) OR (record.programid = '' AND program.subtitle = record.subtitle AND program.description = record.description))) AND (((record.filter & 128) = 0) OR ((record.seriesid <> '' AND program.seriesid = record.seriesid))) AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10) OR ((record.station = channel.callsign) AND ((record.type = 3) OR ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime)) AND ((record.type = 2) OR ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime) AND ((record.type = 5) OR ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime)) AND (record.type <> 0) ) ) ) ) ) ) ) ))2012-04-23 17:05:37.223327 E [24736/24748] Scheduler mythdbcon.cpp:825 (prepare) - Driver error was [2/1064]:QMYSQL3: Unable to prepare statement Database error was: 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 'Duct Tape Island WHERE record.recordid = ? AND program.manualid = 0 AND ( Adam a' at line 1
Attachments (2)
Change History (6)
Changed 12 years ago by
Attachment: | Schedule.php.patch added |
---|
comment:1 Changed 12 years ago by
Description: | modified (diff) |
---|---|
Milestone: | 0.25.1 → unknown |
Priority: | major → minor |
Severity: | high → medium |
Status: | new → assigned |
Changed 12 years ago by
Attachment: | Schedule.php.2.patch added |
---|
comment:2 Changed 12 years ago by
comment:3 Changed 12 years ago by
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
comment:4 Changed 12 years ago by
Milestone: | unknown → 0.25.1 |
---|
Note: See
TracTickets for help on using
tickets.
Discovered stupid flaw in the patch - only fixup search flag for dontrec recording type