SQL Error on MythWeb When Viewing Listing or Recorded Programs

[ctd.mh3@…]

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.

[ctd.mh3@…]

SQL Error When Selecting view Listings

[Peter Bennett]

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.

[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

[Peter Bennett]

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