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 »

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
Former Team Member
Posts: 22016
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by RMcGirr83 »

FILE: [ROOT]/ext/dmzx/whovisitedthistopic/event/listener.php
LINE: 201
CALL: phpbb\db\driver\factory->sql_query_limit()
uninstall that extension.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
Post Reply

Return to “[3.2.x] Support Forum”