Opened 3 years ago

Closed 3 years ago

#12869 closed Bug Report - General (Duplicate)

MythTV Statistics Page Error

Reported by: drmchsr87@… Owned by: Stuart Auchterlonie
Priority: minor Milestone: 0.28.1
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords:
Cc: Ticket locked: no

Description

I used the web interface to check the statistics page and received an error. Server is running Ubuntu 16.04.1 and mysql 5.7 after recent upgrade. MythTV is at 0.28 with the last updates done on 09/01/2016. Error message returned is:

datetime: 2016-09-03 20:46:59 (CDT) errornum: 256

error type: User Error

error string: !NoTrans: SQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.channel.name' 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 #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.channel.name' 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/stats/handler.php line: 85

class: Database

function: query

type: -> args: Array

(

[0] => SELECT COUNT(oldrecorded.chanid) as recorded,

channel.name, channel.channum, MAX(UNIX_TIMESTAMP(oldrecorded.starttime)) AS last_recorded

FROM oldrecorded

LEFT JOIN channel

ON channel.chanid = oldrecorded.chanid

WHERE 1 AND oldrecorded.recstatus = -3 AND oldrecorded.future = 0

AND channel.channum IS NOT NULL

GROUP BY channel.callsign ORDER BY recorded DESC, last_recorded, name LIMIT 10

)

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

class:

function: require_once

type: args: Array

(

[0] => /usr/share/mythtv/mythweb/modules/stats/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

)

)

)

[last] => Array

(

[0] => database [1] => settings

)

[host] => dentv01

)

[backend] => Array

(

[10.0.0.221] => Array

(

[proto_version] => Array

(

[last_check_version] => 88 [last_check_time] => 1472953444

)

)

[timezone] => Array

(

[value] => America/Chicago? [last_check_time] => 1472953444

)

)

[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] => upcoming

)

[show_advanced_schedule] => 1

)

[list_time] => 1472855400 [scheduled_recordings] => Array

(

[disp_scheduled] => 1 [disp_duplicates] => [disp_deactivated] => [disp_conflicts] => 1

)

[schedules_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[video_sortby] => Array

(

[0] => Array

(

[field] => title [reverse] =>

)

)

[recorded_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] => 1

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[search] => Array

(

[type] => a [s] => Building Star Trek [ctype] => Array

(

[0] => movie [1] => series [2] => sports [3] => tvshow

)

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

(

[0] => Building Star Trek

)

[af] => Array

(

[0] => Array

(

[0] => title

)

)

[aj] => Array

(

[0] => AND

)

[hd] => [commfree] => [unwatched] => [scheduled] => [generic] => [distinctTitle] => [airdate_start] => [airdate_end] =>

)

[search_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[scheduled_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[recording_details] => Array

(

[show_Conflict] => 1 [show_PreviousRecording] => 1 [show_EarlierShowing] => 1 [show_CurrentRecording] => 1 [show_WillRecord] => 1

)

[video] => Array

(

[browse] => -1 [VideoAdminPassword?] => [path] => /2016 Crystal Lake South Graduation

)

)

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

$_SERVER: Array (

[REDIRECT_STATUS] => 200 [HTTP_HOST] => mythpbesvr01.gschaeferfamily.home [HTTP_CONNECTION] => keep-alive [HTTP_UPGRADE_INSECURE_REQUESTS] => 1 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit?/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 [HTTP_REFERER] => http://mythpbesvr01.gschaeferfamily.home/mythweb/ [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8 [HTTP_COOKIE] => mythweb_id=6oklhmup6lm2tehoh8ofcd79e1 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at mythpbesvr01.gschaeferfamily.home Port 80</address>

[SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu) [SERVER_NAME] => mythpbesvr01.gschaeferfamily.home [SERVER_ADDR] => 10.0.0.221 [SERVER_PORT] => 80 [REMOTE_ADDR] => 10.0.0.101 [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] => 60395 [REDIRECT_URL] => /mythweb/stats [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => [REQUEST_URI] => /stats [SCRIPT_NAME] => /mythweb/mythweb.php [PATH_INFO] => /stats [PATH_TRANSLATED] => /var/www/html/stats [PHP_SELF] => /mythweb/mythweb.php/stats [REQUEST_TIME_FLOAT] => 1472953619.085 [REQUEST_TIME] => 1472953619 [STATUS] => 200 [URL] => /mythweb/stats [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 [error_email] => [gb] => 1073741824 [hostname] => mythpbesvr01 [http_host] => mythpbesvr01.gschaeferfamily.home [kb] => 1024 [max_stars] => 4 [mb] => 1048576 [module] => stats [modules_path] => /usr/share/mythtv/mythweb/modules [num_time_slots] => 36 [prefer_channum] => 1 [root] => /mythweb/ [root_auth_url] => http://mythpbesvr01.gschaeferfamily.home/mythweb/ [root_url] => http://mythpbesvr01.gschaeferfamily.home/mythweb/ [skin] => default [skin_img_url] => http://mythpbesvr01.gschaeferfamily.home/mythweb/skins/default/img/ [skin_url] => http://mythpbesvr01.gschaeferfamily.home/mythweb/skins/default/ [star_character] => &#9733; [stream_url] => http://mythpbesvr01.gschaeferfamily.home:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20 [tmpl] => default [tmpl_dir] => modules/stats/tmpl/default/

)

Change History (2)

comment:1 Changed 3 years ago by sphery

Component: MythTV - GeneralPlugin - MythWeb
Owner: set to Stuart Auchterlonie

see, also, #12713 and #12719

comment:2 Changed 3 years ago by Stuart Auchterlonie

Milestone: unknown0.28.1
Resolution: Duplicate
Status: newclosed

This should already be fixed by #12811, please update your packages. If this is not fixed, feel free to reopen.

Note: See TracTickets for help on using tickets.