Opened 3 years ago

Closed 3 years ago

#12983 closed Bug Report - General (Duplicate)

MythWeb error

Reported by: RichDSolution@… Owned by: Stuart Auchterlonie
Priority: major Milestone: 0.28.1
Component: Plugin - MythWeb Version: 0.28.0
Severity: high Keywords:
Cc: Ticket locked: no

Description

This is what the Mythweb guide showed over the web page. Rendering is ok over Kody(remote Windows10 cumputer) and MythFrontend install on the same system as my MythBackend?.

Look like a MySQL corrupt database.

MythBackend? running on a Ubuntu 16.04 clean fresh install.

Change History (2)

comment:1 Changed 3 years ago by RichDSolution@…

datetime: 2017-01-27 22:56:27 (EST) errornum: 256

error type: User Error

error string: !NoTrans: SQL Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.program.endtime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by #1055!!

filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php

error line: 98

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

Backtrace:

file: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php line: 98

class:

function: trigger_error

type: args: Array

(

[0] => SQL Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.program.endtime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by #1055 [1] => 256

)

file: /usr/share/mythtv/mythweb/classes/Database.php line: 261

class: Database_Query_mysqlicompat

function: execute

type: -> args: Array

(

[0] => Array ( )

)

file: /usr/share/mythtv/mythweb/modules/tv/includes/programs.php line: 140

class: Database

function: query

type: -> args: Array

(

[0] => SELECT program.*,

UNIX_TIMESTAMP(program.starttime) AS starttime_unix, UNIX_TIMESTAMP(program.endtime) AS endtime_unix, IFNULL(programrating.system, "") AS rater, IFNULL(programrating.rating, "") AS rating, channel.callsign, channel.channum

FROM program USE INDEX (id_start_end)

LEFT JOIN programrating USING (chanid, starttime) LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN credits ON (program.chanid = credits.chanid AND program.starttime = credits.starttime) LEFT JOIN people ON (credits.person = people.person)

WHERE program.chanid='1021' AND (program.endtime > FROM_UNIXTIME('1485575100') AND program.starttime < FROM_UNIXTIME('1485585900') AND program.starttime != program.endtime)

GROUP BY channel.callsign, program.chanid, program.starttime ORDER BY program.starttime )

file: /usr/share/mythtv/mythweb/modules/tv/classes/Channel.php line: 154

class:

function: load_all_program_data

type: args: Array

(

[0] => 1485575100 [1] => 1485585900 [2] => 1021

)

file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php line: 102

class: Channel

function: display_programs

type: -> args: Array

(

[0] => 1485575100 [1] => 1485585900

)

file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list.php line: 78

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php

)

file: /usr/share/mythtv/mythweb/modules/tv/list.php line: 45

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list.php

)

file: /usr/share/mythtv/mythweb/modules/tv/handler.php line: 82

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/tv/list.php

)

file: /usr/share/mythtv/mythweb/mythweb.php line: 35

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/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] => &#9733; [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

(

[192.168.2.30] => Array

(

[proto_version] => Array

(

[last_check_version] => 88 [last_check_time] => 1485575784

)

)

[timezone] => Array

(

[value] => America/Toronto? [last_check_time] => 1485575784

)

)

[language] => French [date_statusbar] => %e %b %Y, %H:%M [date_scheduled] => %e %b %Y (%H:%M) [date_scheduled_popup] => %e %b %Y [date_recorded] => %e %b %Y (%H:%M) [date_search] => %e %b %Y, %H:%M [date_listing_key] => %e %b %Y, %H:%M [date_listing_jump] => %e %b %Y [date_channel_jump] => %e %b %Y [date_job_status] => %e %b %Y, %H:%M [time_format] => %H:%M [tv] => Array

(

[last] => Array

(

[0] => list

)

)

[list_time] => 1485575100

)

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

$_SERVER: Array (

[REDIRECT_STATUS] => 200 [HTTP_ACCEPT] => text/html, application/xhtml+xml, image/jxr, */* [HTTP_REFERER] => http://192.168.2.30/mythweb/ [HTTP_ACCEPT_LANGUAGE] => fr-CA,fr;q=0.5 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit?/537.36 (KHTML, like Gecko) Chrome/51.0.2704.79 Safari/537.36 Edge/14.14393 [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_HOST] => 192.168.2.30 [HTTP_CONNECTION] => Keep-Alive [HTTP_COOKIE] => mythweb_id=7qsr313mu2khjhui49t01hnno3 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at 192.168.2.30 Port 80</address>

[SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu) [SERVER_NAME] => 192.168.2.30 [SERVER_ADDR] => 192.168.2.30 [SERVER_PORT] => 80 [REMOTE_ADDR] => 192.168.2.13 [DOCUMENT_ROOT] => /var/www/html [REQUEST_SCHEME] => http [CONTEXT_PREFIX] => [CONTEXT_DOCUMENT_ROOT] => /var/www/html [SERVER_ADMIN] => webmaster@localhost [SCRIPT_FILENAME] => /var/www/html/mythweb/mythweb.php [REMOTE_PORT] => 64027 [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] => /var/www/html/tv/list [PHP_SELF] => /mythweb/mythweb.php/tv/list [REQUEST_TIME_FLOAT] => 1485575787,35 [REQUEST_TIME] => 1485575787 [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] => RVP-Myth [http_host] => 192.168.2.30 [kb] => 1024 [max_stars] => 4 [mb] => 1048576 [module] => tv [modules_path] => /usr/share/mythtv/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.2.30/mythweb/ [root_url] => http://192.168.2.30/mythweb/ [searchtype_keyword] => 3 [searchtype_manual] => 5 [searchtype_people] => 4 [searchtype_power] => 1 [searchtype_title] => 2 [skin] => default [skin_img_url] => http://192.168.2.30/mythweb/skins/default/img/ [skin_url] => http://192.168.2.30/mythweb/skins/default/ [star_character] => &#9733; [stream_url] => http://192.168.2.30:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20 [tmpl] => default [tmpl_dir] => modules/tv/tmpl/default/

)

comment:2 Changed 3 years ago by Peter Bennett

Resolution: Duplicate
Status: newclosed

Dup of #12811 . Update to current 0.28-fixes to get a version that supports the version of MySQL/MariaDB you're using.

Note: See TracTickets for help on using tickets.