Opened 2 years ago

Closed 2 years ago

Last modified 19 months ago

#13097 closed Bug Report - General (Duplicate)

SQL Error on MythWeb When Viewing Listing or Recorded Programs

Reported by: ctd.mh3@… Owned by: Peter Bennett
Priority: minor Milestone: 0.28.1
Component: MythTV - Web Frontend Version: 0.28.0
Severity: medium Keywords:
Cc: Ticket locked: no

Description

The following error (with details in the attachment) is now shown when selecting "Listening" from the MythWeb UI.

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!!

Similar error occurs when selecting "Recorded Programs":

Fatal Error

!NoTrans: SQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mythconverg.recordedmarkup.data' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by #1055!!

Using latest mythtv from mythbuntu repository.

Attachments (1)

mythsqlissue.txt (10.0 KB) - added by ctd.mh3@… 2 years ago.
SQL Error When Selecting view Listings

Download all attachments as: .zip

Change History (7)

Changed 2 years ago by ctd.mh3@…

Attachment: mythsqlissue.txt added

SQL Error When Selecting view Listings

comment:1 Changed 2 years ago by Peter Bennett

Status: newinfoneeded_new

This was fixed on v0.28 a long time ago. If you update from the fixes ppa you will get the latest fix. If this does not help please provide the version of mythweb and mythtv you are using, full version number from mythutil --version.

comment:2 Changed 2 years ago by Peter Bennett

Owner: changed from stuartm to Peter Bennett

comment:3 Changed 2 years ago by ctd.mh3@…

Looks like I am not on 0.29 yet for some reason. Sorry about that.

mythutil --version Please attach all output as a file in bug reports. MythTV Version : v0.28-2-g15cf421 MythTV Branch : fixes/0.28 Network Protocol : 88 Library API : 0.28.20160309-1 QT Version : 5.5.1 Options compiled in:

linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_crystalhd using_dvb using_firewire using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu using_libcec using_libcrypto using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg using_opengl using_opengl_video using_qtwebkit using_qtscript using_qtdbus using_sdl using_taglib using_v4l2 using_x11 using_xrandr using_xv using_profiletype using_bindings_perl using_bindings_python using_bindings_php using_freetype2 using_mythtranscode using_opengl using_vaapi using_vdpau using_ffmpeg_threads using_mheg using_libass using_libxml2

comment:4 Changed 2 years ago by Peter Bennett

Resolution: Duplicate
Status: infoneeded_newclosed

Dup of #12811 . Update to current 0.28-fixes to get a version that supports the version of MySQL/MariaDB you're using.

comment:5 Changed 2 years ago by Stuart Auchterlonie

Milestone: needs_triage0.28.1
Version: v29.00.28.0

comment:6 Changed 19 months ago by Peter Bennett

Owner: changed from Peter Bennett to Peter Bennett
Note: See TracTickets for help on using tickets.