LinHES Forums
http://forum.linhes.org/

Anyone ever killed mythconverge?
http://forum.linhes.org/viewtopic.php?f=6&t=15118		 Page 1 of 1
Author:  Kiwi_Chopper [ Fri May 04, 2007 7:23 am ]
Post subject:  Anyone ever killed mythconverge?
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
)
Author:  slowtolearn [ Fri May 04, 2007 8:06 am ]
Post subject:  Re: Anyone ever killed mythconverge?
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/
Author:  mihanson [ Fri May 04, 2007 2:12 pm ]
Post subject: 
http://www.mysettopbox.tv/phpBB2/viewtopic.php?t=1043

That may help.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/