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?<br>
<br>
Gary<br>
<br>
<br>
<dl>
<hr><p><b>Fatal Error</b> at /var/www/html/mythweb/includes/programs.php, line 516:<br>SQL Error: Can't open file: 'credits.MYI' (errno: 145)</p><p>If you choose to <a href="https://svn.mythtv.org/trac/newticket" target="_blank">
submit a bug report</a>, please make sure to include a<br>brief description of what you were doing, along with the following<br>backtrace as an attachment (please don't paste the whole thing into<br>the ticket).
</p><hr><b>Details</b>:<br><pre>    datetime:  2006-06-23 10:20:09 (MDT)<br>    errornum:  256<br>  error type:  User Error<br>error string:  SQL Error: Can't open file: 'credits.MYI' (errno: 145)<br>    filename:  /var/www/html/mythweb/includes/programs.php
<br>  error line:  516<br><br>==========================================================================<br><br>Backtrace: <br><br>    file:  /var/www/html/mythweb/includes/programs.php<br>    line:  516<br>   class:  <br>
function:  trigger_error<br>    type:  <br>    args:  Array<br>(<br>    [0] =&gt; SQL Error: Can't open file: 'credits.MYI' (errno: 145)<br>    [1] =&gt; 256<br>)<br><br>    file:  /var/www/html/mythweb/themes/default/tv/detail.php
<br>    line:  136<br>   class:  Program<br>function:  get_credits<br>    type:  -&gt;<br>    args:  Array<br>(<br>    [0] =&gt; host<br>)<br><br>    file:  /var/www/html/mythweb/modules/tv/detail.php<br>    line:  215<br>
   class:  <br>function:  require_once<br>    type:  <br>    args:  Array<br>(<br>    [0] =&gt; /var/www/html/mythweb/themes/default/tv/detail.php<br>)<br><br>    file:  /var/www/html/mythweb/modules/tv/handler.php<br>    line:  40
<br>   class:  <br>function:  require_once<br>    type:  <br>    args:  Array<br>(<br>    [0] =&gt; /var/www/html/mythweb/modules/tv/detail.php<br>)<br><br>    file:  /var/www/html/mythweb/mythweb.php<br>    line:  24<br>
   class:  <br>function:  require_once<br>    type:  <br>    args:  Array<br>(<br>    [0] =&gt; /var/www/html/mythweb/modules/tv/handler.php<br>)<br><br><br>==========================================================================
<br><br>$_GET: Array<br>(<br>    [chanid] =&gt; 1004<br>    [starttime] =&gt; 1151631000<br>)<br><br>==========================================================================<br><br>$_SESSION: Array<br>(<br>    [language] =&gt; English
<br>    [Theme] =&gt; default<br>    [Skin] =&gt; default<br>    [date_statusbar] =&gt; %a %b %e, %Y, %I:%M %p<br>    [date_scheduled] =&gt; %a %b %e, %Y (%I:%M %p)<br>    [date_scheduled_popup] =&gt; %a %b %e, %Y<br>    [date_recorded] =&gt; %a %b %e, %Y&lt;br /&gt;(%I:%M %p)
<br>    [date_search] =&gt; %a %b %e, %Y, %I:%M %p<br>    [date_listing_key] =&gt; %a %b %e, %Y, %I:%M %p<br>    [date_listing_jump] =&gt; %a %b %e, %Y<br>    [date_channel_jump] =&gt; %a %b %e, %Y<br>    [time_format] =&gt; %I:%M %p
<br>    [scheduled_recordings] =&gt; Array<br>        (<br>            [disp_scheduled] =&gt; 1<br>            [disp_duplicates] =&gt; 1<br>            [disp_deactivated] =&gt; 1<br>            [disp_conflicts] =&gt; 1<br>
        )<br><br>    [scheduled_sortby] =&gt; Array<br>        (<br>            [0] =&gt; Array<br>                (<br>                    [field] =&gt; airdate<br>                    [reverse] =&gt; <br>                )
<br><br>            [1] =&gt; Array<br>                (<br>                    [field] =&gt; title<br>                    [reverse] =&gt; <br>                )<br><br>        )<br><br>    [list_time] =&gt; 1151078400<br>
    [schedules_sortby] =&gt; Array<br>        (<br>            [0] =&gt; Array<br>                (<br>                    [field] =&gt; airdate<br>                    [reverse] =&gt; <br>                )<br><br>            [1] =&gt; Array
<br>                (<br>                    [field] =&gt; title<br>                    [reverse] =&gt; <br>                )<br><br>        )<br><br>    [search] =&gt; Array<br>        (<br>            [searchstr] =&gt; office
<br>            [search_title] =&gt; 1<br>            [search_subtitle] =&gt; 1<br>            [search_description] =&gt; <br>            [search_category] =&gt; <br>            [search_category_type] =&gt; <br>        )<br>
<br>    [search_sortby] =&gt; Array<br>        (<br>            [0] =&gt; Array<br>                (<br>                    [field] =&gt; airdate<br>                    [reverse] =&gt; <br>                )<br><br>            [1] =&gt; Array
<br>                (<br>                    [field] =&gt; title<br>                    [reverse] =&gt; <br>                )<br><br>        )<br><br>)<br><br>==========================================================================
<br><br>$_SERVER: Array<br>(<br>    [REDIRECT_STATUS] =&gt; 200<br>    [HTTP_HOST] =&gt; <a href="http://67.161.219.140:24">67.161.219.140:24</a><br>    [HTTP_USER_AGENT] =&gt; Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:
1.7.10) Gecko/20050716 Firefox/1.0.6<br>    [HTTP_ACCEPT] =&gt; 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<br>    [HTTP_ACCEPT_LANGUAGE] =&gt; en-us,en;q=
0.5<br>    [HTTP_ACCEPT_ENCODING] =&gt; gzip,deflate<br>    [HTTP_ACCEPT_CHARSET] =&gt; ISO-8859-1,utf-8;q=0.7,*;q=0.7<br>    [HTTP_KEEP_ALIVE] =&gt; 300<br>    [HTTP_CONNECTION] =&gt; keep-alive<br>    [HTTP_REFERER] =&gt; 
<a href="http://67.161.219.140:24/tv/search">http://67.161.219.140:24/tv/search</a><br>    [HTTP_COOKIE] =&gt; cookies=true; mythweb_id=st56mv2gkg1f2u1ofq42fv27o5; mythweb_id=st56mv2gkg1f2u1ofq42fv27o5; cookies=true<br>    [PATH] =&gt; /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
<br>    [SERVER_SIGNATURE] =&gt; &lt;address&gt;Apache/2.0.52 (Fedora) Server at <a href="http://67.161.219.140">67.161.219.140</a> Port 80&lt;/address&gt;<br><br>    [SERVER_SOFTWARE] =&gt; Apache/2.0.52 (Fedora)<br>    [SERVER_NAME] =&gt; 
<a href="http://67.161.219.140">67.161.219.140</a><br>    [SERVER_ADDR] =&gt; <a href="http://192.168.25.106">192.168.25.106</a><br>    [SERVER_PORT] =&gt; 80<br>    [REMOTE_ADDR] =&gt; <a href="http://128.187.167.1">128.187.167.1
</a><br>    [DOCUMENT_ROOT] =&gt; /var/www/html/mythweb<br>    [SERVER_ADMIN] =&gt; root@localhost<br>    [SCRIPT_FILENAME] =&gt; /var/www/html/mythweb/mythweb.php<br>    [REMOTE_PORT] =&gt; 4817<br>    [REDIRECT_URL] =&gt; /tv/detail/1004/1151631000
<br>    [GATEWAY_INTERFACE] =&gt; CGI/1.1<br>    [SERVER_PROTOCOL] =&gt; HTTP/1.1<br>    [REQUEST_METHOD] =&gt; GET<br>    [QUERY_STRING] =&gt; <br>    [REQUEST_URI] =&gt; /tv/detail/1004/1151631000<br>    [SCRIPT_NAME] =&gt; /mythweb.php
<br>    [PATH_INFO] =&gt; /tv/detail/1004/1151631000<br>    [PATH_TRANSLATED] =&gt; /var/www/html/mythweb/tv/detail/1004/1151631000<br>    [PHP_SELF] =&gt; /mythweb.php/tv/detail/1004/1151631000<br>    [argv] =&gt; Array ( )
<br>    [argc] =&gt; 0<br>)<br><br><br></pre>
</dl>
<br>