Opened 8 years ago
Closed 8 years ago
#12829 closed Bug Report - General (Duplicate)
Error en el listado de Mythtv en MythUbuntu 16.04 Released
| Reported by: | 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
(
)
file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/list_data.php line: 102
class: Channel
function: display_programs
type: -> args: Array
(
)
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] => ★ [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
(
)
)
[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] => ★ [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/
)
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.cnfand add at the bottom
sql_mode = NO_ENGINE_SUBSTITUTION