View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Fri May 04, 2007 7:23 am 
Offline
Joined: Sat Mar 17, 2007 2:01 am
Posts: 5
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] => &diams;
    [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
)





Top
 Profile  
 
PostPosted: Fri May 04, 2007 8:06 am 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
Kiwi_Chopper wrote:
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]
A quick Google yielded this: http://dinomite.net/archives/2006/11/


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 04, 2007 2:12 pm 
Offline
Joined: Sun Sep 25, 2005 3:50 pm
Posts: 1013
Location: Los Angeles
http://www.mysettopbox.tv/phpBB2/viewtopic.php?t=1043

That may help.

_________________
Mike
My Hardware Profile


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 21 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu