Re: PHP 7.1 doesn't work with phpbb 3.2

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
Abrikos
Registered User
Posts: 6
Joined: Sat Nov 03, 2012 12:49 pm

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by Abrikos » Wed Aug 15, 2018 11:17 am

Hello! I made a change to the configuration file: $dbms = 'phpbb\\db\\driver\\mysqli'; and the main page of the forum began to work, but when I try to enter any forum topic, I get the error:

Code: Select all

SQL ERROR [ mysqli ]

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'it-era-forum.w.counter_user' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT w.user_id, w.topic_id, w.counter_user, w.date, u.username, u.user_colour, u.user_id, u.user_avatar, u.user_avatar_type, u.user_avatar_height, u.user_avatar_width, u.user_type, SUM(w.counter_user) AS total FROM phpbb_whovisitedthistopic w, phpbb_users u WHERE w.topic_id = 25 AND w.user_id = u.user_id GROUP BY w.user_id ORDER BY w.date DESC LIMIT 10

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/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
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/dmzx/whovisitedthistopic/event/listener.php
LINE: 201
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: (not given by php)
LINE: (not given by php)
CALL: dmzx\whovisitedthistopic\event\listener->viewtopic_get_post_data()

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]/viewtopic.php
LINE: 1219
CALL: phpbb\event\dispatcher->trigger_event()
I'm using 7.0.30 PHP version and mysqli is installed. How to solve this problem?

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by RMcGirr83 » Wed Aug 15, 2018 11:51 am

FILE: [ROOT]/ext/dmzx/whovisitedthistopic/event/listener.php
LINE: 201
CALL: phpbb\db\driver\factory->sql_query_limit()
uninstall that extension.
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

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: poiu, sakm, Yandex [Bot] and 27 guests