Issue with PHP upgrade from 5.6.15 to 7.1.18

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
User avatar
shortmort37
Registered User
Posts: 400
Joined: Sat Aug 26, 2006 8:40 pm

Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by shortmort37 » Mon Jun 18, 2018 12:37 am

I'm running a 3.2.1 board, and I'm interested in employing an extension that requires PHP 7.x. I understand I can't go to 7.2.6 without upgrading my board to 3.2.2; I'll get around to it, but not just now.

In my desktop XAMPP test environment, phpinfo.php is reporting a successful PHP 7.1.18 install. I changed $dbms = 'mysql'; to $dbms = 'mysqli'; in config.php, and purged the cache - but I'm getting the dreaded:
General Error
SQL ERROR [ mysqli ]

mysqli_connect function does not exist, is mysqli extension installed? []
phpinfo.php reports that mysqlnd is installed, but not mysqli. Does mysqlnd provide support for mysqli calls?

In any event, I'm at a loss as to next steps. Can anyone advise?

Thanks
Dan

User avatar
3Di
Registered User
Posts: 12994
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by 3Di » Mon Jun 18, 2018 12:47 am

shortmort37 wrote:
Mon Jun 18, 2018 12:37 am
Does mysqlnd provide support for mysqli calls?
https://secure.php.net/manual/en/mysqlnd.overview.php

You need to install the mysqli extension.

On a side note, google gives you this kind of answers in a sec., which aren't phpBB Support's specific IMO. ;)
https://stackoverflow.com/questions/121 ... s#12170432
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate

:game_die: VIP º The best Dice Roller extension around for phpBB 3.2 is out, test it! :game_die:

Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

User avatar
shortmort37
Registered User
Posts: 400
Joined: Sat Aug 26, 2006 8:40 pm

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by shortmort37 » Mon Jun 18, 2018 1:07 am

Before I posted here, and when I googled it, I read that mysqli was part of 7.x versions of PHP. When I googled "xampp how to install mysqli", I was directed to make sure that this line was in php.ini: extension=php_mysqli.dll

It is.

IMHO, I think at that point I have a phpBB specific question.

User avatar
3Di
Registered User
Posts: 12994
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by 3Di » Mon Jun 18, 2018 1:12 am

Is it extension=php_mysqli.dll or ;extension=php_mysqli.dll ? In the php.ini of PHP 7.1.xx I mean.

All of the recent versions of xammp have as per default this .dll enabled BTW.
shortmort37 wrote:
Mon Jun 18, 2018 12:37 am
phpinfo.php reports that mysqlnd is installed, but not mysqli.
Simply it is not installed, and the error speaks book.

