Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Commits

Ticket #10650: mythweb problem setting recording to dont record in 0.25

 

 

MythTV commits RSS feed   Index | Next | Previous | View Threaded


noreply at mythtv

Apr 23, 2012, 8:03 PM

Post #1 of 5 (152 views)
Permalink
Ticket #10650: mythweb problem setting recording to dont record in 0.25

#10650: mythweb problem setting recording to dont record in 0.25
----------------------------+----------------------------------------------
Reporter: | Owner: kormoc
david.osguthorpe@… | Status: new
Type: Patch - | Milestone: 0.25.1
Bug Fix | Version: 0.25-fixes
Priority: major | Keywords: mythweb dont record schedule.php
Component: Plugin - |
MythWeb |
Severity: high |
Ticket locked: 0 |
----------------------------+----------------------------------------------
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

--
Ticket URL: <http://code.mythtv.org/trac/ticket/10650>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits


noreply at mythtv

Apr 23, 2012, 8:43 PM

Post #2 of 5 (146 views)
Permalink
Re: Ticket #10650: mythweb problem setting recording to dont record in 0.25 [In reply to]

#10650: mythweb problem setting recording to dont record in 0.25
----------------------------------------------+----------------------------
Reporter: david.osguthorpe@… | Owner: kormoc
Type: Patch - Bug Fix | Status: assigned
Priority: minor | Milestone: unknown
Component: Plugin - MythWeb | Version: 0.25-fixes
Severity: medium | Resolution:
Keywords: mythweb dont record schedule.php | Ticket locked: 0
----------------------------------------------+----------------------------
Changes (by wagnerrp):

* priority: major => minor
* severity: high => medium
* status: new => assigned
* milestone: 0.25.1 => unknown


Old description:

> 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

New description:

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
}}}

--

--
Ticket URL: <http://code.mythtv.org/trac/ticket/10650#comment:1>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits


noreply at mythtv

Apr 30, 2012, 9:44 AM

Post #3 of 5 (132 views)
Permalink
Re: Ticket #10650: mythweb problem setting recording to dont record in 0.25 [In reply to]

#10650: mythweb problem setting recording to dont record in 0.25
----------------------------------------------+----------------------------
Reporter: david.osguthorpe@… | Owner: kormoc
Type: Patch - Bug Fix | Status: assigned
Priority: minor | Milestone: unknown
Component: Plugin - MythWeb | Version: 0.25-fixes
Severity: medium | Resolution:
Keywords: mythweb dont record schedule.php | Ticket locked: 0
----------------------------------------------+----------------------------

Comment (by david.osguthorpe@…):

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

--
Ticket URL: <http://code.mythtv.org/trac/ticket/10650#comment:2>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits


noreply at mythtv

Apr 30, 2012, 3:07 PM

Post #4 of 5 (133 views)
Permalink
Re: Ticket #10650: mythweb problem setting recording to dont record in 0.25 [In reply to]

#10650: mythweb problem setting recording to dont record in 0.25
----------------------------------------------+----------------------------
Reporter: david.osguthorpe@… | Owner: kormoc
Type: Patch - Bug Fix | Status: closed
Priority: minor | Milestone: unknown
Component: Plugin - MythWeb | Version: 0.25-fixes
Severity: medium | Resolution: fixed
Keywords: mythweb dont record schedule.php | Ticket locked: 0
----------------------------------------------+----------------------------
Changes (by David Engel <david@…>):

* status: assigned => closed
* resolution: => fixed


Comment:

In [changeset:8c43d8da31d738c75ec6abc9daff2772b16310c8/mythweb]:
{{{
#!CommitTicketReference repository="mythweb"
revision="8c43d8da31d738c75ec6abc9daff2772b16310c8"
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 .
}}}

--
Ticket URL: <http://code.mythtv.org/trac/ticket/10650#comment:3>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits


noreply at mythtv

May 4, 2012, 7:56 PM

Post #5 of 5 (121 views)
Permalink
Re: Ticket #10650: mythweb problem setting recording to dont record in 0.25 [In reply to]

#10650: mythweb problem setting recording to dont record in 0.25
----------------------------------------------+----------------------------
Reporter: david.osguthorpe@… | Owner: kormoc
Type: Patch - Bug Fix | Status: closed
Priority: minor | Milestone: 0.25.1
Component: Plugin - MythWeb | Version: 0.25-fixes
Severity: medium | Resolution: fixed
Keywords: mythweb dont record schedule.php | Ticket locked: 0
----------------------------------------------+----------------------------
Changes (by wagnerrp):

* milestone: unknown => 0.25.1


--
Ticket URL: <http://code.mythtv.org/trac/ticket/10650#comment:4>
MythTV <http://code.mythtv.org/trac>
MythTV Media Center
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-commits

MythTV commits RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.