OK,
So i had some HDD issues the other day and ran FSCK which promptly fixed them up and allowed me to start again, however now i have other issues.
I can watch tv my channel listings etc are still in tact however the system wojnt let me update the tv listings, or view them via mythweb.
Below is the error i'm getting and Webmin is throwing the same error when i try and connect to the DB.
Has the tables been trashed and how do i simply re-constitute them as i don't want to lose a lot of the movies etc that i have.
Any help would be appreciated.
Code:
--------------------------------------------------------------------------------
Fatal Error at /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php, line 73:
SQL Error: Table './mythconverg/program' is marked as crashed and should be repaired [#145]
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).
--------------------------------------------------------------------------------
Backtrace:
datetime: 2007-05-05 01:21:42 (NZST)
errornum: 256
error type: User Error
error string: SQL Error: Table './mythconverg/program' is marked as crashed and should be repaired [#145]
filename: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
error line: 73
==========================================================================
Backtrace:
file: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
line: 73
class:
function: trigger_error
type:
args: Array
(
[0] => SQL Error: Table './mythconverg/program' is marked as crashed and should be repaired [#145]
[1] => 256
)
file: /usr/share/mythtv/mythweb/includes/objects/Database.php
line: 220
class: database_query_mysql
function: execute
type: ->
args: Array
(
[0] => Array ( )
)
file: /usr/share/mythtv/mythweb/includes/programs.php
line: 155
class: database_mysql
function: query
type: ->
args: Array
(
[0] => SELECT program.*,
UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
IFNULL(programrating.system, "") AS rater,
IFNULL(programrating.rating, "") AS rating,
channel.callsign,
channel.channum
FROM program
LEFT JOIN programrating USING (chanid, starttime)
LEFT JOIN channel ON program.chanid = channel.chanid
WHERE program.chanid IN (1000,1001,1002,1003,1004,1006,1007,1005) AND (program.endtime > FROM_UNIXTIME('1178284500') AND program.starttime < FROM_UNIXTIME('1178295300') AND program.starttime != program.endtime)
GROUP BY program.chanid, program.starttime, channel.callsign ORDER BY program.starttime
)
file: /usr/share/mythtv/mythweb/modules/tv/list.php
line: 49
class:
function: load_all_program_data
type:
args: Array
(
[0] => 1178284500
[1] => 1178295300
)
file: /usr/share/mythtv/mythweb/modules/tv/handler.php
line: 62
class:
function: require_once
type:
args: Array
(
[0] => /usr/share/mythtv/mythweb/modules/tv/list.php
)
file: /usr/share/mythtv/mythweb/mythweb.php
line: 24
class:
function: require_once
type:
args: Array
(
[0] => /usr/share/mythtv/mythweb/modules/tv/handler.php
)
==========================================================================
$_SESSION: Array
(
[language] => English
[tmpl] => default
[skin] => default
[prefer_channum] => 1
[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
[recorded_pixmaps] => 1
[guide_favonly] =>
[timeslot_size] => 300
[num_time_slots] => 36
[timeslot_blocks] => 3
[timeslotbar_skip] => 20
[max_stars] => 4
[star_character] => ♦
[video_sortby] => Array
(
[0] => Array
(
[field] => title
[reverse] =>
)
)
[list_time] => 1178284500
[scheduled_recordings] => Array
(
[disp_scheduled] => 1
[disp_duplicates] => 1
[disp_deactivated] => 1
[disp_conflicts] => 1
)
[] => Array ( )
[siunits] => YES
[search] => Array
(
[s] => canned:New Titles, Premieres
[type] => a
[ctype] => Array
(
[0] =>
)
[stars_gt] => 0
[stars_lt] => 0
[starttime] => now
[endtime] => + 2 weeks
[as] => Array
(
[0] => wrestling
)
[af] => Array
(
[0] => Array
(
[0] => title
)
)
[aj] => Array
(
[0] => AND
)
[hd] =>
[commfree] =>
[airdate_start] =>
[airdate_end] =>
)
[search_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[recorded_title] =>
[recorded_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] => 1
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[schedules_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[scheduled_sortby] => Array
(
[0] => Array
(
[field] => airdate
[reverse] =>
)
[1] => Array
(
[field] => title
[reverse] =>
)
)
[recorded_recgroup] =>
[streamfiles] => Array
(
[0] => /myth/tv/1001_20070418193000.nuv
)
[recorded_descunder] =>
)
==========================================================================
$_SERVER: Array
(
[REDIRECT_STATUS] => 200
[HTTP_ACCEPT] => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
[HTTP_REFERER] => http://10.1.1.5/mythweb/mythweb.php
[HTTP_ACCEPT_LANGUAGE] => en-us
[HTTP_ACCEPT_ENCODING] => gzip, deflate
[HTTP_USER_AGENT] => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
[HTTP_HOST] => 10.1.1.5
[HTTP_CONNECTION] => Keep-Alive
[HTTP_COOKIE] => mythweb_id=5f63e73432606488b1f3c4cf2e8864e2
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] => <address>Apache/2.2.3 (Debian) PHP/4.4.4-8 Server at 10.1.1.5 Port 80</address>
[SERVER_SOFTWARE] => Apache/2.2.3 (Debian) PHP/4.4.4-8
[SERVER_NAME] => 10.1.1.5
[SERVER_ADDR] => 10.1.1.5
[SERVER_PORT] => 80
[REMOTE_ADDR] => 10.1.1.10
[DOCUMENT_ROOT] => /var/www
[SERVER_ADMIN] => webmaster@localhost
[SCRIPT_FILENAME] => /var/www/mythweb/mythweb.php
[REMOTE_PORT] => 3080
[REMOTE_USER] => mythtv
[AUTH_TYPE] => Digest
[REDIRECT_URL] => /mythweb/tv
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] =>
[REQUEST_URI] => /mythweb/tv
[SCRIPT_NAME] => /mythweb/mythweb.php
[PATH_INFO] => /tv
[PATH_TRANSLATED] => /var/www/tv
[PHP_SELF] => /mythweb/mythweb.php/tv
[argv] => Array ( )
[argc] => 0
[STATUS] => 200
[URL] => /mythweb/tv
)