This is my Wamp64 (not Xammp but's the same soup) configuration for PHP 7.1.16, you can see the mysqli extension installed.
.
PHP716.png
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate

:game_die: VIP º The best Dice Roller extension around for phpBB 3.2 is out, test it! :game_die:

Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

User avatar
Mick
Support Team Member
Support Team Member
Posts: 20237
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by Mick » Mon Jun 18, 2018 9:08 am

shortmort37 wrote:
Mon Jun 18, 2018 1:07 am
I read that mysqli was part of 7.x versions of PHP
The mysqli driver has been around since PHP version 5, it’s nothing new.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.

User avatar
shortmort37
Registered User
Posts: 400
Joined: Sat Aug 26, 2006 8:40 pm

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by shortmort37 » Mon Jun 18, 2018 11:17 am

3Di wrote:
Mon Jun 18, 2018 1:12 am
Is it extension=php_mysqli.dll or ;extension=php_mysqli.dll ? In the php.ini of PHP 7.1.xx I mean.

All of the recent versions of xammp have as per default this .dll enabled BTW.
It's enabled:
Capture.JPG
And the .dll is there, in the php/ext directory. And it's defined in my board config.php:

//$dbms = 'mysql';
$dbms = 'mysqli';

3Di wrote:
Mon Jun 18, 2018 1:12 am
shortmort37 wrote:
Mon Jun 18, 2018 12:37 am
phpinfo.php reports that mysqlnd is installed, but not mysqli.
Simply it is not installed, and the error speaks book.

This is my Wamp64 (not Xammp but's the same soup) configuration for PHP 7.1.16, you can see the mysqli extension installed.
Yeah. Well, I'm not aware of a way to list installed extensions with XAMPP. But it's enabled in php.ini, and the .dll is present in my environment. I just don't know what I'm missing.
Last edited by shortmort37 on Mon Jun 18, 2018 11:51 am, edited 1 time in total.

User avatar
shortmort37
Registered User
Posts: 400
Joined: Sat Aug 26, 2006 8:40 pm

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by shortmort37 » Mon Jun 18, 2018 11:22 am

Mick wrote:
Mon Jun 18, 2018 9:08 am
The mysqli driver has been around since PHP version 5, it’s nothing new.
Yes, this from here:
PHP 5.3.0 and newer

On Windows, for PHP versions 5.3 and newer, the mysqli extension is enabled and uses the MySQL Native Driver by default. This means you don't need to worry about configuring access to libmysql.dll.
I'm missing something - and it's staring me in the face. I just don't know what it is.

User avatar
GanstaZ
Registered User
Posts: 566
Joined: Wed Oct 11, 2017 10:29 pm
Location: Zverse

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by GanstaZ » Mon Jun 18, 2018 3:04 pm

Did you restart your server and everything that can be restarted? Sometimes a simple restart can light a candle.
"When answer lies in the question,.. question becomes redundant!"

User avatar
shortmort37
Registered User
Posts: 400
Joined: Sat Aug 26, 2006 8:40 pm

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by shortmort37 » Mon Jun 18, 2018 3:30 pm

Yup. After a stop/start in the XAMPP console for both MySQL and Apache, I rebooted my PC. Still no love.

User avatar
3Di
Registered User
Posts: 12994
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by 3Di » Mon Jun 18, 2018 7:56 pm

shortmort37 wrote:
Mon Jun 18, 2018 11:17 am
And it's defined in my board config.php:

//$dbms = 'mysql';
$dbms = 'mysqli';

$dbms = 'phpbb\\db\\driver\\mysqli';
The right config.php for 3.2.xx and MySql(i) wrote:
<?php
// phpBB 3.2.x auto-generated configuration file
// Do not change anything in this file!
$dbhost = 'localhost';
$dbport = '';
$dbname = 'xxx';
$dbuser = 'xxx';
$dbpasswd = 'xxx';
$table_prefix = 'phpbb_';
$dbms = 'phpbb\\db\\driver\\mysqli';
$acm_type = 'phpbb\\cache\\driver\\file';
$phpbb_adm_relative_path = 'adm/';

@define('PHPBB_INSTALLED', true);
@define('DEBUG', true);
@define('PHPBB_ENVIRONMENT', 'production');
@define('DEBUG_CONTAINER', true);
@define('PHPBB_DISPLAY_LOAD_TIME', true);
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate

:game_die: VIP º The best Dice Roller extension around for phpBB 3.2 is out, test it! :game_die:

Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

User avatar
shortmort37
Registered User
Posts: 400
Joined: Sat Aug 26, 2006 8:40 pm

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by shortmort37 » Tue Jun 19, 2018 1:08 am

3Di wrote:
Mon Jun 18, 2018 7:56 pm
$dbms = 'phpbb\\db\\driver\\mysqli';
Actually, I had tried that, and commented it out - but tried again, for the sake of completeness:

Capture.JPG
Capture.JPG (17.11 KiB) Viewed 223 times
Still no love.

User avatar
3Di
Registered User
Posts: 12994
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Issue with PHP upgrade from 5.6.15 to 7.1.18

Post by 3Di » Tue Jun 19, 2018 2:38 am

shortmort37 wrote:
Mon Jun 18, 2018 11:17 am
Well, I'm not aware of a way to list installed extensions with XAMPP.
XAMMP it's a server, like the one where you are hosting your site. And it works like a server.. ofcourse.

Simple script to be run in order to get the list of the names of all the modules compiled and loaded in the PHP.

Code: Select all

<?php
print_r(get_loaded_extensions());
Again, that's not a phpBB issue.
Try installing, on your xammp, a fresh 3.2.2.

I can't help you more.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate

:game_die: VIP º The best Dice Roller extension around for phpBB 3.2 is out, test it! :game_die:

Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: canonknipser, Forex Station, Lady_G, lopoto, Michael235 and 25 guests