[mythtv-users] Getting GUI Error message, when opening the MythTV Browser page.

Stephen Worthington stephen_agent at jsw.gen.nz
Sat May 11 05:05:44 UTC 2019

Previous message (by thread): [mythtv-users] Getting GUI Error message, when opening the MythTV Browser page.
Next message (by thread): [mythtv-users] Getting GUI Error message, when opening the MythTV Browser page.
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Sat, 11 May 2019 16:48:50 +1200, you wrote:


>I was too quick, after a second look the GUI loads, but there are Errors on
>the
>
>Under Listings and Upcoming Recordings I get a browser message like :
>
>Fatal Error
>
>!!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]!!
>
>If you choose to * submit a bug report
><http://svn.mythtv.org/trac/newticket>* please make sure to include a brief
>description of what you were doing, along with the following backtrace as
>an attachment *(please don\'t just paste the whole thing into the ticket)*
>datetime: 2019-05-10 12:14:08 (CEST) 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='13003' AND (program.endtime > FROM_UNIXTIME('1557482400')
>AND program.starttime < FROM_UNIXTIME('1557493200') 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] => 1557482400 [1]
>=> 1557493200 [2] => 13003 ) file:
>/usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php line: 102
>class: Channel function: display_programs type: -> args: Array ( [0] =>
>1557482400 [1] => 1557493200 ) 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 )
>==========================================================================
>$_DEBUG: Array ( [Database Warnings] => Array ( [0] => Array ( [Query] =>
>SELECT MIN(channel.chanid) AS chanid, channel.channum, channel.callsign
>FROM channel WHERE channel.visible = 1 GROUP BY channel.channum,
>channel.callsign ORDER BY (channel.channum + 0), channel.channum [Warnings]
>=> Array ( [0] => Array ( [#] => 1292 [MSG] => Truncated incorrect DOUBLE
>value: '_28666' ) [1] => Array ( [#] => 1292 [MSG] => Truncated incorrect
>DOUBLE value: '_12135' ) [2] => Array ( [#] => 1292 [MSG] => Truncated
>incorrect DOUBLE value: '_19' ) [3] => Array ( [#] => 1292 [MSG] =>
>Truncated incorrect DOUBLE value: '_26' ) [4] => Array ( [#] => 1292 [MSG]
>=> Truncated incorrect DOUBLE value: '_10004' ) ) ) ) )
>==========================================================================
>$_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] => video [1]
>=> settings ) [host] => linux ) [backend] => Array ( [192.168.178.32] =>
>Array ( [proto_version] => Array ( [last_check_version] => 88
>[last_check_time] => 1557480591 ) ) [timezone] => Array ( [value] =>
>Europe/Berlin [last_check_time] => 1557480591 ) ) [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 ) [show_advanced_schedule] => 1 ) [recorded_sortby] => Array (
>[0] => Array ( [field] => airdate [reverse] => 1 ) [1] => Array ( [field]
>=> title [reverse] => ) ) [scheduled_recordings] => Array (
>[disp_scheduled] => 1 [disp_duplicates] => 1 [disp_deactivated] => 1
>[disp_conflicts] => 1 [disp_recgroup] => [disp_title] => )
>[scheduled_sortby] => Array ( [0] => Array ( [field] => airdate [reverse]
>=> ) [1] => Array ( [field] => title [reverse] => ) ) [search] => Array (
>[type] => q [s] => tom hardy [ctype] => Array ( [0] => [1] => movie [2] =>
>series [3] => sports [4] => tvshow ) [categories] => Array ( ) [stars_gt]
>=> 0 [stars_lt] => 1 [starttime] => now [endtime] => + 2 weeks [as] =>
>Array ( [0] => ) [af] => Array ( [0] => Array ( [0] => title ) ) [aj] =>
>Array ( [0] => AND ) ) [search_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 ) [list_time] =>
>1557482400 [recorded_title] => [recorded_recgroup] => [] => Array ( )
>[schedules_sortby] => Array ( [0] => Array ( [field] => airdate [reverse]
>=> ) [1] => Array ( [field] => title [reverse] => ) ) )
>==========================================================================
>$_SERVER: Array ( [REDIRECT_STATUS] => 200 [HTTP_HOST] => mythbox
>[HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:66.0)
>Gecko/20100101 Firefox/66.0 [HTTP_ACCEPT] =>
>text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
>[HTTP_ACCEPT_LANGUAGE] => en-US,de-DE;q=0.8,en;q=0.5,de;q=0.3
>[HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_REFERER] =>
>http://mythbox/mythweb/status [HTTP_DNT] => 1 [HTTP_CONNECTION] =>
>keep-alive [HTTP_COOKIE] => mythweb_id=do3624m9mjvgt53ikoko96sbm1
>[HTTP_UPGRADE_INSECURE_REQUESTS] => 1 [PATH] =>
>/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
>[SERVER_SIGNATURE] => <address>Apache/2.4.18 (Ubuntu) Server at mythbox
>Port 80</address> [SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu) [SERVER_NAME]
>=> mythbox [SERVER_ADDR] => 192.168.178.32 [SERVER_PORT] => 80
>[REMOTE_ADDR] => 192.168.178.45 [DOCUMENT_ROOT] => /var/www/html
>[REQUEST_SCHEME] => http [CONTEXT_PREFIX] => [CONTEXT_DOCUMENT_ROOT] =>
>/var/www/html [SERVER_ADMIN] => webmaster at localhost [SCRIPT_FILENAME] =>
>/var/www/html/mythweb/mythweb.php [REMOTE_PORT] => 61102 [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] => 1557483248.087
>[REQUEST_TIME] => 1557483248 [STATUS] => 200 [URL] => /mythweb/tv/list
>[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 [dupsin_all] => 15 [dupsin_newepisodes] => 16 [dupsin_oldrecorded] =>
>2 [dupsin_recorded] => 1 [error_email] => [gb] => 1073741824 [hostname] =>
>mythbox [http_host] => mythbox [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://mythbox/mythweb/ [root_url] => http://mythbox/mythweb/
>[searchtype_keyword] => 3 [searchtype_manual] => 5 [searchtype_people] => 4
>[searchtype_power] => 1 [searchtype_title] => 2 [skin] => default
>[skin_img_url] => http://mythbox/mythweb/skins/default/img/ [skin_url] =>
>http://mythbox/mythweb/skins/default/ [star_character] => ★
>[stream_url] => http://mythbox:80//mythweb/ [tb] => 1099511627776
>[timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20
>[tmpl] => default [tmpl_dir] => modules/tv/tmpl/default/ )
>
>
>
>    datetime:  2019-05-10 12:14:08 (CEST)
>    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,

I am not sure why you are having all these problems with the MySQL
setup, but this one is likely just more of the same.  Take a look at
this page:

https://stackoverflow.com/questions/23921117/disable-only-full-group-by

So the first thing to do is to run the mysql command as root and see
what this command shows:

select @@sql_mode

I think that one of the options it will show will be the
ONLY_FULL_GROUP_BY one.  Depending on where it is in the options
string, you will need to include or not include a comma character to
correctly edit the sql_mode string with REPLACE as shown on that page.
Then, without restarting MySQL, see if that fixes your problem.  If
so, then see what happens when you restart MySQL - if that option is
back again, see that page for how to do a permanent fix.

Personally, I now use MariaDB instead of MySQL and that seems likely
to be why I have not met this problem.  I do recommend MariaDB over
MySQL these days, but converting to use MariaDB once you already have
MythTV installed is a pain - the packages have their dependencies set
up badly and most of the MythTV packages get uninstalled, and then
MariaDB tells you that it is unable to convert the mythconverg
database and deletes it.  So if you do want to try to swap to MariaDB,
the way to do it is to first backup the MythTV database using
mythconverg_backup.pl, then shut down MythTV and MySQL and install the
MariaDB client and server packages.  That will uninstall most of
MythTV when it uninstalls MySQL, but that is fine.  Once MariaDB is
installed, just reinstall all the MythTV packages, then restore the
MythTV databases, run the mysql command as root and do the GRANT
commands and then it should all work again.

Previous message (by thread): [mythtv-users] Getting GUI Error message, when opening the MythTV Browser page.
Next message (by thread): [mythtv-users] Getting GUI Error message, when opening the MythTV Browser page.
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the mythtv-users mailing list