24 Hour Activity Stats

Not compatible with MySQL 5.7 - 24 Hour Activity Stats

Not compatible with MySQL 5.7

by raykai » Wed Jan 04, 2017 11:21 pm

this extention needs a fix for MySQL 5.7

MySQL 5.7 added a new "ONLY_FULL_GROUP_BY" option thats is set by default

this extensions is giving a error :

Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column '_phpbb.s.session_viewonline' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT u.user_id, u.user_colour, u.username, u.user_type, u.user_lastvisit, u.user_allow_viewonline, MAX(s.session_time) as session_time, s.session_viewonline FROM (phpbb_users u) LEFT JOIN phpbb_sessions s ON (s.session_user_id = u.user_id) WHERE u.user_lastvisit > 1483485324 OR s.session_user_id <> 1 GROUP BY u.user_id ORDER BY u.username_clean


Image



Disabling 24 Hour Activity Stats fixes the index error page.
User avatar
raykai
Registered User
Posts: 89
Joined: Tue Apr 09, 2013 5:32 am
Contact:

Re: Not compatible with MySQL 5.7

by raykai » Wed Jan 04, 2017 11:35 pm

phpbb now works with ONLY_FULL_GROUP_BY thats in the new MySQL 5.7 and up i have v5.7.16 just wondering if a fix could be made instead of disabling ONLY_FULL_GROUP_BY in MySQL
i also tested on MySQL v8.0.0 (dev) next v that is coming out at some point. it gives the same error

seams like this ONLY_FULL_GROUP_BY is there to stay must be a reason.

https://tracker.phpbb.com/browse/PHPBB3-14637
https://tracker.phpbb.com/browse/PHPBB3-14782


i like your Mods :) cant wait to use it ones compatible.
User avatar
raykai
Registered User
Posts: 89
Joined: Tue Apr 09, 2013 5:32 am
Contact:

Re: Not compatible with MySQL 5.7

by RMcGirr83 » Thu Jan 05, 2017 11:48 am

Try changing this

'GROUP_BY' => 'u.user_id',

to this

'GROUP_BY' => 'u.user_id, s.session_viewonline',
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Not compatible with MySQL 5.7

by K2 » Sun Apr 02, 2017 11:58 am

Since the OP never came back with verification - this edit works. I'm using php 7.0.x with my board, this edit allows this mod to work.
User avatar
K2
Registered User
Posts: 56
Joined: Fri Jan 03, 2003 5:30 am
Contact:

Re: Not compatible with MySQL 5.7

by crazynlazyguy » Tue May 02, 2017 2:30 am

RMcGirr83 wrote:Try changing this

'GROUP_BY' => 'u.user_id',

to this

'GROUP_BY' => 'u.user_id, s.session_viewonline',
Doing that edit just resulted in the whole website being crashed with a 500 error. That fix didn't work for me!
User avatar
crazynlazyguy
Registered User
Posts: 38
Joined: Tue Jul 19, 2011 5:12 am
Location: Iowa
Name: Matt
Contact:

Re: Not compatible with MySQL 5.7

by RMcGirr83 » Tue May 02, 2017 9:28 am

Then you didn't do it correctly.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Not compatible with MySQL 8.7

by Tastenplayer » Fri May 05, 2017 1:32 pm

Sorry was not my intention - By many Ext. all problems come in the same post!
Last edited by Tastenplayer on Sun May 07, 2017 12:00 pm
My phpBB Style Board & More3.3.0-b2 StyleTBChristmas calendar (Changing style background & song in announcement)
Be the best version of yourself rather than a bad copy of someone else!
Excuse me for my English, but I learned the language by speaking to people and not at school.
User avatar
Tastenplayer
Registered User
Posts: 405
Joined: Thu Jul 03, 2014 9:20 pm
Location: Switzerland
Name: Jutta Koliofotis
Contact:

Re: Not compatible with MySQL 5.7

by RMcGirr83 » Fri May 05, 2017 4:24 pm

I would appreciate it if you wouldn't hijack a topic that has nothing to do with your issue. Please open a new support topic.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact: