2016-10-14

I think the upgrade was 90% success as I my wordpress sites still work but my PHPBB3 3.1 did not make it through the upgrade I am having an error here is what I got any idea if its something that needs fixing or tweaking for me with ubuntu like did I miss something in the upgrade or is their now a fault with my phpbb3 3.1 forum

===============

General Error

SQL ERROR [ mysqli ]

Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'forum1.p.post_time' 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.username, u.user_id, u.user_colour, u.user_type, p.poster_id, p.post_time, COUNT(p.post_id) AS total_posts FROM phpbb_users u, phpbb_posts p WHERE u.user_id > 1 AND u.user_id = p.poster_id AND (u.user_type <> 3) AND u.user_id NOT IN (2, 48) AND p.post_time BETWEEN 1475280000 AND 1476415605 GROUP BY u.user_id ORDER BY total_posts DESC, p.post_time DESC, p.post_id DESC LIMIT 1

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/mysql_base.php

LINE: 45

CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php

LINE: 261

CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php

LINE: 321

CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/threedi/tpotm/event/listener.php

LINE: 125

CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: (not given by php)

LINE: (not given by php)

CALL: threedi\tpotm\event\listener->display_tpotm()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php

LINE: 158

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]/includes/functions.php

LINE: 5421

CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/index.php

LINE: 240

CALL: page_footer()

Please notify the board administrator or webmaster:

Show more