Kernel has been updated from 4.4.0.45 to 4.4.0.47, RAM increased from 768MB
to 1GB, and a second virtual cpu has been added to the VM... It's back up
and running for now. :\
On Thu, Nov 10, 2016 at 9:36 AM, Garth Dahlstrom <ga...@mixxx.org> wrote:
> 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
