Ticket #12382: mythwebError.html

<div id="message">

<h2>Fatal Error</h2>

<p class="err">
    !!NoTrans: SQL Error: Can't find file: 'oldrecorded' (errno: 2) [#1017]!!</p>

<div id="backtrace">

    <p>
        If you choose to <b><u><a href="http://svn.mythtv.org/trac/newticket" target="_blank"> submit a bug report </a></u></b>
        please make sure to include a brief description of what you were doing,
        along with the following backtrace as an attachment <i>(please don\'t just paste the whole thing into the ticket)</i>
    </p>

    <textarea cols=100 rows=100>    datetime:  2015-02-17 14:36:15 (EST)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: SQL Error: Can't find file: 'oldrecorded' (errno: 2) [#1017]!!
    filename:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
  error line:  79

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

Backtrace: 

    file:  /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
    line:  79
   class:  
function:  trigger_error
    type:  
    args:  Array
(
    [0] =&gt; SQL Error: Can't find file: 'oldrecorded' (errno: 2) [#1017]
    [1] =&gt; 256
)

    file:  /usr/share/mythtv/mythweb/classes/Database.php
    line:  261
   class:  Database_Query_mysql
function:  execute
    type:  -&gt;
    args:  Array
(
    [0] =&gt; Array
        (
            [0] =&gt; Array ( )
        )

)

    file:  /usr/share/mythtv/mythweb/classes/Database.php
    line:  324
   class:  Database
function:  query
    type:  -&gt;
    args:  Array
(
    [0] =&gt; SELECT COUNT(*) FROM oldrecorded WHERE future = 0
    [1] =&gt; Array ( )
)

    file:  /usr/share/mythtv/mythweb/modules/stats/init.php
    line:  12
   class:  Database
function:  query_col
    type:  -&gt;
    args:  Array
(
    [0] =&gt; SELECT COUNT(*) FROM oldrecorded WHERE future = 0
)

    file:  /usr/share/mythtv/mythweb/classes/Modules.php
    line:  30
   class:  
function:  require_once
    type:  
    args:  Array
(
    [0] =&gt; /usr/share/mythtv/mythweb/modules/stats/init.php
)

    file:  /usr/share/mythtv/mythweb/classes/Modules.php
    line:  50
   class:  Modules
function:  load
    type:  ::
    args:  Array ( )
    file:  /usr/share/mythtv/mythweb/mythweb.php
    line:  30
   class:  Modules
function:  getModule
    type:  ::
    args:  Array
(
    [0] =&gt; 
)


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

$_SESSION: Array
(
    [cache_engine] =&gt; Cache_Null
    [stream] =&gt; Array
        (
            [include_user_and_password] =&gt; 
        )

    [prefer_channum] =&gt; 1
    [recorded_pixmaps] =&gt; 1
    [guide_favonly] =&gt; 
    [timeslot_size] =&gt; 300
    [num_time_slots] =&gt; 36
    [timeslot_blocks] =&gt; 3
    [timeslotbar_skip] =&gt; 20
    [max_stars] =&gt; 4
    [star_character] =&gt; &amp;#9733;
    [show_popup_info] =&gt; 1
    [show_channel_icons] =&gt; 1
    [sortby_channum] =&gt; 1
    [recorded_paging] =&gt; 
    [genre_colors] =&gt; 1
    [show_video_covers] =&gt; 1
    [settings] =&gt; Array
        (
            [screens] =&gt; Array
                (
                    [tv] =&gt; Array
                        (
                            [upcoming recordings] =&gt; Array
                                (
                                    [title] =&gt; on
                                    [channel] =&gt; on
                                    [record date] =&gt; on
                                    [length] =&gt; on
                                )

                        )

                )

        )

    [backend] =&gt; Array
        (
            [127.0.0.1] =&gt; Array
                (
                    [proto_version] =&gt; Array
                        (
                            [last_check_version] =&gt; 77
                            [last_check_time] =&gt; 1424141364
                        )

                )

            [timezone] =&gt; Array
                (
                    [value] =&gt; Australia/Melbourne
                    [last_check_time] =&gt; 1424141364
                )

        )

    [language] =&gt; English
    [date_statusbar] =&gt; %a %b %e, %Y, %I:%M %p
    [date_scheduled] =&gt; %a %b %e, %Y (%I:%M %p)
    [date_scheduled_popup] =&gt; %a %b %e, %Y
    [date_recorded] =&gt; %a %b %e, %Y (%I:%M %p)
    [date_search] =&gt; %a %b %e, %Y, %I:%M %p
    [date_listing_key] =&gt; %a %b %e, %Y, %I:%M %p
    [date_listing_jump] =&gt; %a %b %e, %Y
    [date_channel_jump] =&gt; %a %b %e, %Y
    [date_job_status] =&gt; %a %b %e, %Y, %I:%M %p
    [time_format] =&gt; %I:%M %p
    [tv] =&gt; Array
        (
            [last] =&gt; Array
                (
                    [0] =&gt; list
                )

            [show_advanced_schedule] =&gt; 1
        )

    [schedules_sortby] =&gt; Array
        (
            [0] =&gt; Array
                (
                    [field] =&gt; airdate
                    [reverse] =&gt; 
                )

            [1] =&gt; Array
                (
                    [field] =&gt; title
                    [reverse] =&gt; 
                )

        )

    [scheduled_recordings] =&gt; Array
        (
            [disp_scheduled] =&gt; 1
            [disp_duplicates] =&gt; 
            [disp_deactivated] =&gt; 
            [disp_conflicts] =&gt; 1
        )

    [scheduled_sortby] =&gt; Array
        (
            [0] =&gt; Array
                (
                    [field] =&gt; airdate
                    [reverse] =&gt; 
                )

            [1] =&gt; Array
                (
                    [field] =&gt; title
                    [reverse] =&gt; 
                )

        )

    [list_time] =&gt; 1414386900
    [recording_details] =&gt; Array
        (
            [show_Conflict] =&gt; 1
            [show_PreviousRecording] =&gt; 1
            [show_EarlierShowing] =&gt; 1
            [show_CurrentRecording] =&gt; 1
            [show_WillRecord] =&gt; 1
        )

    [search] =&gt; Array
        (
            [s] =&gt; canned:New Titles, Premieres
            [type] =&gt; a
            [ctype] =&gt; Array
                (
                    [0] =&gt; series
                )

            [categories] =&gt; Array
                (
                    [0] =&gt; All
                )

            [stars_gt] =&gt; 0
            [stars_lt] =&gt; 1
            [starttime] =&gt; now
            [endtime] =&gt; + 2 weeks
            [as] =&gt; Array
                (
                    [0] =&gt; ameri
                )

            [af] =&gt; Array
                (
                    [0] =&gt; Array
                        (
                            [0] =&gt; title
                        )

                )

            [aj] =&gt; Array
                (
                    [0] =&gt; AND
                )

            [hd] =&gt; 
            [commfree] =&gt; 
            [unwatched] =&gt; 
            [scheduled] =&gt; 
            [generic] =&gt; 
            [distinctTitle] =&gt; 
            [airdate_start] =&gt; 
            [airdate_end] =&gt; 
        )

    [search_sortby] =&gt; Array
        (
            [0] =&gt; Array
                (
                    [field] =&gt; airdate
                    [reverse] =&gt; 
                )

            [1] =&gt; Array
                (
                    [field] =&gt; title
                    [reverse] =&gt; 
                )

        )

    [recorded_sortby] =&gt; Array
        (
            [0] =&gt; Array
                (
                    [field] =&gt; airdate
                    [reverse] =&gt; 1
                )

            [1] =&gt; Array
                (
                    [field] =&gt; title
                    [reverse] =&gt; 
                )

        )

    [video_sortby] =&gt; Array
        (
            [0] =&gt; Array
                (
                    [field] =&gt; title
                    [reverse] =&gt; 
                )

        )

    [] =&gt; Array ( )
)

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

$_SERVER: Array
(
    [REDIRECT_STATUS] =&gt; 200
    [HTTP_HOST] =&gt; 192.168.0.10
    [HTTP_CONNECTION] =&gt; keep-alive
    [HTTP_USER_AGENT] =&gt; Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.111 Safari/537.36
    [HTTP_ACCEPT_ENCODING] =&gt; gzip, deflate, sdch
    [HTTP_ACCEPT_LANGUAGE] =&gt; en-US,en;q=0.8
    [HTTP_COOKIE] =&gt; plushQueuePerPage=9999999; mythweb_id=vcdurs1gonetnoqdferlksd185; plushHistPerPage=20; snatched_view2=list; soon_view2=thumbs; late_view2=list; wanted_view2=details; manage_view2=details; advanced_toggle_checked=1; suggestions_charts_menu_selected=charts; plushContainerWidth=100%25; plushMultiOps=1; plushNoTopMenu=0; filter=active
    [PATH] =&gt; /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    [SERVER_SIGNATURE] =&gt; &lt;address&gt;Apache/2.4.7 (Ubuntu) Server at 192.168.0.10 Port 80&lt;/address&gt;

    [SERVER_SOFTWARE] =&gt; Apache/2.4.7 (Ubuntu)
    [SERVER_NAME] =&gt; 192.168.0.10
    [SERVER_ADDR] =&gt; 192.168.0.10
    [SERVER_PORT] =&gt; 80
    [REMOTE_ADDR] =&gt; 192.168.0.112
    [DOCUMENT_ROOT] =&gt; /var/www/html
    [REQUEST_SCHEME] =&gt; http
    [CONTEXT_PREFIX] =&gt; 
    [CONTEXT_DOCUMENT_ROOT] =&gt; /var/www/html
    [SERVER_ADMIN] =&gt; webmaster@localhost
    [SCRIPT_FILENAME] =&gt; /var/www/html/mythweb/mythweb.php
    [REMOTE_PORT] =&gt; 52654
    [REDIRECT_URL] =&gt; /mythweb/
    [GATEWAY_INTERFACE] =&gt; CGI/1.1
    [SERVER_PROTOCOL] =&gt; HTTP/1.1
    [REQUEST_METHOD] =&gt; GET
    [QUERY_STRING] =&gt; 
    [REQUEST_URI] =&gt; /
    [SCRIPT_NAME] =&gt; /mythweb/mythweb.php
    [PHP_SELF] =&gt; /mythweb/mythweb.php
    [REQUEST_TIME_FLOAT] =&gt; 1424144175.892
    [REQUEST_TIME] =&gt; 1424144175
    [STATUS] =&gt; 200
    [URL] =&gt; /mythweb/
    [HTTP_PORT] =&gt; 80
)

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

$constant_list[&quot;user&quot;]: Array
(
    [ERROR] =&gt; 512
    [E_ASSERT_ERROR] =&gt; 4096
    [FATAL] =&gt; 256
    [PHP_MIN_VERSION] =&gt; 5.3
    [WARNING] =&gt; 1024
    [WebDBSchemaVer] =&gt; 4
    [error_email] =&gt; 
    [gb] =&gt; 1073741824
    [hostname] =&gt; nerdvision
    [http_host] =&gt; 192.168.0.10
    [kb] =&gt; 1024
    [max_stars] =&gt; 4
    [mb] =&gt; 1048576
    [module] =&gt; 
    [modules_path] =&gt; /usr/share/mythtv/mythweb/modules
    [num_time_slots] =&gt; 36
    [prefer_channum] =&gt; 1
    [root] =&gt; /mythweb/
    [root_auth_url] =&gt; http://192.168.0.10/mythweb/
    [root_url] =&gt; http://192.168.0.10/mythweb/
    [skin] =&gt; default
    [skin_img_url] =&gt; http://192.168.0.10/mythweb/skins/default/img/
    [skin_url] =&gt; http://192.168.0.10/mythweb/skins/default/
    [star_character] =&gt; &amp;#9733;
    [stream_url] =&gt; http://192.168.0.10:80//mythweb/
    [tb] =&gt; 1099511627776
    [timeslot_blocks] =&gt; 3
    [timeslot_size] =&gt; 300
    [timeslotbar_skip] =&gt; 20
    [tmpl] =&gt; default
    [tmpl_dir] =&gt; modules//tmpl/default/
)


</textarea>

</div>


</div>


<div id="ajax_working" class="hidden">
 <span id="ajax_num_requests">0</span> requests pending.</div>

</body>
</html>