[mythtv-users] Problems scheduling with MythWeb

Gary Jones garysj at gmail.com
Fri Jun 23 16:22:38 UTC 2006


This is one of those "I didn't do anything" problems. I am running .19 quite
smoothly, for the most part, but of late I have been unable to schedule
recordings using the MythWeb interface. I can use it to see the backend
status, cancel upcoming recordings, view recorded programs, and even burn
DVDs. However, when I search for a program and click on the link to set up
the recording options, I get the following (long) error. Scheduling works
fine from the front end, so no problems while I'm at home but if I want to
set things up remotely I can't. Any ideas?

Gary


 ------------------------------

*Fatal Error* at /var/www/html/mythweb/includes/programs.php, line 516:
SQL Error: Can't open file: 'credits.MYI' (errno: 145)

If you choose to submit a bug report <https://svn.mythtv.org/trac/newticket>,
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-06-23 10:20:09 (MDT)
    errornum:  256
  error type:  User Error
error string:  SQL Error: Can't open file: 'credits.MYI' (errno: 145)
    filename:  /var/www/html/mythweb/includes/programs.php
  error line:  516

=====================================

Backtrace:

    file:  /var/www/html/mythweb/includes/programs.php
    line:  516
   class:
function:  trigger_error
    type:
    args:  Array
(
    [0] => SQL Error: Can't open file: 'credits.MYI' (errno: 145)
    [1] => 256
)

    file:  /var/www/html/mythweb/themes/default/tv/detail.php
    line:  136
   class:  Program
function:  get_credits
    type:  ->
    args:  Array
(
    [0] => host
)

    file:  /var/www/html/mythweb/modules/tv/detail.php
    line:  215
   class:
function:  require_once
    type:
    args:  Array
(
    [0] => /var/www/html/mythweb/themes/default/tv/detail.php
)

    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/detail.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
)


=====================================

$_GET: Array
(
    [chanid] => 1004
    [starttime] => 1151631000
)

=====================================

$_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
    [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] =>
                )

        )

    [list_time] => 1151078400
    [schedules_sortby] => Array
        (
            [0] => Array
                (
                    [field] => airdate
                    [reverse] =>
                )

            [1] => Array
                (
                    [field] => title
                    [reverse] =>
                )

        )

    [search] => Array
        (
            [searchstr] => office
            [search_title] => 1
            [search_subtitle] => 1
            [search_description] =>
            [search_category] =>
            [search_category_type] =>
        )

    [search_sortby] => Array
        (
            [0] => Array
                (
                    [field] => airdate
                    [reverse] =>
                )

            [1] => Array
                (
                    [field] => title
                    [reverse] =>
                )

        )

)

=====================================

$_SERVER: Array
(
    [REDIRECT_STATUS] => 200
    [HTTP_HOST] => 67.161.219.140:24
    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1;
en-US; rv:1.7.10) Gecko/20050716 Firefox/1.0.6
    [HTTP_ACCEPT] =>
application/x-shockwave-flash,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://67.161.219.140:24/tv/search
    [HTTP_COOKIE] => cookies=true;
mythweb_id=st56mv2gkg1f2u1ofq42fv27o5;
mythweb_id=st56mv2gkg1f2u1ofq42fv27o5; cookies=true
    [PATH] => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
    [SERVER_SIGNATURE] => <address>Apache/2.0.52 (Fedora) Server at
67.161.219.140 Port 80</address>

    [SERVER_SOFTWARE] => Apache/2.0.52 (Fedora)
    [SERVER_NAME] => 67.161.219.140
    [SERVER_ADDR] => 192.168.25.106
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 128.187.167.1
    [DOCUMENT_ROOT] => /var/www/html/mythweb
    [SERVER_ADMIN] => root at localhost
    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
    [REMOTE_PORT] => 4817
    [REDIRECT_URL] => /tv/detail/1004/1151631000
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] =>
    [REQUEST_URI] => /tv/detail/1004/1151631000
    [SCRIPT_NAME] => /mythweb.php
    [PATH_INFO] => /tv/detail/1004/1151631000
    [PATH_TRANSLATED] => /var/www/html/mythweb/tv/detail/1004/1151631000
    [PHP_SELF] => /mythweb.php/tv/detail/1004/1151631000
    [argv] => Array ( )
    [argc] => 0
)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060623/cb455b38/attachment.htm 


More information about the mythtv-users mailing list