Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#12338 closed Bug Report - Crash (Invalid)

mythweb error

Reported by: falk_nyc@… Owned by:
Priority: major Milestone: unknown
Component: MythTV - General Version: 0.27.4
Severity: high Keywords:
Cc: Ticket locked: no

Description

    datetime:  2014-12-26 12:16:31 (CET)
    errornum:  256
  error type:  User Error
error string:  !!NoTrans: SQL Error: Unknown column 'inputname' in 'field list' [#1054]!!
    filename:  /var/www/mythweb/classes/Database/Query/mysql.php
  error line:  79

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

Backtrace: 

    file:  /var/www/mythweb/classes/Database/Query/mysql.php
    line:  79
   class:  
function:  trigger_error
    type:  
    args:  Array
(
    [0] => SQL Error: Unknown column 'inputname' in 'field list' [#1054]
    [1] => 256
)

    file:  /var/www/mythweb/classes/Database.php
    line:  261
   class:  Database_Query_mysql
function:  execute
    type:  ->
    args:  Array
(
    [0] => Array
        (
            [0] => Array
                (
                    [0] => 
                )

        )

)

    file:  /var/www/mythweb/classes/Database.php
    line:  324
   class:  Database
function:  query
    type:  ->
    args:  Array
(
    [0] => SELECT inputname
                                                 FROM recorded
                                                WHERE recordedid=?
    [1] => Array
        (
            [0] => 
        )

)

    file:  /var/www/mythweb/modules/tv/classes/Program.php
    line:  223
   class:  Database
function:  query_col
    type:  ->
    args:  Array
(
    [0] => SELECT inputname
                                                 FROM recorded
                                                WHERE recordedid=?
    [1] => 
)

    file:  /var/www/mythweb/modules/tv/recorded.php
    line:  146
   class:  Program
function:  __construct
    type:  ->
    args:  Array
(
    [0] => Array
        (
            [0] => Kleiner Roter Traktor
            [1] => Vermisst / Auf und davon / Das Kartoffelrennen
            [2] => Vermisst  Jan stellt den kleinen roten Traktor ab, als er einen Zaun reparieren geht. Doch als er fertig ist, fehlt der kleine rote Traktor. Jan sucht alles ab, leiht sich dazu sogar von Stumpi dessen Flitzer aus, doch vergebens.  Währenddessen nutzen Max und Emma die Modellflugkünste von Thomas. Sie befestigen eine Kamera an dem Modellflugzeug, um so tolle Aufnahmen für ein Schulprojekt zu bekommen.  Als Jan bei den Kindern vorbeikommt, ist er ganz begeistert, und bittet sie, mit dem Flugzeug nach dem kleinen roten Traktor zu suchen. Ob Jan und die Kinder damit Erfolg haben werden?  Auf und davon  Herr Junker hat eine geniale Idee, wie er sich das Säen leichter machen kann. Er steigt einfach mit einem Heißluftballon hoch und wirft das Saatgut hinunter.  Der Wind wird es dann auf den Feldern verteilen. Das ist leichter gesagt, als getan. Denn Herr Junker trifft seine Felder nicht, sondern schüttet einen Sack Getreide versehentlich einmal auf Stumpi und einmal auf Walter.  Und natürlich verteilt der Wind das Saatgut auch nicht. Dramatisch wird Herrn Junkers Unternehmung allerdings erst, als er mit dem Ballon nicht mehr herunterkommt. Hätte er nur die Gebrauchsanweisung richtig gelesen!  Das Kartoffelrennen  Das alljährliche Plätscherbacher Kartoffelrennen steht vor der Tür, und alle sind schon ganz aufgeregt ...
            [3] => 0
            [4] => 0
            [5] => 
            [6] => Kids
            [7] => 12160
            [8] => 11160
            [9] => KiKA HD
            [10] => KiKA HD
            [11] => myth://srvTVHeadend/12160_20130326075000.mpg
            [12] => 3425589736
            [13] => 1364284200
            [14] => 1364286300
            [15] => 0
            [16] => srvTVHeadend
            [17] => 0
            [18] => 0
            [19] => 0
            [20] => 0
            [21] => -3
            [22] => 49
            [23] => 0
            [24] => 0
            [25] => 0
            [26] => 1364284200
            [27] => 1364286300
            [28] => 512
            [29] => Default
            [30] => 
            [31] => 
            [32] => 
            [33] => 
            [34] => 1364312106
            [35] => 0
            [36] => 
            [37] => Default
            [38] => 0
            [39] => 0
            [40] => Default
            [41] => 1
            [42] => 15
            [43] => 0
            [44] => 0
            [45] => 0
            [46] => 0
        )

)

    file:  /var/www/mythweb/modules/tv/handler.php
    line:  82
   class:  
function:  require_once
    type:  
    args:  Array
(
    [0] => /var/www/mythweb/modules/tv/recorded.php
)

    file:  /var/www/mythweb/mythweb.php
    line:  35
   class:  
function:  require_once
    type:  
    args:  Array
(
    [0] => /var/www/mythweb/modules/tv/handler.php
)


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

$_SESSION: Array
(
    [language] => German
    [date_statusbar] => %e.%m.%Y, %H:%M
    [date_scheduled] => %e.%m.%Y (%H:%M)
    [date_scheduled_popup] => %e.%m.%Y
    [date_recorded] => %e.%m.%Y (%H:%M)
    [date_search] => %e.%m.%Y, %H:%M
    [date_listing_key] => %e.%m.%Y, %H:%M
    [date_listing_jump] => %e.%m.%Y
    [date_channel_jump] => %e.%m.%Y
    [date_job_status] => %e.%m.%Y, %H:%M
    [time_format] => %H:%M
    [cache_engine] => Cache_Null
    [stream] => Array
        (
            [include_user_and_password] => 
        )

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

                        )

                )

            [last] => Array
                (
                    [0] => tv
                    [1] => channels
                )

            [host] => gax955
        )

    [backend] => Array
        (
            [192.168.11.20] => Array
                (
                    [proto_version] => Array
                        (
                            [last_check_version] => 77
                            [last_check_time] => 1419589077
                        )

                )

            [timezone] => Array
                (
                    [value] => Europe/Berlin
                    [last_check_time] => 1419523107
                )

        )

    [tv] => Array
        (
            [last] => Array
                (
                    [0] => recorded
                )

        )

    [list_time] => 1419592500
    [recording_details] => Array
        (
            [show_Conflict] => 1
            [show_PreviousRecording] => 1
            [show_EarlierShowing] => 1
            [show_CurrentRecording] => 1
            [show_WillRecord] => 1
        )

    [video_sortby] => Array
        (
            [0] => Array
                (
                    [field] => title
                    [reverse] => 
                )

        )

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

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

        )

    [scheduled_recordings] => Array
        (
            [disp_scheduled] => 1
            [disp_duplicates] => 
            [disp_deactivated] => 
            [disp_conflicts] => 1
        )

    [remote] => Array
        (
            [frontends] => Array ( )
            [type] => keys
        )

    [] => Array ( )
    [search] => Array
        (
            [s] => canned:HDTV, keine Serien
            [type] => q
            [ctype] => Array
                (
                    [0] => 
                    [1] => movie
                    [2] => sports
                    [3] => tvshow
                )

            [categories] => Array ( )
            [stars_gt] => 0
            [stars_lt] => 1
            [starttime] => now
            [endtime] => + 2 weeks
            [as] => Array
                (
                    [0] => 
                )

            [af] => Array
                (
                    [0] => Array
                        (
                            [0] => title
                        )

                )

            [aj] => Array
                (
                    [0] => AND
                )

        )

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

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

        )

    [recorded_sortby] => Array
        (
            [0] => Array
                (
                    [field] => airdate
                    [reverse] => 1
                )

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

        )

)

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

