Opened 9 years ago

Closed 8 years ago

#12952 closed Bug Report - General (Invalid)

Accessing listings from mythweb

Reported by: neil@… Owned by:
Priority: minor Milestone: 0.28
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords: mythweb
Cc: Ticket locked: no

Description

datetime: 2016-12-05 23:58:00 (GMT) errornum: 256

error type: User Error

error string: !NoTrans: SQL Error: Unknown column 'inputname' in 'field list' #1054!!

filename: /srv/www/htdocs/mythweb/classes/Database/Query/mysqlicompat.php

error line: 98

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

Backtrace:

file: /srv/www/htdocs/mythweb/classes/Database/Query/mysqlicompat.php line: 98

class:

function: trigger_error

type: args: Array

(

[0] => SQL Error: Unknown column 'inputname' in 'field list' #1054 [1] => 256

)

file: /srv/www/htdocs/mythweb/classes/Database.php line: 263

class: Database_Query_mysqlicompat

function: execute

type: -> args: Array

(

[0] => Array

(

[0] => Array

(

[0] =>

)

)

)

file: /srv/www/htdocs/mythweb/classes/Database.php line: 326

class: Database

function: query

type: -> args: Array

(

[0] => SELECT inputname

FROM recorded

WHERE recordedid=?

[1] => Array

(

[0] =>

)

)

file: /srv/www/htdocs/mythweb/modules/tv/classes/Program.php line: 229

class: Database

function: query_col

type: -> args: Array

(

[0] => SELECT inputname

FROM recorded

WHERE recordedid=?

[1] =>

)

file: /srv/www/htdocs/mythweb/modules/tv/classes/Schedule.php line: 150

class: Program

function: construct

type: -> args: Array

(

[0] => Array

(

[0] => 8 Out of 10 Cats [1] => [2] => Jimmy Carr hosts the topical comedy panel show, with new team captains Rob Beckett and Aisling Bea. Guests are Melanie C, Drifters' star Jessica Knappett, Joe Wilkinson and Tom Allen. (Ep4) [3] => 0 [4] => 0 [5] => [6] => Entertainment [7] => 1014 [8] => 14 [9] => More 4 [10] => More 4 [11] => [12] => 0 [13] => 1480979100 [14] => 1480982100 [15] => 0 [16] => cube [17] => 1 [18] => 0 [19] => 0 [20] => 0 [21] => 2 [22] => 489 [23] => 4 [24] => 15 [25] => 8 [26] => 1480979040 [27] => 1480982280 [28] => 0 [29] => Default [30] => [31] => www.channel4.com/m4ei0161114334052864 [32] => www.channel4.com/65081/004 [33] => [34] => 1480982221 [35] => 0 [36] => [37] => Default [38] => 0 [39] => 0 [40] => Default [41] => 1 [42] => 66 [43] => 0 [44] => 0 [45] => 0 [46] => 0

)

)

file: /srv/www/htdocs/mythweb/modules/tv/includes/programs.php line: 165

class: Schedule

function: findScheduled

type:
args: Array ( ) file: /srv/www/htdocs/mythweb/modules/tv/classes/Channel.php line: 154 class:

function: load_all_program_data

type: args: Array

(

[0] => 1480981500 [1] => 1480992300 [2] => 1001

)

file: /srv/www/htdocs/mythweb/modules/tv/tmpl/default/list_data.php line: 102

class: Channel

function: display_programs

type: -> args: Array

(

[0] => 1480981500 [1] => 1480992300

)

file: /srv/www/htdocs/mythweb/modules/tv/tmpl/default/list.php line: 78

class:

function: require_once

type: args: Array

(

[0] => /srv/www/htdocs/mythweb/modules/tv/tmpl/default/list_data.php

)

file: /srv/www/htdocs/mythweb/modules/tv/list.php line: 45

class:

function: require_once

type: args: Array

(

[0] => /srv/www/htdocs/mythweb/modules/tv/tmpl/default/list.php

)

file: /srv/www/htdocs/mythweb/modules/tv/handler.php line: 82

class:

function: require_once

type: args: Array

(

[0] => /srv/www/htdocs/mythweb/modules/tv/list.php

)

file: /srv/www/htdocs/mythweb/mythweb.php line: 35

class:

function: require_once

