<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 04/10/2012 11:38 AM, Michael Drons wrote:
<blockquote
cite="mid:1334072317.79975.YahooMailNeo@web160204.mail.bf1.yahoo.com"
type="cite">
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255,
255); font-family: times new roman,new york,times,serif;
font-size: 12pt;">
<div>Appears to be an error in mythweb sql statements.</div>
<div><br>
</div>
<div>2012-04-10 11:29:00.834061 E [1771/1800] Scheduler
mythdbcon.cpp:823 (prepare) - Error preparing query: REPLACE
INTO recordmatch (recordid, 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)
Manchester City vs. West Bromwich WHERE record.recordid =
:NR0RECID AND program.manualid = 0 AND ( From Etihad Stadium.
) 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) ) ) ) ) ) ) ) ))<br>
2012-04-10 11:29:00.834073 E [1771/1800] Scheduler
mythdbcon.cpp:825 (prepare) - Driver error was [2/1064]:<br>
QMYSQL3: Unable to prepare statement<br>
Database error was:<br>
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 'Manchester City vs. West Bromwich WHERE
record.recordid = ? AND program.manualid' at line 1<br>
<br>
2012-04-10 11:29:00.834186 E [1771/1800] Scheduler
mythdb.cpp:192 (DBError) - DB Error (UpdateMatches3):<br>
Query was:<br>
REPLACE INTO recordmatch (recordid, 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) Manchester City vs. West Bromwich WHERE
record.recordid = :NR0RECID AND program.manualid = 0 AND (
From Etihad Stadium. ) 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) ) ) ) ) ) ) ) ))<br>
Bindings were:<br>
:NR0RECID="421"<br>
Driver error was [2/1064]:<br>
QMYSQL: Unable to execute query<br>
Database error was:<br>
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 'Manchester City vs. West Brom<br>
</div>
<div><br>
</div>
<div>myth src # mythbackend --version<br>
Please attach all output as a file in bug reports.<br>
MythTV Version : v0.25<br>
MythTV Branch : fixes/0.25<br>
Network Protocol : 72<br>
Library API : 0.25.20120408-1<br>
QT Version : 4.6.3<br>
Options compiled in:<br>
linux profile use_hidesyms using_alsa using_oss using_backend
using_bindings_perl using_bindings_python using_bindings_php
using_firewire using_frontend using_hdhomerun using_hdpvr
using_iptv using_ivtv using_joystick_menu using_libcec
using_libcrypto using_libdns_sd using_libfftw3 using_libxml2
using_libudf using_lirc using_mheg using_opengl_video
using_qtwebkit using_qtscript using_qtdbus using_v4l2
using_v4l1 using_x11 using_xrandr using_xv using_bindings_perl
using_bindings_python using_bindings_php using_mythtranscode
using_opengl using_vdpau using_ffmpeg_threads using_live
using_mheg using_libass using_libxml2 using_libudf<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>I see the above error using commit
1d056f77dc29045008b52b82e90bc935ff1ab948 of mythweb<br>
</div>
</div>
</blockquote>
<br>
When doing what?<br>
<br>
<blockquote
cite="mid:1334072317.79975.YahooMailNeo@web160204.mail.bf1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff; font-family:times
new roman, new york, times, serif;font-size:12pt">
<div><br>
</div>
<div>If I use commit efd3da660e2f1220372253a7c92f964ff1c5047a I
dont have any issues.</div>
<br>
</div>
</blockquote>
<br>
I looks like you might have a broken custom recording rule?<br>
<br>
Mike<br>
</body>
</html>