Error message trying to access my forum

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
Azuwi
Registered User
Posts: 9
Joined: Tue Nov 13, 2018 11:41 am

Error message trying to access my forum

Post by Azuwi » Tue Nov 13, 2018 11:47 am

Get this error message when trying to access my forum url

Code: Select all

General Error
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.
My web host recently updated their PHP to PHP 7.2 and I was running phpBB 3.1.3 before, I've talked to the support and from what I understand, 3.1.3 doesn't support PHPBB 7.2. They temporary set it back to 5.6 so I could fix it and install the new phpbb 3.2.3 version (Full Package)

So I downloaded the PHPBB 3.2.3 and updated it successfully from 3.1.3 to 3.2.3 and now running 3.2.3 (latest update) and they have again set the PHP 7.2 back to default and I get this error. Any idea why the latest version doesn't work with PHP 7.2? Or what have i done wrong?

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7450
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Error message trying to access my forum

Post by JimA » Tue Nov 13, 2018 11:50 am

Hi, welcome to phpBB! :)

This is most likely because of one simple line in your config.php file.
Could you see if changing the mysql to mysqli in that file changes anything?
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

Azuwi
Registered User
Posts: 9
Joined: Tue Nov 13, 2018 11:41 am

Re: Error message trying to access my forum

Post by Azuwi » Tue Nov 13, 2018 11:56 am

Thanks for a quick reply!

I have changed the code

Code: Select all

$dbms = 'mysql';
to

Code: Select all

$dbms = 'mysqli';
Should it fix it?

User avatar
warmweer
Registered User
Posts: 1421
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Error message trying to access my forum

Post by warmweer » Tue Nov 13, 2018 12:00 pm

Azuwi wrote:
Tue Nov 13, 2018 11:56 am

Code: Select all

$dbms = 'mysqli';
Should it fix it?
There's a simple way to find out.
And I'm willing to bet 5€ that it will. 8-)
A bug is a feature that hasn't made it to the manual (yet)

Azuwi
Registered User
Posts: 9
Joined: Tue Nov 13, 2018 11:41 am

Re: Error message trying to access my forum

Post by Azuwi » Tue Nov 13, 2018 12:04 pm

It works now.

Now i'm just questioning why doesn't it say in any update guide to change the mysql to mysqli?

User avatar
warmweer
Registered User
Posts: 1421
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Error message trying to access my forum

Post by warmweer » Tue Nov 13, 2018 12:26 pm

Azuwi wrote:
Tue Nov 13, 2018 12:04 pm
Now i'm just questioning why doesn't it say in any update guide to change the mysql to mysqli?
Perhaps because this error only comes up with php7.2 (perhaps as of 7.0). And in that case it won't be a problem for the upgrade itself (since that ran on 5.6) and will only occur after the switch (php-version).
Personally I think it's such a small thing that it's not worthwhile checking this on startup of phpBB itself, but a note in the upgrade instructions (or transfer) wouldn't be worthless. (OK, I'll put in in a more positive way: it would be useful and could limit the number of related support requests, although ... I have my doubts about that last part.)
A bug is a feature that hasn't made it to the manual (yet)

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7450
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Error message trying to access my forum

Post by JimA » Tue Nov 13, 2018 12:30 pm

Azuwi wrote:
Tue Nov 13, 2018 12:04 pm
Now i'm just questioning why doesn't it say in any update guide to change the mysql to mysqli?
Glad to hear you've got your problems resolved.

In fact, the MySQL extension for PHP had been deprecated since PHP5.5, so hosts should have long moved on to only supporting mysqli. Since PHP 7.0 it's been officially removed. Since this is really a host-related issue (which extensions they allow for databases and PHP) we can't put this in any official guide, every situation is different.

However, since One.com (and possibly other major hosts) have started switching this up without informing users, we should probably have a sticky topic somewhere detailing this so that it's easier to find for users with a similar problem. Thanks for the suggestion, we'll look into that. :)
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

User avatar
david63
Jr. Extension Validator
Posts: 15048
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Error message trying to access my forum

Post by david63 » Tue Nov 13, 2018 12:32 pm

JimA wrote:
Tue Nov 13, 2018 12:30 pm
... we should probably have a sticky topic somewhere detailing this so that it's easier to find for users with a similar problem.
Assuming that they look :roll: :roll: :roll:
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

Azuwi
Registered User
Posts: 9
Joined: Tue Nov 13, 2018 11:41 am

Re: Error message trying to access my forum

Post by Azuwi » Tue Nov 13, 2018 1:11 pm

JimA wrote:
Tue Nov 13, 2018 12:30 pm
Azuwi wrote:
Tue Nov 13, 2018 12:04 pm
Now i'm just questioning why doesn't it say in any update guide to change the mysql to mysqli?
Glad to hear you've got your problems resolved.

In fact, the MySQL extension for PHP had been deprecated since PHP5.5, so hosts should have long moved on to only supporting mysqli. Since PHP 7.0 it's been officially removed. Since this is really a host-related issue (which extensions they allow for databases and PHP) we can't put this in any official guide, every situation is different.

However, since One.com (and possibly other major hosts) have started switching this up without informing users, we should probably have a sticky topic somewhere detailing this so that it's easier to find for users with a similar problem. Thanks for the suggestion, we'll look into that. :)
Thanks, I thought all major web hotels now run PHP 7.0, 7.1 or 7.2

User avatar
warmweer
Registered User
Posts: 1421
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Error message trying to access my forum

Post by warmweer » Tue Nov 13, 2018 3:12 pm

Azuwi wrote:
Tue Nov 13, 2018 1:11 pm
Thanks, I thought all major web hotels now run PHP 7.0, 7.1 or 7.2
They do, but they still offer php 5.6 (sometimes even 5.5) so that clients can update/upgrade their site before those php versions are removed).
A bug is a feature that hasn't made it to the manual (yet)

Azuwi
Registered User
Posts: 9
Joined: Tue Nov 13, 2018 11:41 am

Re: Error message trying to access my forum

Post by Azuwi » Tue Nov 13, 2018 3:30 pm

warmweer wrote:
Tue Nov 13, 2018 3:12 pm
Azuwi wrote:
Tue Nov 13, 2018 1:11 pm
Thanks, I thought all major web hotels now run PHP 7.0, 7.1 or 7.2
They do, but they still offer php 5.6 (sometimes even 5.5) so that clients can update/upgrade their site before those php versions are removed).
Yes I was lucky, because my host remove 5.6 in December 3rd.

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Bermudez, capherla, digitallyup, FlaSerIC, Frank Rizzo, KokkinoVelos, rleeden and 41 guests