New machine ran out of memory again... I applied tuning settings from the
previous server to MySQL and Apache last night, looks like those settings
might need to change for 16.04. Restarting it now.
On Thu, Nov 10, 2016 at 6:10 AM, S.Brandt <s.bra...@mixxx.org> wrote:
> All down, throws 502 error.
>
> Previously there was forum error 757
>
> ``
> General Error
> SQL ERROR [ mysqli ]
>
> Expression #1 of SELECT list is not in GROUP BY clause and contains
> nonaggregated column 'phpbb.p.post_id' which is not functionally dependent
> on columns in GROUP BY clause; this is incompatible with
> sql_mode=only_full_group_by [1055]
>
> SQL
>
> SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id FROM phpbb_topics t,
> phpbb_posts p WHERE p.poster_id = '11164' AND p.post_approved = 1 AND
> t.topic_id = p.topic_id GROUP BY t.topic_id, t.topic_last_post_time ORDER
> BY t.topic_last_post_time DESC
>
> BACKTRACE
>
> FILE: (not given by php)
> LINE: (not given by php)
> CALL: msg_handler()
>
> FILE: [ROOT]/includes/db/dbal.php
> LINE: 757
> CALL: trigger_error()
>
> FILE: [ROOT]/includes/db/mysqli.php
> LINE: 182
> CALL: dbal->sql_error()
>
> FILE: [ROOT]/includes/search/fulltext_native.php
> LINE: 1009
> CALL: dbal_mysqli->sql_query()
>
> FILE: [ROOT]/search.php
> LINE: 540
> CALL: fulltext_native->author_search
> `
>
> > On Nov 9, 2016, at 22:59, RJ Ryan <rr...@mixxx.org> wrote:
> >
> > Huge thanks to Garth for upgrading the Mixxx website to a modern OS!
> >
> > Things might be broken -- if you see any bugs or missing data, please
> let us know (today's forum outage was unrelated).
> > ------------------------------------------------------------
> ------------------
>
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Get Mixxx, the #1 Free MP3 DJ Mixing software Today
http://mixxx.org
Mixxx-devel mailing list
Mixxx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mixxx-devel
