[mythtv-users] errors with mythconverg, mythweb and scheduling recordings
Gabe Rubin
gaberubin at gmail.com
Sat Sep 9 01:40:22 UTC 2006
When I try to go into mythweb and look at my upcoming recordings, it
says there are none. Worse, when I try to search for a show or
listings, I get a major mysql error. There is plenty of space on my
partitions, and I can watch my recorded shows (so the db is somewhat
working). Any ideas?
Here is what is displayed in mythweb:
Fatal Error at /var/www/html/mythweb/includes/db.php, line 360:
SQL Error: Can't open file: 'program.MYI' (errno: 145) [#1016]
If you choose to submit a bug report, please make sure to include a
brief description of what you were doing, along with the following
backtrace as an attachment (please don't paste the whole thing into
the ticket).
Details:
datetime: 2006-09-08 18:18:52 (PDT)
errornum: 256
error type: User Error
error string: SQL Error: Can't open file: 'program.MYI' (errno: 145) [#1016]
filename: /var/www/html/mythweb/includes/db.php
error line: 360
==========================================================================
Backtrace:
file: /var/www/html/mythweb/includes/db.php
line: 360
class:
function: trigger_error
type:
args: Array
(
[0] => SQL Error: Can't open file: 'program.MYI' (errno: 145) [#1016]
[1] => 256
)
file: /var/www/html/mythweb/includes/db.php
line: 133
class: Database_Query_mysql
function: execute
type: ->
args: Array
(
[0] => Array
(
[0] => ♦
[1] => 4
[2] => 4
)
)
file: /var/www/html/mythweb/includes/programs.php
line: 170
class: Database
function: query
type: ->
args: Array
(
[0] => SELECT program.*,
UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
CONCAT(repeat(?, program.stars * ?),
IF((program.stars * ? * 10) % 10,
"½", "")) AS starstring,
IFNULL(programrating.system, "") AS rater,
IFNULL(programrating.rating, "") AS rating,
oldrecorded.recstatus,
channel.channum
FROM program
LEFT JOIN programrating USING (chanid, starttime)
LEFT JOIN oldrecorded
ON oldrecorded.recstatus IN (-3, 11)
AND IF(oldrecorded.programid AND
oldrecorded.seriesid,
oldrecorded.programid =
program.programid
AND oldrecorded.seriesid
= program.seriesid,
oldrecorded.title AND
oldrecorded.subtitle
AND oldrecorded.description
AND oldrecorded.title
= program.title
AND oldrecorded.subtitle
= program.subtitle
AND
oldrecorded.description = program.description
)
LEFT JOIN channel ON program.chanid = channel.chanid
WHERE program.chanid IN
(1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1077,1078,1079,1080,1081,1107,2107,1119,1120,1121,1122,1126,1128,1134,1135,1136,1138,1146,1149,1161,1162,1164,1180,1182,1183,1186,1189,1190,1191,1192,1194,1195,1199,1201,1204,1215,1216,1220,1222,1228,1229,1230,1231,1241,1242,1243,1244,1245,1246,1247,1248,1251,1252,1254,1255,1256,1257,1258,1259,1260,1261,1262,1271,1272,1273,1274,1275,1276,1400,1401,1402,1406,1407,1408,1409,1410,1413,1414,1415,1417,1418,1472,1474,1476,1481,1482,1484,1486,1501,1502,1503,1504,1505,1506,1513,1514,1516,1534,1550,1551,1553,1555,1556,1557,1559,1560,1583,1586,1591,1593,1600,1601,1602,1603,1604,1605,1606,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,2702,2703,2704,2705,2707,2709,2719,2720,2722,2723,2724,2725,2730,2814,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1947,1948,1949,1950,1951,1952,1953,1954)
AND (program.endtime > FROM_UNIXTIME('1157764500') AND
program.starttime < FROM_UNIXTIME('1157775300') AND program.starttime
!= program.endtime) GROUP BY program.chanid, program.starttime ORDER
BY program.starttime
[1] => ♦
[2] => 4
[3] => 4
)
file: /var/www/html/mythweb/modules/tv/list.php
line: 49
class:
function: load_all_program_data
type:
args: Array
(
[0] => 1157764500
[1] => 1157775300
)
file: /var/www/html/mythweb/modules/tv/handler.php
line: 40
class:
function: require_once
type:
args: Array
(
[0] => /var/www/html/mythweb/modules/tv/list.php
)
file: /var/www/html/mythweb/mythweb.php
line: 24
class:
function: require_once
type:
args: Array
(
[0] => /var/www/html/mythweb/modules/tv/handler.php
)
==========================================================================
$_SESSION: Array
(
[language] => English
[Theme] => default
[Skin] => default
[date_statusbar] => %a %b %e, %Y, %I:%M %p
[date_scheduled] => %a %b %e, %Y (%I:%M %p)
[date_scheduled_popup] => %a %b %e, %Y
[date_recorded] => %a %b %e, %Y<br />(%I:%M %p)
[date_search] => %a %b %e, %Y, %I:%M %p
[date_listing_key] => %a %b %e, %Y, %I:%M %p
[date_listing_jump] => %a %b %e, %Y
[date_channel_jump] => %a %b %e, %Y
[time_format] => %I:%M %p
[list_time] => 1157764500
[recorded_title] =>
[recorded_recgroup] =>
[recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] => 1
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[search_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[scheduled_recordings] => Array
(
[disp_scheduled] => 1
[disp_duplicates] => 1
[disp_deactivated] => 1
[disp_conflicts] => 1
)
[scheduled_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[search] => Array
(
[searchstr] => pardon
[search_title] => 1
[search_subtitle] => 1
[search_description] =>
[search_category] =>
[search_category_type] =>
)
[video_sortby] => Array
(
[0] => Array
(
[field] => title
[reverse] =>
)
)
)
==========================================================================
$_SERVER: Array
(
[REDIRECT_STATUS] => 200
[HTTP_HOST] => 192.168.1.100:8080
[HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6
[HTTP_ACCEPT] =>
text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
[HTTP_ACCEPT_ENCODING] => gzip,deflate
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
[HTTP_KEEP_ALIVE] => 300
[HTTP_CONNECTION] => keep-alive
[HTTP_REFERER] => http://192.168.1.100:8080/mythweb/video
[HTTP_COOKIE] => mythweb_id=c3kgbnfpn3rekglfh8tjkf2975
[PATH] => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
[SERVER_SIGNATURE] => <address>Apache/2.0.54 (Fedora) Server at
192.168.1.100 Port 80</address>
[SERVER_SOFTWARE] => Apache/2.0.54 (Fedora)
[SERVER_NAME] => 192.168.1.100
[SERVER_ADDR] => 192.168.1.100
[SERVER_PORT] => 80
[REMOTE_ADDR] => 192.168.1.101
[DOCUMENT_ROOT] => /var/www/html
[SERVER_ADMIN] => root at localhost
[SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
[REMOTE_PORT] => 2747
[REMOTE_USER] => gabe
[AUTH_TYPE] => Digest
[REDIRECT_URL] => /mythweb/tv/list
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] =>
[REQUEST_URI] => /mythweb/tv/list
[SCRIPT_NAME] => /mythweb/mythweb.php
[PATH_INFO] => /tv/list
[PATH_TRANSLATED] => /var/www/html/tv/list
[PHP_SELF] => /mythweb/mythweb.php/tv/list
[argv] => Array ( )
[argc] => 0
[STATUS] => 200
[URL] => /mythweb/tv/list
)
More information about the mythtv-users
mailing list