$_SERVER: Array
(
    [REDIRECT_STATUS] => 200
    [HTTP_HOST] => 192.168.11.20
    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.3; WOW64; rv:32.0) Gecko/20100101 Firefox/32.0
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_LANGUAGE] => de,en-US;q=0.7,en;q=0.3
    [HTTP_ACCEPT_ENCODING] => gzip, deflate
    [HTTP_REFERER] => http://192.168.11.20/mythweb/status
    [HTTP_COOKIE] => mythweb_id=9us0fhetttstm99bd9gjmmokv4
    [HTTP_CONNECTION] => keep-alive
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    [SERVER_SIGNATURE] => <address>Apache/2.4.10 (Ubuntu) Server at 192.168.11.20 Port 80</address>

    [SERVER_SOFTWARE] => Apache/2.4.10 (Ubuntu)
    [SERVER_NAME] => 192.168.11.20
    [SERVER_ADDR] => 192.168.11.20
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 10.0.0.54
    [DOCUMENT_ROOT] => /var/www/html
    [REQUEST_SCHEME] => http
    [CONTEXT_PREFIX] => 
    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
    [SERVER_ADMIN] => [no address given]
    [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php
    [REMOTE_PORT] => 55229
    [REDIRECT_URL] => /mythweb/tv/recorded
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /tv/recorded
    [SCRIPT_NAME] => /mythweb/mythweb.php
    [PATH_INFO] => /tv/recorded
    [PATH_TRANSLATED] => /var/www/html/tv/recorded
    [PHP_SELF] => /mythweb/mythweb.php/tv/recorded
    [REQUEST_TIME_FLOAT] => 1419592591.668
    [REQUEST_TIME] => 1419592591
    [STATUS] => 200
    [URL] => /mythweb/tv/recorded
    [HTTP_X_FORWARDED_PROTO] => 
    [HTTPS] => 
    [HTTP_PORT] => 80
)

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

