Vaughan Harper's blog MythTV MythTV – MythWeb program: “!!NoTrans: SQL Error…”
MythTV – MythWeb program: “!!NoTrans: SQL Error…”

MythTV

MythTV – MythWeb program: “!!NoTrans: SQL Error…”

I recently installed MythTV using the Mythbuntu 16.04 distribution. All went well until I tried to use MythWeb, where the web browser displayed this error:

     datetime: 2016-07-18 21:20:19 (BST)
     errornum: 256
   error type: User Error
 error string: !!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]!!
 filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
   error line: 98

Fortunately I found the solution at https://code.mythtv.org/trac/ticket/12713 . I edited /etc/mysql/conf.d/mythtv.cnf from:

[mysqld]
bind-address=::

to

[mysqld]
bind-address=::
max_connections=100
sql_mode=NO_ENGINE_SUBSTITUTION

and rebooted. Thankfully this solved the problem.

Vaughan

Tagged , ,

Written by Vaughan

2 thoughts on “MythTV – MythWeb program: “!!NoTrans: SQL Error…”

  1. Thank you for your translation of the code.mythtv.org page. I am capable of editing a text file but understanding mysql-ese is beyond me. I installed a fresh install of Mythbuntu 16.04, yesterday, then ran the updates and had exactly this problem. You solution fixed it, for which I’m grateful.

Leave a Reply

Your email address will not be published. Required fields are marked *