Opened 8 years ago
Closed 7 years ago
#12869 closed Bug Report - General (Duplicate)
MythTV Statistics Page Error
| Reported by: | 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
(
)
[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
(
)
[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] => ★ [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 8 years ago by
| Component: | MythTV - General → Plugin - MythWeb |
|---|---|
| Owner: | set to Stuart Auchterlonie |
see, also, #12713 and #12719