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.
Locked
Jacob1985
Registered User
Posts: 2
Joined: Sat Jan 07, 2017 9:38 pm

PHP 7.1 doesn't work with phpbb 3.2

Post by Jacob1985 » Sat Jan 07, 2017 9:45 pm

Thank you for the new 3.2 files. I updated my forum and then chanched php tot 7.1. But phpbb gives the fillowing message:

Code: Select all

SQL ERROR [ mysql4 ]
mysql_connect function does not exist, is mysql extension installed? []
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I use the following settings for php 7.1. DoI need to change something?
Image

User avatar
canonknipser
Registered User
Posts: 2063
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by canonknipser » Sat Jan 07, 2017 9:56 pm

You need to use the mysqli-driver, because mysql-driver is long deprecated (since php 5.4 or similar) and removed in php 7.0

Edit your config.php, add a little "i" at the end of the driver name, save and clear board cache
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

Jacob1985
Registered User
Posts: 2
Joined: Sat Jan 07, 2017 9:38 pm

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by Jacob1985 » Sat Jan 07, 2017 10:05 pm

Thnx! Problem solved!

CD130
Registered User
Posts: 76
Joined: Thu Nov 13, 2014 2:09 pm

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by CD130 » Sun Jan 29, 2017 12:00 pm

PHP 7.0 works fine, but with 7.1 I got this error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

mysqli_connect function does not exist, is mysqli extension installed? []

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I.m using this line in config.php:

Code: Select all

$dbms = 'mysqli';

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25316
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by Paul » Sun Jan 29, 2017 12:19 pm

Do you have the mysqli extension installed in your php installation? :)
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

CD130
Registered User
Posts: 76
Joined: Thu Nov 13, 2014 2:09 pm

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by CD130 » Sun Jan 29, 2017 1:00 pm

Uhm, I seriously don't know. I used the default settings. Is there a way to check this? And how can I install this extension now?

Edit:
I found the PHP extensions in DirectAdmin and I using this options:

PHP 7.0:
7.0.png
PHP 7.1:
7.1.png

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25316
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by Paul » Sun Jan 29, 2017 1:13 pm

It depends, if you have shared hosting you will need to ask yourself. Otherwise, you or will need to enable it in php.ini, or recompile your php with mysqli support or you need to install the mysqli extension from the package manager from the OS.
Server configuration in general is outside the scope of this forum.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

CD130
Registered User
Posts: 76
Joined: Thu Nov 13, 2014 2:09 pm

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by CD130 » Sun Jan 29, 2017 1:16 pm

I used above settings from 7.0 for 7.1 and now it works great! 8-)

Many thanks!!

shar67
Registered User
Posts: 28
Joined: Wed Sep 23, 2015 10:59 pm

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by shar67 » Sat Mar 25, 2017 4:10 am

I was switching from PHP 5.6 on a site to PHP 7.0 and my phpBB board would crash and the instructions for the config.php worked for me as well. So thank you very much!

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:26 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
kinerity
Community Team Member
Community Team Member
Posts: 2330
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: PHP 7.1 doesn't work with phpbb 3.2

Post by kinerity » Wed Aug 15, 2018 12:03 pm

You were already told what to do in your other topic. Please stick to that one. Since the OP has solved their problem, I'll go ahead and close this one.
Kailey Truscott - Community Team

Locked

Return to “[3.2.x] Support Forum”