$constant_list["user"]: Array
(
    [ERROR] => 512
    [E_ASSERT_ERROR] => 4096
    [FATAL] => 256
    [PHP_MIN_VERSION] => 5.3
    [WARNING] => 1024
    [WebDBSchemaVer] => 4
    [dupsin_all] => 15
    [dupsin_newepisodes] => 16
    [dupsin_oldrecorded] => 2
    [dupsin_recorded] => 1
    [error_email] => 
    [gb] => 1073741824
    [hostname] => srvTVHeadend
    [http_host] => 192.168.11.20
    [kb] => 1024
    [max_stars] => 4
    [mb] => 1048576
    [module] => tv
    [modules_path] => /var/www/mythweb/modules
    [num_time_slots] => 36
    [prefer_channum] => 1
    [rectype_always] => 4
    [rectype_daily] => 2
    [rectype_dontrec] => 8
    [rectype_findone] => 6
    [rectype_once] => 1
    [rectype_override] => 7
    [rectype_template] => 11
    [rectype_weekly] => 5
    [root] => /mythweb/
    [root_auth_url] => http://192.168.11.20/mythweb/
    [root_url] => http://192.168.11.20/mythweb/
    [searchtype_keyword] => 3
    [searchtype_manual] => 5
    [searchtype_people] => 4
    [searchtype_power] => 1
    [searchtype_title] => 2
    [skin] => default
    [skin_img_url] => http://192.168.11.20/mythweb/skins/default/img/
    [skin_url] => http://192.168.11.20/mythweb/skins/default/
    [star_character] => &#9733;
    [stream_url] => http://192.168.11.20:80//mythweb/
    [tb] => 1099511627776
    [timeslot_blocks] => 3
    [timeslot_size] => 300
    [timeslotbar_skip] => 20
    [tmpl] => default
    [tmpl_dir] => modules/tv/tmpl/default/
)

Change History (2)

comment:1 Changed 5 years ago by stuartm

Resolution: Invalid
Status: newclosed

You are running the 'master' development version of mythweb with a 0.27.4 backend, and not the 0.27.4 version of mythweb.

comment:2 Changed 5 years ago by falk_nyc@…

ok, why is the master which is pointed to the dev not named like it? Master and latest stable should match to version and dev is mostlikely dev..

Note: See TracTickets for help on using tickets.