24 Hour Activity Stats

General error - 24 Hour Activity Stats

General error

by Stoker 4.0 » Wed Jan 17, 2018 4:46 am

Getting this error on MySQL(i) 5.7.20-0ubuntu0.16.04.1

Code: Select all

Generel error
SQL ERROR [ mysqli ]

Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ulrik.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 > 1516076973 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: 855
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: 190
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/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 161
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/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: 233
CALL: phpbb\event\dispatcher->trigger_event()
User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact:

Re: General error

by RMcGirr83 » Wed Jan 17, 2018 12:13 pm

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: General error

by Stoker 4.0 » Wed Jan 17, 2018 3:33 pm

Thanks, that did the trick
User avatar
Stoker 4.0
Registered User
Posts: 1483
Joined: Sun Feb 13, 2011 1:33 pm
Location: Funen, Denmark
Name: Ulrik Christensen
Contact: