Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#10650 closed Patch - Bug Fix (fixed)

mythweb problem setting recording to dont record in 0.25

Reported by: david.osguthorpe@… 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 Raymond Wagner)

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)

Schedule.php.patch (1.3 KB) - added by anonymous 8 years ago.
Schedule.php.2.patch (1.5 KB) - added by anonymous 8 years ago.

Download all attachments as: .zip

Change History (6)

Changed 8 years ago by anonymous

Attachment: Schedule.php.patch added

comment:1 Changed 8 years ago by Raymond Wagner

Description: modified (diff)
Milestone: 0.25.1unknown
Priority: majorminor
Severity: highmedium
Status: newassigned

Changed 8 years ago by anonymous

Attachment: Schedule.php.2.patch added

comment:2 Changed 8 years ago by david.osguthorpe@…

Discovered stupid flaw in the patch - only fixup search flag for dontrec recording type

comment:3 Changed 8 years ago by David Engel <david@…>

Resolution: fixed
Status: assignedclosed

In 8c43d8da31d738c75ec6abc9daff2772b16310c8/mythweb:

Clear the search type when creating an override or don't record for
non-manual rules. Based on a patch from david.osguthorpe.

Fixes #10580 and fixes #10650 .

comment:4 Changed 8 years ago by Raymond Wagner

Milestone: unknown0.25.1
Note: See TracTickets for help on using tickets.