[mythtv-users] Fatal error in new .28 mythbuntu install

[Bert Haskins]

On 10/19/2016 7:02 PM, Jerry wrote:
> On Wed, Oct 19, 2016 at 6:52 PM, Bert Haskins <bhaskins at chartermi.net 
> <mailto:bhaskins at chartermi.net>> wrote:
>
>
>         " 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]!! "
>
>     I thought that everything was going well in a new mythbuntu (x64)
>     ( .28 ) backend install and then this happened when I accessed it
>     from mythweb.
>     I really need some help on this one.
>     Thanks,
>       Bert
>
> A quick google search on that error message finds 
> https://code.mythtv.org/trac/ticket/12811 
> <https://code.mythtv.org/trac/ticket/12811>

I'm a retired engineer and of course, one of the first rules that you 
learn is to change one thing at a time and document the results.
Well I broke that rule because the backend box is a little hard for me 
to get to.
I did
  "A solution to the SQL Fatal Error mentioned above is a tweak to the 
/etc/mysql/conf.d/mythtv.cnf file. Add "sql_mode=NO_ENGINE_SUBSTITUTION" 
(without the quotation marks) to the end of the 
/etc/mysql/conf.d/mythtv.cnf file. I believe the error was caused by an 
incompatibility between mysql 5.7 and databases from older versions of 
mysql."

followed by a apt-get update + upgrade.
The error is gone and the backend appears to be up and running ( big 
major "YES" ).
This is my first real .28 venture and tomorrow I should be able to test 
it with my RP3 also.
If both are up and running I will really be happy.
  Thanks to all,
   Bert

>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20161019/4f3ea132/attachment.html>