[mythtv-users] !!NoTrans: Invalid argument supplied for foreach()!!
Aaron
aaron at rb303.net
Sat Jul 7 19:35:43 UTC 2012
On Sat, Jul 7, 2012 at 2:38 PM, Aaron <aaron at rb303.net> wrote:
> I just the latest fixes (v0.25.1-58-g1d41f74) this morning, now I am
> receiving the errors posted below. Steps I have taken so far, are
> reconfigure mythweb, and reboot, but that has not fixed the issue.
> What steps might I take to fix this?
>
> Warning at /usr/share/mythtv/mythweb/modules/tv/upcoming.php, line 91:
> !!NoTrans: Invalid argument supplied for foreach()!!
>
> Warning at /usr/share/mythtv/mythweb/modules/tv/detail.php, line 318:
> !!NoTrans: Invalid argument supplied for foreach()!!
>
>
> MythTV Version : v0.25.1-58-g1d41f74
> MythTV Branch : fixes/0.25
> Network Protocol : 72
> Library API : 0.25.20120506-1
> QT Version : 4.8.1
> Options compiled in:
> linux profile use_hidesyms using_alsa using_oss using_pulse
> using_pulseoutput using_backend using_bindings_perl
> using_bindings_python using_bindings_php using_crystalhd using_dvb
> using_firewire using_frontend using_hdhomerun using_ceton using_hdpvr
> using_iptv using_ivtv using_joystick_menu using_libcec using_libcrypto
> using_libdns_sd using_libxml2 using_lirc using_mheg using_opengl_video
> using_qtwebkit using_qtscript using_qtdbus using_v4l2 using_x11
> using_xrandr using_xv using_bindings_perl using_bindings_python
> using_bindings_php using_mythtranscode using_opengl using_vaapi
> using_vdpau using_ffmpeg_threads using_live using_mheg using_libass
> using_libxml2
Oh this is not good... No LiveTV, no upcoming recordings...
Any idea what this means?
Jul 7 15:32:23 gazerbeam mythbackend[1726]: I Scheduler
scheduler.cpp:2021 (HandleReschedule) Reschedule requested for id -1.
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:823 (prepare) Error preparing query: DELETE FROM
recordmatch
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3:
Unable to prepare statement#012Database error was:#012Table
'./mythconverg/recordmatch' is marked as crashed and last (automatic?)
repair failed
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdb.cpp:192 (DBError) DB Error (UpdateMatches):#012Query
was:#012DELETE FROM recordmatch#012Driver error was
[2/144]:#012QMYSQL: Unable to execute query#012Database error
was:#012Table './mythconverg/recordmatch' is marked as crashed and
last (automatic?) repair failed
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:823 (prepare) Error preparing query: DELETE oldrecorded
FROM oldrecorded LEFT JOIN recordmatch ON recordmatch.chanid =
oldrecorded.chanid AND recordmatch.starttime =
oldrecorded.starttime WHERE oldrecorded.future > 0 AND
recordmatch.recordid IS NULL
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3:
Unable to prepare statement#012Database error was:#012Table
'./mythconverg/recordmatch' is marked as crashed and last (automatic?)
repair failed
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdb.cpp:192 (DBError) DB Error (DeleteFuture):#012Query
was:#012DELETE oldrecorded FROM oldrecorded LEFT JOIN recordmatch ON
recordmatch.chanid = oldrecorded.chanid AND
recordmatch.starttime = oldrecorded.starttime WHERE
oldrecorded.future > 0 AND recordmatch.recordid IS NULL#012Driver
error was [2/144]:#012QMYSQL: Unable to execute query#012Database
error was:#012Table './mythconverg/recordmatch' is marked as crashed
and last (automatic?) repair failed
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:823 (prepare) Error preparing query: UPDATE recordmatch
INNER JOIN sched_temp_record ON (recordmatch.recordid =
sched_temp_record.recordid) INNER JOIN program ON (recordmatch.chanid
= program.chanid AND recordmatch.starttime =
program.starttime AND recordmatch.manualid =
program.manualid) LEFT JOIN oldrecorded ON (
sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND
program.title = oldrecorded.title AND program.generic = 0
AND ( (program.programid <> '' AND program.programid
= oldrecorded.programid) OR ( (program.programid =
'' OR oldrecorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (program.subtitle <> ''
AND program.subtitle = oldrecorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR (program.description
<> '' AND program.description = oldrecorded.description))
AND (((sched_temp_record.dupmethod & 0x08) = 0) OR
(program.subtitle <> '' AND (program.subtitle =
oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND
program.subtitle = oldrecorded.description))) OR
(program.subtitle = '' AND program.description <> '' AND
(program.description = oldrecorded.subtitle OR
(oldrecorded.subtitle = '' AND program.description =
oldrecorded.description)))) ) ) ) LEFT JOIN
sched_temp_recorded recorded ON ( sched_temp_record.dupmethod >
1 AND recorded.duplicate <> 0 AND program.title =
recorded.title AND program.generic = 0 AND recorded.recgroup
NOT IN ('LiveTV','Deleted') AND ( (program.programid
<> '' AND program.programid = recorded.programid) OR
( (program.programid = '' OR recorded.programid = '')
AND
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3:
Unable to prepare statement#012Database error was:#012Table
'./mythconverg/recordmatch' is marked as crashed and last (automatic?)
repair failed
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdb.cpp:192 (DBError) DB Error (AddNewRecords
recordmatch):#012Query was:#012UPDATE recordmatch INNER JOIN
sched_temp_record ON (recordmatch.recordid =
sched_temp_record.recordid) INNER JOIN program ON (recordmatch.chanid
= program.chanid AND recordmatch.starttime =
program.starttime AND recordmatch.manualid =
program.manualid) LEFT JOIN oldrecorded ON (
sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND
program.title = oldrecorded.title AND program.generic = 0
AND ( (program.programid <> '' AND program.programid
= oldrecorded.programid) OR ( (program.programid =
'' OR oldrecorded.programid = '') AND
(((sched_temp_record.dupmethod & 0x02) = 0) OR (program.subtitle <> ''
AND program.subtitle = oldrecorded.subtitle)) AND
(((sched_temp_record.dupmethod & 0x04) = 0) OR (program.description
<> '' AND program.description = oldrecorded.description))
AND (((sched_temp_record.dupmethod & 0x08) = 0) OR
(program.subtitle <> '' AND (program.subtitle =
oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND
program.subtitle = oldrecorded.description))) OR
(program.subtitle = '' AND program.description <> '' AND
(program.description = oldrecorded.subtitle OR
(oldrecorded.subtitle = '' AND program.description =
oldrecorded.description)))) ) ) ) LEFT JOIN
sched_temp_recorded recorded ON ( sched_temp_record.dupmethod >
1 AND recorded.duplicate <> 0 AND program.title =
recorded.title AND program.generic = 0 AND recorded.recgroup
NOT IN ('LiveTV','Deleted') AND ( (program.programid
<> '' AND program.programid = recorded.programid) OR
( (program.programid = '' OR recorded.progra
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:823 (prepare) Error preparing query: SELECT
record.title, record.subtitle, record.description,
record.season, record.episode, record.category,
record.chanid, channel.channum, record.station,
channel.name, record.recgroup, record.playgroup,
record.seriesid, record.programid, record.inetref,
record.recpriority, record.startdate, record.starttime,
record.enddate, record.endtime, record.recordid,
record.type, record.dupin, record.dupmethod,
record.findid,
record.startoffset, record.endoffset, channel.commmethod
FROM record INNER JOIN channel ON (channel.chanid
= record.chanid) LEFT JOIN recordmatch on record.recordid =
recordmatch.recordid WHERE (type = 1 OR type = 2 OR type = 5 OR type =
7) AND recordmatch.chanid IS NULL
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3:
Unable to prepare statement#012Database error was:#012Table
'./mythconverg/recordmatch' is marked as crashed and last (automatic?)
repair failed
Jul 7 15:32:23 gazerbeam mythbackend[1726]: E Scheduler
mythdb.cpp:192 (DBError) DB Error (AddNotListed):#012Query
was:#012SELECT record.title, record.subtitle,
record.description, record.season, record.episode,
record.category, record.chanid, channel.channum,
record.station, channel.name, record.recgroup,
record.playgroup, record.seriesid, record.programid,
record.inetref, record.recpriority, record.startdate,
record.starttime, record.enddate, record.endtime,
record.recordid, record.type, record.dupin,
record.dupmethod, record.findid,
record.startoffset, record.endoffset,
channel.commmethod FROM record INNER JOIN
channel ON (channel.chanid = record.chanid) LEFT JOIN recordmatch on
record.recordid = recordmatch.recordid WHERE (type = 1 OR type = 2 OR
type = 5 OR type = 7) AND recordmatch.chanid IS NULL#012Driver
error was [2/144]:#012QMYSQL: Unable to execute query#012Database
error was:#012Table './mythconverg/recordmatch' is marked as crashed
and last (automatic?) repair failed
Jul 7 15:32:23 gazerbeam mythbackend[1726]: I Scheduler
scheduler.cpp:2081 (HandleReschedule) Scheduled 0 items in 0.0 = 0.00
match + 0.01 place
Jul 7 15:32:23 gazerbeam mythbackend[1726]: I Scheduler
scheduler.cpp:2148 (HandleRunSchedulerStartup) Scheduler: Seem to be
woken up by USER
More information about the mythtv-users
mailing list