type: args: Array

(

[0] => /srv/www/htdocs/mythweb/modules/tv/handler.php

)

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

$_SESSION: Array (

[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

)

)

)

)

[backend] => Array

(

[172.16.0.198] => Array

(

[proto_version] => Array

(

[last_check_version] => 77 [last_check_time] => 1480982276

)

)

[timezone] => Array

(

[value] => Europe/London [last_check_time] => 1480982276

)

)

[language] => English [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 (%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 [date_job_status] => %a %b %e, %Y, %I:%M %p [time_format] => %I:%M %p [tv] => Array

(

[last] => Array

(

[0] => list

)

)

[list_time] => 1480981500

)

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

$_SERVER: Array (

[REDIRECT_STATUS] => 200 [HTTP_HOST] => 172.16.0.198 [HTTP_USER_AGENT] => Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5 [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_REFERER] => ​http://172.16.0.198/mythweb/ [HTTP_COOKIE] => mythweb_id=6a3ikavak9t1ek488aal2aaf0l3gjo0rksmoo6luouqvk93caic1 [HTTP_DNT] => 1 [HTTP_CONNECTION] => keep-alive [HTTP_UPGRADE_INSECURE_REQUESTS] => 1 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [SERVER_SIGNATURE] => <address>Apache/2.4.6 (Linux/SUSE) Server at 172.16.0.198 Port 80</address>

[SERVER_SOFTWARE] => Apache/2.4.6 (Linux/SUSE) [SERVER_NAME] => 172.16.0.198 [SERVER_ADDR] => 172.16.0.198 [SERVER_PORT] => 80 [REMOTE_ADDR] => 172.16.0.192 [DOCUMENT_ROOT] => /srv/www/htdocs [REQUEST_SCHEME] => http [CONTEXT_PREFIX] => [CONTEXT_DOCUMENT_ROOT] => /srv/www/htdocs [SERVER_ADMIN] => [no address given] [SCRIPT_FILENAME] => /srv/www/htdocs/mythweb/mythweb.php [REMOTE_PORT] => 34565 [REDIRECT_URL] => /mythweb/tv/list [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => [REQUEST_URI] => /tv/list [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /tv/list [PATH_TRANSLATED] => /srv/www/htdocs/tv/list [PHP_SELF] => /mythweb/mythweb.php/tv/list [REQUEST_TIME_FLOAT] => 1480982280.196 [REQUEST_TIME] => 1480982280 [STATUS] => 200 [URL] => /mythweb/tv/list [HTTP_X_FORWARDED_PROTO] => [HTTPS] => [HTTP_PORT] => 80

)

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

$constant_listuser: 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] => cube [http_host] => 172.16.0.198 [kb] => 1024 [max_stars] => 4 [mb] => 1048576 [module] => tv [modules_path] => /srv/www/htdocs/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://172.16.0.198/mythweb/ [root_url] => ​http://172.16.0.198/mythweb/ [searchtype_keyword] => 3 [searchtype_manual] => 5 [searchtype_people] => 4 [searchtype_power] => 1 [searchtype_title] => 2 [skin] => default [skin_img_url] => ​http://172.16.0.198/mythweb/skins/default/img/ [skin_url] => ​http://172.16.0.198/mythweb/skins/default/ [star_character] => &#9733; [stream_url] => ​http://172.16.0.198:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20 [tmpl] => default [tmpl_dir] => modules/tv/tmpl/default/

)

Change History (3)

comment:1 by Stuart Auchterlonie, 9 years ago

Component: MythTV - General → Plugin - MythWeb
Milestone: unknown → 0.28.1
Status: new → infoneeded_new
Version: Unspecified → 0.28.0

Have you recently upgraded mythtv to a newer version? Did you also upgrade mythweb to the latest version?

comment:2 by Stuart Auchterlonie, 9 years ago

Milestone: 0.28.1 → 0.28.2

Moving remaining open 0.28.1 tickets to 0.28.2

comment:3 by Jonatan Lindblad, 8 years ago

Milestone: 0.28.2 → 0.28
Resolution: → Invalid
Status: infoneeded_new → closed

Most definitely a problem with running a version of mythweb that contains 0fee55c71 and a version of mythtv that doesn't contain 213c622a1f.

Note: See TracTickets for help on using tickets.