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


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 '' 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 . I edited /etc/mysql/conf.d/mythtv.cnf from:




and rebooted. Thankfully this solved the problem.


Tagged , ,

Written by Vaughan

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

  1. Thank you for your translation of the 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 *