id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 12869 MythTV Statistics Page Error drmchsr87@… Stuart Auchterlonie "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] =>
Apache/2.4.18 (Ubuntu) Server at mythpbesvr01.gschaeferfamily.home Port 80
[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_list[""user""]: 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] => ★ [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/ ) " Bug Report - General closed minor 0.28.1 Plugin - MythWeb 0.28.0 medium Duplicate 0