Extentions crash site

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
crazynlazyguy
Registered User
Posts: 38
Joined: Tue Jul 19, 2011 5:12 am
Location: Iowa
Name: Matt
Contact:

Extentions crash site

Post by crazynlazyguy »

I keep getting this error when I'm trying to install this extention Actually I get similar errors when I try to install any extension.

Btw this is on a dedicated server running Ubuntu 16.04, mySQL 5.7.18, & php7

Code: Select all

General Error
SQL ERROR [ mysqli ]

Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ffgeeks.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 > 1493604453 OR s.session_user_id <> 1 GROUP BY u.user_id ORDER BY u.username_clean

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/rmcgirr83/activity24hours/event/listener.php
LINE: 186
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/rmcgirr83/activity24hours/event/listener.php
LINE: 100
CALL: rmcgirr83\activity24hours\event\listener->obtain_active_user_data()

FILE: (not given by php)
LINE: (not given by php)
CALL: rmcgirr83\activity24hours\event\listener->display_24_hour_stats()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 235
CALL: phpbb\event\dispatcher->trigger_event()
Last edited by crazynlazyguy on Tue May 02, 2017 2:27 am, edited 1 time in total.
User avatar
3Di
Former Team Member
Posts: 16038
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Extentions crash site

Post by 3Di »

Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
crazynlazyguy
Registered User
Posts: 38
Joined: Tue Jul 19, 2011 5:12 am
Location: Iowa
Name: Matt
Contact:

Re: Extentions crash site

Post by crazynlazyguy »

I see they mention doing the following but doesn't explain where to edit that.

Try changing this

Code: Select all

'GROUP_BY'=> 'u.user_id',
to this

Code: Select all

'GROUP_BY'=> 'u.user_id, s.session_viewonline',
Do I edit that in the ext itself?
User avatar
3Di
Former Team Member
Posts: 16038
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Extentions crash site

Post by 3Di »

crazynlazyguy wrote:
Tue May 02, 2017 2:12 am

Code: Select all

FILE: [ROOT]/ext/rmcgirr83/activity24hours/event/listener.php
Support for extensions is given where you got the extension from, btw. ;)
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
crazynlazyguy
Registered User
Posts: 38
Joined: Tue Jul 19, 2011 5:12 am
Location: Iowa
Name: Matt
Contact:

Re: Extentions crash site

Post by crazynlazyguy »

Thanks for pointing out the obvious. Sorry. I'm tired. haha.

yeah but I'm guessing this problem may repeat itself with each ext i want to install. I hope not but i'm assuming this is a bug due to running php5 and mysql 5.7
User avatar
crazynlazyguy
Registered User
Posts: 38
Joined: Tue Jul 19, 2011 5:12 am
Location: Iowa
Name: Matt
Contact:

Re: Extentions crash site

Post by crazynlazyguy »

Ugh. btw doing that just made it worse. Now the whole site results in a 500 error.

I just recovered from that so clearly that isn't a good fix either.
rxu
Extensions Development Team
Posts: 3400
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation
Name: Ruslan
Contact:

Re: Extentions crash site

Post by rxu »

Taking in account that almost any board action crashes you site, you could try disabling the sql_mode=only_full_group_by MySQL server mode (if you can't, try asking your HSP).
User avatar
crazynlazyguy
Registered User
Posts: 38
Joined: Tue Jul 19, 2011 5:12 am
Location: Iowa
Name: Matt
Contact:

Re: Extentions crash site

Post by crazynlazyguy »

rxu wrote:
Tue May 02, 2017 5:47 am
Taking in account that almost any board action crashes you site, you could try disabling the sql_mode=only_full_group_by MySQL server mode (if you can't, try asking your HSP).
I'll try seeing if I can do that. Btw this is a self hosted linux box I setup.
User avatar
crazynlazyguy
Registered User
Posts: 38
Joined: Tue Jul 19, 2011 5:12 am
Location: Iowa
Name: Matt
Contact:

Re: Extentions crash site

Post by crazynlazyguy »

crazynlazyguy wrote:
Wed May 03, 2017 8:14 pm
rxu wrote:
Tue May 02, 2017 5:47 am
Taking in account that almost any board action crashes you site, you could try disabling the sql_mode=only_full_group_by MySQL server mode (if you can't, try asking your HSP).
I'll try seeing if I can do that. Btw this is a self hosted linux box I setup.
You are a genius! I did this to permanently disable error sql_mode=only_full_group_by:

Code: Select all

sudo nano /etc/mysql/my.cnf
Add this to the end of the file

Code: Select all

[mysqld]  
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Restart MySQL

Code: Select all

sudo service mysql restart
This will disable ONLY_FULL_GROUP_BY for ALL users
Post Reply

Return to “[3.2.x] Support Forum”