Opened 3 years ago

Closed 3 years ago

#12829 closed Bug Report - General (Duplicate)

Error en el listado de Mythtv en MythUbuntu 16.04 Released

Reported by: kevin.carrera@… Owned by: stuartm
Priority: critical Milestone: unknown
Component: MythTV - Web Frontend Version: 0.28.0
Severity: high Keywords:
Cc: Ticket locked: no

Description

datetime: 2016-07-19 12:58:42 (PET)

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='1001' AND (program.endtime > FROM_UNIXTIME('1468950300') AND program.starttime < FROM_UNIXTIME('1468961100') 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] => 1468950300 [1] => 1468961100 [2] => 1001

)

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

class: Channel

function: display_programs

type: -> args: Array

(

[0] => 1468950300 [1] => 1468961100

)

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

)

)

)

[last] => Array

(

[0] => mythweb [1] => session

)

)

[backend] => Array

(

[timezone] => Array

(

[value] => America/Lima? [last_check_time] => 1468879949

)

[192.168.1.3] => Array

(

[proto_version] => Array

(

[last_check_version] => 88 [last_check_time] => 1468947676

)

)

)

[language] => Spanish [date_statusbar] => %b %e, %Y, %I:%M %p [date_scheduled] => %b %e, %Y (%I:%M %p) [date_scheduled_popup] => %b %e, %Y [date_recorded] => %b %e, %Y (%I:%M %p) [date_search] => %b %e, %Y, %I:%M %p [date_listing_key] => %b %e, %Y, %I:%M %p [date_listing_jump] => %b %e, %Y [date_channel_jump] => %b %e, %Y [date_job_status] => %b %e, %Y, %I:%M %p [time_format] => %I:%M %p [remote] => Array

(

[frontends] => Array ( ) [type] => keys

)

[tv] => Array

(

[last] => Array

(

[0] => list

)

)

[list_time] => 1468950300 [scheduled_recordings] => Array

(

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

)

[] => Array ( ) [recorded_sortby] => Array

(

[0] => Array

(

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

)

[1] => Array

(

[field] => title [reverse] =>

)

)

[schedules_sortby] => Array

(

[0] => Array

(

[field] => airdate [reverse] =>

)

[1] => Array

(

[field] => title [reverse] =>

)

)

)

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

$_SERVER: Array (

[REDIRECT_STATUS] => 200 [HTTP_HOST] => 192.168.1.3 [HTTP_CONNECTION] => keep-alive [HTTP_CACHE_CONTROL] => max-age=0 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1 [HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit?/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 [HTTP_REFERER] => http://192.168.1.3/mythweb/tv/schedules/custom [HTTP_ACCEPT_ENCODING] => gzip, deflate, sdch [HTTP_ACCEPT_LANGUAGE] => es-ES,es;q=0.8 [HTTP_COOKIE] => mythweb_id=oi6kkg6r39odftb45ju14m1jv0 [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.1.3 Port 80</address>

[SERVER_SOFTWARE] => Apache/2.4.18 (Ubuntu) [SERVER_NAME] => 192.168.1.3 [SERVER_ADDR] => 192.168.1.3 [SERVER_PORT] => 80 [REMOTE_ADDR] => 192.168.1.159 [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] => 38841 [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] => 1468951122.678 [REQUEST_TIME] => 1468951122 [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] => mythtv03 [http_host] => 192.168.1.3 [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.1.3/mythweb/ [root_url] => http://192.168.1.3/mythweb/ [searchtype_keyword] => 3 [searchtype_manual] => 5 [searchtype_people] => 4 [searchtype_power] => 1 [searchtype_title] => 2 [skin] => default [skin_img_url] => http://192.168.1.3/mythweb/skins/default/img/ [skin_url] => http://192.168.1.3/mythweb/skins/default/ [star_character] => &#9733; [stream_url] => http://192.168.1.3:80//mythweb/ [tb] => 1099511627776 [timeslot_blocks] => 3 [timeslot_size] => 300 [timeslotbar_skip] => 20 [tmpl] => default [tmpl_dir] => modules/tv/tmpl/default/

)

Change History (3)

comment:1 Changed 3 years ago by paulh

Hopefully you speak enough English to understand this :)

I've just come across a similar problem while working on another project.

By default the newer versions of Mysql are quite strict about the SQL they will accept but you can make it more accepting by tweaking the sql_mode setting.

So basically you need to remove ONLY_FULL_GROUP_BY from the sql_mode setting. Easiest way is to edit

/etc/mysql/mysql.conf.d/mysqld.cnf

and add at the bottom

sql_mode = NO_ENGINE_SUBSTITUTION

You will have to restart MySql? for the new setting to take effect

Last edited 3 years ago by paulh (previous) (diff)

comment:2 Changed 3 years ago by ande3283@…

I updated to 16.04 this morning and have the same error message as above. I tried the fix given and restarted MySql?. The problem still exists.

comment:3 Changed 3 years ago by sphery

Resolution: Duplicate
Status: newclosed
Note: See TracTickets for help on using tickets.